Crystal Reports or Other Reporting engines

Just starting out? Need help? Post your questions and find answers here.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Crystal Reports or Other Reporting engines

Post 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
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Crystal Reports or Other Reporting engines

Post 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.
I may look like a mule, but I'm not a complete ass.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: Crystal Reports or Other Reporting engines

Post 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
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Crystal Reports or Other Reporting engines

Post 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.
I may look like a mule, but I'm not a complete ass.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: Crystal Reports or Other Reporting engines

Post 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
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: Crystal Reports or Other Reporting engines

Post 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 ??
Karbon
PureBasic Expert
PureBasic Expert
Posts: 2010
Joined: Mon Jun 02, 2003 1:42 am
Location: Ashland, KY
Contact:

Re: Crystal Reports or Other Reporting engines

Post by Karbon »

I sent you a message back showing you how I integrated with RM.
-Mitchell
Check out kBilling for all your billing software needs!
http://www.k-billing.com
Code Signing / Authenticode Certificates (Get rid of those Unknown Publisher warnings!)
http://codesigning.ksoftware.net
Post Reply