March 14, 2007 at 12:06 am
I've been playing with SSRS for a few months now and am coming up against some limitations. In case you haven't used Crystal Reports, here's some info. If you have, bear with me. In Crystal, you can define formulas. So for example, I might say "if percent < 90 then bgcolor = green", and save that formula as PercentColor. I can then apply that formula in several places and change it in only *one*. I have some aggregations coming from my Analysis cube which give me a table with, say, a detail row and five aggregates (group headers). As I have it today, I need to set my background colour formula on every cell (currently six of them, times three percentage values). This is a royal pain. How can I set a "global formula" if you like, which is accessible to all fields in my report? Better still, can I apply this global formula to my solution/project and have all my reports access it?
March 14, 2007 at 6:01 pm
Look into "Custom Code"
http://www.odetocode.com/Articles/130.aspx
I think this is exactly what you need.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 14, 2007 at 7:17 pm
Ah, that looks great, thanks!
Can you see any problems in using this to define aliases to field names? That way I won't need to define them in 18 spots either!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply