How do I use crystal reports in a web app? 1

[Custom24]

Sorry but from the help I cannot figure out how get started with this. All I want to do is a simple pie chart to show the results of a query.

Anyone any pointers?

Mark

 

[Alcar]

here you go:

http://msdn.microsoft.com/msdnmag/issues/02/05/Crystal/print.asp

hope this helps Daren J. Lahey
Just another computer guy...

 

[Custom24]

Thanks Alcar

It seems a little like overkill for what I want to do, but I might as well learn to use it. I've never used Crystal Reports (or any reports really) before, so it will be interesting...

Mark

 

[jfrost10]

Although there's a bit more of a learning curve, I'd urge you to look into creting XSLT outputs for reports as well. Although there's quite a bit of overhead and learning curve to xml, learning it is VERY beneficial, and you can generally do alot more with how you want the report to look than you can with CR.

Jack

 

[Custom24]

OK Jack, but for the moment I just want to get this project finished. Thanks

Alcar - thanks for that, but it's driving me mad.

I have a view in my Oracle database (basically its the same as a query in MS Access) which gives me the data I need. It produces two fields and the source is something like this

Select Name, Count(Name) from Entries group by Name

So it does the hard work - I only want Crystal to show the resulting table as a pie chart.

I can get it to show the count field as a pie chart, but I cannot see how to get it to label the segments correctly, since it is just plain refusing to accept the Name field when the combo is set to "For each record"

Any idea? Am I making any sense?

Thanks in advance

Mark

 

[jfrost10]

Can you do something like this:

Select Distinct Name, Count(Name) From Entries Group By Name

That way, you'd have one record for each name, but also the count of that name in the table.

Jack

 

[Alcar]

this should clear you up on how to create pie charts with Crystal Reports in VS.NET

http://support.crystaldecisions.com/communityCS/TechnicalPapers/rtm_webformsviewer.pdf

hth Daren J. Lahey
Just another computer guy...