report fields/titles on the fly
(i haven't resolved my other reporting issue from a previous thread -
but in the interim i'm trying to address other reporting requirements).
what is the best approach to the following report:
i need to process all the group records and determine what fields will
be included in the report - titles, dbfields, and sum of these dbfields.
for example the table may have 10 amount fields; however any single
record may only include a subset of those amount fields; we don't want
to include in the report any fields that do not have any values. so for
a group the first record may have amount1, 7; the second amount 1,5; the
third amount 2, 4, 5; etc. so the report for this group would show
amounts for 1,2,4,5,7; their labels and their sums. the next group
could be entirely different. i realize this is a two pass report of
some sort - read the data the first time to gather which fields need to
be included in the report; then print the report with these fields.
is this something i can do with the two-pass reporting in report builder
or must i do this externally and then build the report on the fly?
thanks!
-martha
but in the interim i'm trying to address other reporting requirements).
what is the best approach to the following report:
i need to process all the group records and determine what fields will
be included in the report - titles, dbfields, and sum of these dbfields.
for example the table may have 10 amount fields; however any single
record may only include a subset of those amount fields; we don't want
to include in the report any fields that do not have any values. so for
a group the first record may have amount1, 7; the second amount 1,5; the
third amount 2, 4, 5; etc. so the report for this group would show
amounts for 1,2,4,5,7; their labels and their sums. the next group
could be entirely different. i realize this is a two pass report of
some sort - read the data the first time to gather which fields need to
be included in the report; then print the report with these fields.
is this something i can do with the two-pass reporting in report builder
or must i do this externally and then build the report on the fly?
thanks!
-martha
This discussion has been closed.
Comments
Sorry for the delay in this response. I somehow lost this question in my
news reader. I am a bit unclear about how you are differentiating between
groups here in your data. Is there a field of some sort that separates
these groups? Unfortunately ReportBuilder only allocates page space and
numbering during the first pass. I'm not sure you will be able to use this
to get the output you want. As always it is better to pre-process you data
and send it to ReportBuilder in a "RB Friendly" way to get the best results.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com