x

SSRS 2005 model change

Hi

I have a number of sdml's within my SSRS solution. On occasion, the view behind the .dsv changes. Most of these changes are based on int and decimal therefore users require the total, avg, min and max agrregates.

When you 1st create a model all these fancy features are auto-generated (which in most cases is fine), but when adding addition field to the model I am unable fine this option (tried running the "autogenerate" function again to no avail).

There anyway to auto generate these aggregates after the sdml has been created?

more ▼

asked Dec 07, 2009 at 11:25 AM in Default

sp_lock gravatar image

sp_lock
9.2k 25 28 31

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I sorted this...

Was my muppetry!!!

If you...

  • added the columns to the sql view. -
  • Refresh the dsv.
  • run autogenerate.

This creates the new fields with the aggregates.

What I was doing was adding the top level fiels (binded to the dsv) and then trying to autogenterate! Doing this way doesnt generate the aggregates after the field is added.

Sorry chaps!

more ▼

answered Dec 07, 2009 at 09:05 PM

sp_lock gravatar image

sp_lock
9.2k 25 28 31

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x554
x35
x6

asked: Dec 07, 2009 at 11:25 AM

Seen: 1017 times

Last Updated: Dec 07, 2009 at 11:25 AM