Creating End User facility in Delph 2007

rbuser

Hi,

I am setting up ReportBuilder end-user capability with DBISAM. Copied the
end-user project as the template and have basically worked it to a stage
where I can create reports. Problem is once I save a report and then try to
run it again from Explorer I receive a message 'Invalid Template Format'.
This seems a bit weird considering it was just saved so why would the format
be incorrect?

Also not sure if it has anything to do with it but everytime I create a new
report I have to set the database name in Data Settings as it is blank.

Help appreciated

Thanks

Alex

nardmoseley

We have many customers using RB and DBISAM together - works great.

An example of using DBISAM is installed to RBuilder\Demos\EndUser
Databases\DBISAM. There is a ReadMe.doc included with the example.

That is a generic exception that indicates an error ocurred why loading the
report.


You do not have the app configured correctly. As a starting point try
working thru the DBISAM example mentioned above.



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

rbuser

Hi Nard,

I used the example as my base. Yes I am a customer who has used RB and
DBISAM together great. We are currently converting from
RBV7/Delphi5/DMISAMV3 to RB10 (or is it 11)/Delphi2007/DBISAMV4.

Any starting points as to why when I create the report and run it it works
fine but once I save it and then try to reload it it displays a and save it,
it works fine, but when I try to retrieve it again, it displays an invalid
template error?

I'll try starting from scratch again if I have to but was just wondering
what could potentially cause this.

Thanks

Alex

rbuser

K I started from scratch but the same issue. It just doesn't work. You
save a report and you cannot retrieve it again due to this 'Invalid Template
Format' message.

Also doesn't work straight out of the box anyway as the sample DBISAM data
files supplied have a different definition to what the SQL statement
requests. In particular in the rbItem table, the SQL statement of qryItem
and qryItemUpdate look for fields namee 'ItemName' and 'ItemSize' whereas
the actual table has them named as 'Name' and 'Size'. Easy fix of course
but my issue remains with 'Invalid Template Format'. Need to know where to
look.

Thanks

Alex

nardmoseley

I tested using D2007, RB 11.02, DBISAM 4.25

I upgraded the tables installed with the RB demo to work with the DBISAM 4.

And I had to modifiy the qryItemUpdate SQL for the Name and Size, as you
mentioned.

I did not encounter any errors. I created a few simple reports and am able
to load them.


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

rbuser

K thanks Nard Ill have to investigate further.

Alex

rbuser

Hi Nard,

I a still having problems with this. I even compiled the demo that you
supply (with the mentioned changes) and I still get the same issue. Maybe
my installation of ReportBuilder is no good? Or maybe my compilation of the
DBISAM part is incorrect, or conflicts with a different version? I also
have ReportBuilder 7 with Delphi 5 installed on the same PC.

Thanks

Alex

rbuser

Sorry I clicked Send too early. Is it possible maybe Nard to email me a
copy of the DBISAM tables V4 and the project (modified) you used to
successfully save and reload reports? Email is alexATfavourDOTcomDOTau

Thanks

Alex

nardmoseley

Just sent you the files. These are also included in the latest RB 11.02
build available for download from our web site.

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