no fields visible after upgrading to 10.8

rbuser

Hi,

After upgrading from 10.7 to 10.8 my report has a strange behaviour:

1. The layout is ok, reflecting the number of records in my datasets (
pplabels, lines, shapes are all ok ). Even the number of report-pages is
correct
2. But .... There are NO datafields displayed in the reports (
TppDBtext )
3. The only fields displayed are the fields with the GETTEXT event

I'm sure this must be a very small thing....but I can't find it

Greatings

Leon

rbuser

It seems it only happens if my TppDBpipeline points to a datasource
connected to a Tclientdataset

Leon

rbuser

I found the cause:

ppDBpipeline:
If opendatasource = false and autocreatefields = true then I receive all the
fields, but with DataType = dtNotKnown

If I set opendatasource := true datatypes are received correctly.

But why did this change the printbehaviour in 10.8 and what's the meaning of
the opendatasource property ?

Leon

nardmoseley

We cannot reproduce the issue here.

1. Are you using RB's Data workspace to build queries? Or placing data
components on a form/datamodule. If you are placing the data components on a
form/datamodue, is the report on the same?

2. Since you are setting OpenDataSource to False, then at one point do you
open the dataset(s).

3. Can you create a simple test case using the DBDemos data. Then zip and
send to support@digital-metaphors.com. That would be a huge help

If the dataset is not open, the DBPipeline cannot determine the datatype of
the fields - thus they get set to dtNotKnown and the report will not work
properly. In my testing here, I was able to create a case in which the
fields at Delphi design-time are dtnotKnown, but when I run they get
re-created and have the correct datatypes, such as dtString, dtInteger,..
and the report works.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

> 1. Are you using RB's Data workspace to build queries?
No

Yes

No in all cases

My OpenDatasource is set to True

I've tried to reproduce it in a simple project, but I can't get the
error.

I have to set the datatypes in the IDE in order to get values on the
report. But it is not the same for all fields. This makes it even
harder to find a solution..

nardmoseley

Try to recreate more closely your actual report. Check whether it happens
with all of your reports or only some of them. If not all them, then try to
isolate the differences. Have a closer look at what you are doing that might
be different than the simple demo and try to make the demo more closely
match.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi Nard,

I'm sorry but I realy don't have the time right now to build a report
project simular to the one that give these problems. My report uses
multiple tables/queries and datapipelines some tables are placed on a
datasource and others are placed on the form. All RB-components for a
single report are placed on the same form. Further it has one main
report and two subreports, all containing some RAP code in it (nothing
very fancy). The problems that I face are all related to fields that
have RAP-code in it. It seems to me that checking the underlying value
of a field (in TppDBpipeline) is causing the problem (I'm not certain
however).

Below you find two events in RAP:
You can also see that both events use a parameter.

- Here I get an error that a value Null can't be converted into Double.
procedure TijdenOnPrint;
var HoofdRapport : TppReport;
begin
HoofdRapport := TppReport(Report.MainReport);
If Trunc(FacturenUITDetails['Datum']) = 0 then
Tijden.Visible := False
else
Tijden.Visible := HoofdRapport.Parameters['cbToonTijden'];
end;

- Here the field just don't show up on the report
procedure IBTWnrOnPrint;
begin
IBTWnr.Visible := (EigenBedrijf['BTWnr'] <> '') AND
(Report.Parameters['cbGeenBTWnr'] = 'N');
end;

The fields in the TppDBPipeline are all dtNotKnown and the fields in
the above event are filled with correct data.
However building a simple reporting project didn't give this issue.

PS: If you want, you can have a look at my own project via remote
assistance. Maybe that will give some additional information. Also I
can send you the error report from EurekaLog ELF-files if that is of
any help to you. Just let me know where to send it to.
The last line in the callstack is about: ntdll.dll ->
kiUserapcDispatcher (type = ECodeError).

I've decided to re-installed version RB 10.07 and the problems are
gone. So it's definately related to RB 10.08.

Hopefully someone else can come up with some project for you.
And of course you could check the differences between RB 10.07 and
10.08.
Please keep me informed about this issue.

With kind regards,
Stef Merlijn

rbuser

Nard,


datacomponents in a datamodule

If you are placing the data components on a

report is on a separate form

10.07 has been working perfectly, so I agree with Stef that's a 10.08 issue


My Tclientdataset's are all open when I run the report.


Greatings

Leon

nardmoseley

I emailed each of you a proposed patch to test.

I was really hoping that one of you could provide an example that we could
analyze here.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

At first glance the patch is doing it's job.
Thank you so far. I'll do some more testing the next days.

rbuser

Hi Nard,

Is there a 10.09 coming for this patch?

Eric

nardmoseley

There is a patch available now for 10.08 now

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Where I can get those patches, we have same problems!!

--
Yusuf Zorlu
MicrotronX Hard- & Software Consulting
www.microtronx.com

nicocizik

Yusuf,

Please send a small email requesting the patch to
support@digital-metaphors.com.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com