Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2008-10-31 : 18:22:45
|
| HI,Please help!!!!!!! I have a matrix report that i'm using a parameter to pass data and everything works fine, except it tend to group things together. I don't want it to group.Here's my code:select top 10 ndc,drg_desc,proc_code_cpt,proc_desc,sum(reimb) as reimbfrom dbo.dme_alldmewhere svcmo between '200701' and '200712'and types=@typegroup by ndc,drg_desc, proc_code_cpt,proc_descorder by reimb desc--------types:claimsvisionhearing-----------The result I got when I hit run the in the report:I click Claims in the parameter,it gives me top 10 data.I change it to vision, it will only give me top 1.----------How do i fix this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-01 : 02:26:27
|
| what are groupings you apply in matrix? column and row groups i'm asking |
 |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2008-11-03 : 11:27:31
|
| Actually, I've figure it out. I have to have two rows group. One for the NDC and one for the Proc Code Cpt. Thanks.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-03 : 11:36:06
|
cool ..  |
|
|
|
|
|
|
Group in Matrix doesn't work as expected