newbie question - blank fields
I posted an earlier problem where a report wasn't printing when some of the
values for the fields were null. I managed to find a fix for that (unhooking the
data sources for the null fields in my source code before running the report)
but now the client wants a report that prints all the labels for samples
received on a given date, so that technique won't work.
I'm populating the values from an AstaClientDataSet, Delphi 6 Pro, ReportBuilder
7.1 Pro. What I need to be able to do is to print the values for all of the
records returned by the main query, irrespective of whether the data returned by
the other queries is null or not. I've got one main query which retrieves most
of the data, but five additional queries which take data from the main queries
and translate codes into a readable value. At the moment, if (for example) query
1 returns data for some of the records, ONLY those records will print. As you
can imagine, with five queries of this type, I'm not getting a lot of data
printed. :-( What makes it even more complicated is that the report is being
printed on some very expensive (so I'm told) custom labels, and so blank spaces
on the output must be kept to a minimum, i.e. running a whole bunch of queries
for each combination of the values and printing multiple reports is not an
acceptable solution because of the amount of wastage.
I'm new to ReportBuilder after a LONG absence, and probably missing something
very obvious. Can anyone point me in the right direction? Please don't make any
assumptions - it's a long time since I last used RB!
Thanks,
Brian.
--
Software development and computer consulting
Brian Meadows Tel: 570-724-5172
Wellsboro Computing Services, Inc. Fax: 413-480-2709
RR#5, Box 5A, Wellsboro PA 16901 ICQ: 1981272
http://www.wellsborocomputing.com
This discussion has been closed.
Comments
OK, folks, Sod's Law operates, I post the request for help and then the next
thing I tries works.
Ignore the previous post, please.
Brian.
--
Software development and computer consulting
Brian Meadows Tel: 570-724-5172
Wellsboro Computing Services, Inc. Fax: 413-480-2709
RR#5, Box 5A, Wellsboro PA 16901 ICQ: 1981272
http://www.wellsborocomputing.com