Reportviewer control does not render my report correctly
I'm having a strange issue with a 2008 tablix-style report. The report works perfectly in BI studio 2008 and also when deployed to a report server. But when I add the report to our web site project and view it with the 10.0.0.0 report viewer control, a row group does not render correctly. One of the columns that should show distinct values (a separate row per value) is showing #Error instead. Here's a mockup of what I'm experiencing, just to demonstrate: Again, there doesn't seem to be anything wrong with the report, just with how the Report Viewer control (10.0.0.0) is rendering it. I have also confirmed that there is no difference with the stored procedure call and resulting data set when viewing the report on the website with the control or in BI studio or on the Report Server. Any ideas about how to make this work?
June 25th, 2012 2:41pm

Posting my own answer in case it helps someone else...this turned out to be a case-sensitivity issue. In my Data Set, the field that wasn't grouping properly looked like this: <Field Name="Shop"> <DataField>Shop</DataField> <rd:UserDefined>true</rd:UserDefined> </Field> The stored procedure that returned the data was not capitalized, returning the value as "shop". BI Studio and the Report Server are smart enough to figure out that Shop and shop are the same, thing, but the Report Viewer control isn't. Changing the Data Set to this made the report render correctly with the Report Viewer control: <Field Name="Shop"> <DataField>shop</DataField> <rd:UserDefined>true</rd:UserDefined> </Field>
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2012 7:09am

Hi ksw27, Thank you for posting and sharing your answer. I believe your solution will help more people who face with the same issue. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.
July 14th, 2012 5:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics