Page 1 of 1
Crystal Reports or Other Reporting engines
Posted: Thu May 13, 2010 8:53 am
by captain_skank
My app is now taking shape and I have a need to include reports.
I have some quite complicated and 'odd' reports that need to be run so i think Crystal Reports will best meet my needs.
Anyone, used crystal with pb and got any example code ??
All i want to do is call the report and myabe pass a few parameters.
If anyone uses/recomends another report engine then I'm happy to try anything.
I've used srod's excellent nxreport, but some of my reports, require some things that are not available.
Ta muchly
Captain_Skank
Re: Crystal Reports or Other Reporting engines
Posted: Thu May 13, 2010 11:37 am
by srod
captain_skank wrote:I've used srod's excellent nxreport, but some of my reports, require some things that are not available...
Not available yet!

A major upgrade is now underway.
Have a look at
ReportMan
I find it a little quirky (being written in and designed for Delphi/Kylix) but it is very powerful. I think that, with PB, you will have to connect to data-sources through ODBC.
I know that Karbon's kBilling uses ReportMan very effectively.
Re: Crystal Reports or Other Reporting engines
Posted: Thu May 13, 2010 2:14 pm
by captain_skank
ReportMan looks pretty good.
I've had a quick look through the docs and a search on these forums, but can't see how you would call a report from within PB.
I found one entry that says to use the commandline but the program it calls isn't in the reportman folder.
So I guess I have to use comate plus and the activex ??
Anyone have any code example of calling reportman ??
Cheers
Captain_Skank
Re: Crystal Reports or Other Reporting engines
Posted: Thu May 13, 2010 3:36 pm
by srod
I think the ActiveX control is for embedding report previews in Internet Explorer etc.
Send Karbon a pm, he might be able to get you started.
Re: Crystal Reports or Other Reporting engines
Posted: Thu May 20, 2010 8:30 am
by captain_skank
Hi all,
I've pm'd karbon but had no reposnse so have ploughed ahead with reportman.
I have created a simple data drivern report which is fine and can run it from the command line by using :
Code: Select all
C:\Program Files\Report Manager\printrepxp.exe -preview -paramPSO_NO=28 contract_review.rep
However, this will not run when using runprogram :
Code: Select all
runprogram("C:\Program Files\Report Manager\printrepxp.exe", "-preview -paramPSO_NO=28 contract_review.rep","")
Any ideas what i'm doing wrong ??
Thanks
Captain_S
Re: Crystal Reports or Other Reporting engines
Posted: Thu May 20, 2010 9:57 am
by captain_skank
captain_skank wrote:Hi all,
Code: Select all
runprogram("C:\Program Files\Report Manager\printrepxp.exe", "-preview -paramPSO_NO=28 contract_review.rep","")
DOH!!!
Never mind, figured it out the -param entry was for another report.
However, is there a size limit for the parameters section or the runprogram () command ??
Re: Crystal Reports or Other Reporting engines
Posted: Sun May 30, 2010 6:51 pm
by Karbon
I sent you a message back showing you how I integrated with RM.