Friday, February 24, 2012

Final Model

I am creating a report model and have to keep going back and forth between VS2005 and Report Builder to see what the "Final" report is going to look like. I am using folders to group together some really nasty list of fields, denormalizing lookup tables, etc. Is there any way to see this without having to reload Report Builder each time? I have thought about an XSLT for the SMDL, but that is some seriously ugly XML (especially with the denormalizations).

R

If you leave RB open, create a new report based on some other model, then create a report on the model you're working on again, it will clear the cache and you will see your changes.

Inside Model Designer, you can edit the Expression property of any attribute, and the formula dialog will have a model explorer showing all your most recent changes. However, it will be rooted on the entity to which that attribute belongs, so it may take some navigation to see changes you've made to another entity.

Hope that helps!

No comments:

Post a Comment