| R.Shiels 2005-03-30, 9:42 am |
| Hi,
As part of reports I am creating I am required to make all the font/cell
styles configurable by the end user for 8 different report items (ie. Title,
header, footer, col headings etc with the user able to configure font color,
style, family etc and cell border color, style, width etc). I know I can
create 8 datasets within each of my reports that can query for each of the
individual types but I would prefer to just create one dataset that returns
all 8 rows and then access the individual rows within the setup of the
report. The indication I seem to be getting is that multi-row dataset access
for report-item configuration is not possible and I am stuck with doing 8
different datasets (or creating a single row dataset that returns massaged
results like titlecolor, headercolor, footercolor etc which I would prefer
not to do as 8 types * 16 configurable items = 128 fields )
eg. Instead of doing something like this for a cells font color expression:
=First(Fields!FontCo
lor, "Title")
=First(Fields!FontCo
lor, "Header")
I would prefer to be able to do an expression something along the lines of
=Row(Fields!FontColo
r, 0, "StyleInfo")
=Row(Fields!FontColo
r, 1, "StyleInfo")
where 0,1 is the row number within the dataset I wish to access.
Anyway, if someone knows if row access is possible it would be much
appreciated if you could point me in the right direction.
Thanks, Richard
|