Report Builder - Numeric Aggregate Aggravation

So I'm building a report model containing several 8 or so numeric amounts. All amounts are numeric(10,2), and there is nothing that would differentiate the columns other than their names.

One of the columns WILL NOT generate any aggregates. It just appears as an attribute. It's inexplicable.

I've even tried to build a model containing just this one numeric attribute, and it still does not work!! VS just hates this one element! Anyone seen anything like this?

I'm running VS 2005 Sp1.

Ah, the beauties of "automagic" model generation. :)

In this case, model generation thinks it's an "ID" column because it's numeric and it ends in "id", so it doesn't bother to generate aggregates. You'll have to do it manually, or change the name temporarily to fool it.

|||

WHAAAAAAAAAAAAAAATTTTTT?

What genius came up with that! Any why would an ID field be numeric 10,2!!

Thank you thank you thank you!

And how do you do manual specification of aggregates in the model?

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...