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! :wink: 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.