Append field values to Minimize size of report

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Append field values to Minimize size of report

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-18 : 11:56:39

Lisa writes "I need to minimize the size of our reports when data is redundant for the same key, by appending values for some of the columns.
Keys: Location, Scource, Date. (not shown)
Additional keys that can be combined: Line of Business, Medical Category, Forecasting Scenario.
Here is an example with data with the same key.

Key  LOB           Category            Scenario        Trend
...  Commercial    Primary Physician   Most Likely     +5
...  Commercial    Specialist          Most Likely     +5
...  Flexcare      Primary Physician   Most Likely     +5
...  Flexcare      Specialist          Most Likely     +5
...  Commercial    Primary Physician   Pessimistic     +3
...  Commercial    Primary Physician   Optimistic      +6

Desired Results (with abbreviations for readability)

...   Comm,Flex   Primary,Special      Most Likely      +5
...   Comm        Primary              Pessimistic      +3
...   Comm        Primary              Optimistic       +6

etc

I looked at using a variable with coalesce, but haven't gotten it to work within a derived table. I'm trying to stay away from cursors due to performance since the volume of data is very large and the reports are run real time from a web page.

Thanks for your help!"

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-07-18 : 12:31:54

bleh, n/mn.. thought I knew

-----------------------
Take my advice, I dare ya

Edited by - M.E. on 07/18/2002 12:32:46

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources