Column totals in grouped reports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Column totals in grouped reports

Column totals in grouped reports

Rate Topic

Display Mode

Topic Options

Author

Message

jgluszak

Posted Tuesday, March 19, 2013 12:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 2:58 PM
Points: 3, Visits: 23

OK - I've tried everything I can think of to fix this but nothing is working. Here's the issue; I have created a report that is sums building square footage grouped by market. the client wants the excel export in whole numbers so I put in a round function, with and w/o midpointrounding.away fromzero and then tried (format N0) each returns the whole number. So far so good. However when I total the group the value is sometimes spot on and sometimes off because of the rounding. I tried rounding the group total, etc., but no combination of rounding/formattting seems to work. I thought of going into the underlying sql and create a new dataset for the totals, but not sure that wouldn't have the same issue, besides it is a pain given all the colums subtotals and totals I am dealing with. Anyone else encountered this? How did you solve it?

Thanks, John

Post #1432838

jgluszak

Posted Tuesday, March 19, 2013 1:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 2:58 PM
Points: 3, Visits: 23

sorry meant to post this in 2008

Post #1432878

« Prev Topic | Next Topic »

Permissions