August 23, 2008 at 7:07 am
I'm using a stored procedure to display data in a report. I haven't created the report yet, but I want the data to display in sort of a datalist way...
MAKE MODEL YEAR PRICE
Honda
Cr-V
98 $10,000
99 $12,000
00 $15,000
Civic
..
Accord
..
Ford
Focus
..
The maker and model both reside in the same table, the year and price reside in different tables. Right now I've just been including everything within one query to retrieve the data to be displayed. My only problem is that the make and model will be retrieved the same amount of times the year and price will. I'm using (will be using) an rdlc file for my report. Is there a way to tell the report to only display the make and model once for the grouped years? I don't want one make and model displayed with one year and price. I hope that makes sense.
Thanks,
M
August 25, 2008 at 3:52 am
I'm using Visual Studio to create reports. There is a property called "HideDuplicates" that can be switched on that will give the results you are looking for.
August 26, 2008 at 1:06 pm
Try the Matrix tool. Should do exactly what you are looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply