Forgive me for asking, but I've looked around and couldnt
quite find the best method of achieving the following.
I've got a report that aggregates all sortsa data with
group by and sums and counts etc.
What I'd like to do, is if a parameter is set, use same
columns etc, but bring up details on a particular
subscriber. (one row per subscriber)
Which would require one more column for subscriber name
etc. But can I easily turn off the aggregation stuff in
the query itself?Weston,
Have you taken a look at the Microsoft SQL Server Report Pack for
Financial Reports (free download). In particular the report
"IncomeStmtCurYTD-Region" may be the effect you're looking for with the
"show all" parameter? The "Territory Sales Drilldown" included in the
Sample Reports provides the ability to "drill" into the detail.
Regards,
Paul
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment