Blank Datafields on Report
Hi,
I'm having some strange problems with ReportBuilder 7.04 in certain
circumstances. I have report generating output perfectly correctly
except the DB fields connected to a DBPipeline do no display their
values. Everything else renders correctly (non-DB fields, labels,
shapes, etc).
What is puzzling is that it would appear that RB is processing the
dataset connected to the pipeline correctly, as it is outputting the
correct number of detail bands for the dataset. I confirmed this by
changing the background colour of my fields in the detail band. Those
fields are rendering their backgrounds colours, but not the dataset
values. There are exactly the correct number of rendered fields as
records in my dataset, so RB must be aware of the dataset in some form,
but sadly won't output any field values in that dataset.
Attempting to be clever I stuck a breakpoint at the beginning of
TppDBPipeline.GetFieldValue() but it would appear not to be called
during the print process. As I've only just started playing with RB this
may well be significant, or just highlight my lack of understanding.
I'm using D6 with a kbmMemTable connected to the DB pipeline. Any
pointers would be much appreciated.
Thanks,
Graeme.
--
Graeme J Hosking
I'm having some strange problems with ReportBuilder 7.04 in certain
circumstances. I have report generating output perfectly correctly
except the DB fields connected to a DBPipeline do no display their
values. Everything else renders correctly (non-DB fields, labels,
shapes, etc).
What is puzzling is that it would appear that RB is processing the
dataset connected to the pipeline correctly, as it is outputting the
correct number of detail bands for the dataset. I confirmed this by
changing the background colour of my fields in the detail band. Those
fields are rendering their backgrounds colours, but not the dataset
values. There are exactly the correct number of rendered fields as
records in my dataset, so RB must be aware of the dataset in some form,
but sadly won't output any field values in that dataset.
Attempting to be clever I stuck a breakpoint at the beginning of
TppDBPipeline.GetFieldValue() but it would appear not to be called
during the print process. As I've only just started playing with RB this
may well be significant, or just highlight my lack of understanding.
I'm using D6 with a kbmMemTable connected to the DB pipeline. Any
pointers would be much appreciated.
Thanks,
Graeme.
--
Graeme J Hosking
This discussion has been closed.
Comments
This is not a known issue with ReportBuilder. Check your datapipeline
properties to be sure AutoCreateFields is set to True. Also, double click
on the DBPipeline object and be sure all the fields are present. Inside
ReportBuilder, be sure the DBText components are visible and that
BlankWhenZero is set to False. Also be sure they are properly assigned to
the correct field in the pipeline. If you connect a DBGrid to your dataset,
are you able to see the correct data? If you connect a TTable to a pipeline
and connect that to a report, are you able to see any data?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
If you are loading templates, the safest way to ensure that you are
connecting to the correct datapipelines is to do in manually after the
template is loaded. The report templates are designed to work in
conjunction with DADE and RAP to keep all data access and event code local
to each template. If you were to define all your datasets in DADE, there
would be no need for datapipelines on a form and therefore would solve the
issue. The same issue will arise if you try to use the same event handlers
with multiple templates.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
That's pretty much what I have now got, and it is working nicely. Thanks
for your help.
Best regards,
Graeme.
--
Graeme J Hosking
NextGen Computing Ltd