end user report writer

rbuser

Hi,

We created a end user report writing tool for our clients, based on the
Demo that is included with ReportBuilder.

We get some strange errors with our report writing tool as well as with
the End User Demo app.

1) When creating a report and trying to save, it gives a "Invalid
Variant Conversion" error, and we are stuck in the program. Cannot close
or save the report. We have to kill the process. I created a really
simple report with only 2 fields in the detail line. It is difficult to
pin point what happens as it is doesn't occur every time.

2) After creating a report and previewing it, everything looks fine. I
save the report and when trying to enter it again, I get a error
EParserError exception - "Identifier expected on line 999". The line
number changes depending on the report. Once that error occured, I have
to kill the process as well, to exit the program.

3) Creating a report and saving to file. Then later create a new report
and "Load from file", we get the same error as in 2) above. We noticed
this when sending a template report to our clients to use.

We use our reporting tool to speak to our AppServer via Midas to a MS
SQL Server database. We downloaded the daMidas.pas file from
http://www.digital-metaphors.com/subpages/friends/data_dade_addons.html

I don't think it has anything todo with the daMidas.pas file, because if
an Exception occured in that file, it would have shown the line on which
the exception occured inside Delphi, but it doesn't.

We are using ReportBuilder Pro 6.03 with Delphi 5 and the latest updates.

Kind Regards,
- Graeme -

nardmoseley

If you are using the BDE, increase the setting for MaxBlobSize. That is the
most common cause of errors such as you describe.

Try perfoming the same test on an app that talks directly to the database,
rather than thru the Midas layer.


--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Hi,

MaxBloxSize... Is that the "Blob Size" setting in the BDE Administrator
or somewhere else in Delphi?

Any recommended size?

Regards,
- Graeme -

nardmoseley

Yes, it is a BDE setting (sorry if I did not get the name correct).

There may be a setting such as 0 or -1 that is unlimited size. Search Google
Groups for this.

You can save your reports to an .rtm file and use the Windows Explorer to
check the file size. This will provide a good indication of how large the
report templates are. If your reports layouts include ebedded images, this
can increase the required size quite a bit.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com