Crystal Report

**Tony Choo** · April 28th, 2003, 11:57 PM

Hi Babu,

I was wondering if you could advice how one would go about implementing a recursive scheduling of report on CE8.0 using CSP?

Basically our recursive report uses the same parameter and every time it runs recursively. We want the parameter to be relevant to the time run.

For example, report is scheduled to run on 29 apr 03 (Tue), and then again everyweek on the same day, granted it does run every tuesday, but the date of data to print is stuck at 29 apr 03.

How do we tell CE8.0 that when it runs a recusive report, it should get current date, week month or even year's data, so that every time it runs, relevant data is secured?

Thanks & best regards
Tony

**K.Babu** · April 29th, 2003, 12:03 AM

Refer the Graph Wizard at Graph Type Report, this will help you to follow the steps easly.

Originally posted by RIC_V
Hi!,

I´m trying to insert a Graph (vertical bars) on my report without success. There are three AccessDB fields that need to be shown in the graph (as a bar each).

I created a summary for these fields but apparently I can only display one bar (field) per graph.

If someone knows if it´s possible to include more than one field in a graph please let me know.

Thanks in advance.

**CA_IB_MR** · April 29th, 2003, 09:38 AM

I have been trying to use crystal reports from a MFC dialog box. But I donot find any documentation on how to do it.(in Visual C++ .NET).

Any help would be appreciated,
thanks,

CA_IB_MR

**Randy VL** · April 30th, 2003, 06:45 AM

Hi K. Babu

I am using VB6 and CR9. Not that Familiar with CR9.
I have a frmMain with DBGrid and text etc. that the user has entered, with that I would like to transfer the info to CR9 and was wandering how I can do this
Thanks

**saldig** · April 30th, 2003, 08:38 AM

Hi,
I 've a problem in printing report (file.rpt) from Crystal report 9 environment. I have Microsoft Windows 2000 installed in Italian Language, and Crystal report 9 installed in English Language.
When I print a report, the result is that numbers are correctly printed but characters are non correctly printed (strange combinations of symbols are printed).
If I use both Windows 2000 and Crystal Report 9 in English version, the printing works fine.

---------------------------------------------------------------------------
Another question.

What is the run time (dll) that have to be used with Crystal Report 9??
The applicatione that have to use the run time is a C++ application.

Thanks in Advance

**Kain** · April 30th, 2003, 03:53 PM

Hi there, in my program you r supposed to be able to print a bunch of reports in one time.. All the report displays well but it will only print the last one even if it gives printer dialog after first one..
So i guess i need to wait a event saying that the display - Printing is done.. b4 trying to do the next..
My report are done in Crystal Report exported in PDF..
Any idea?
Thanks

**kishore_mala** · May 1st, 2003, 02:55 AM

Dear Babu,

Can you please answer my post in http://www.codeguru.com/forum/showth...hreadid=243434

I don't post it again here because it may be considered as spam.

Thanks in advance

Kishore

**shethashish_a** · May 1st, 2003, 07:09 AM

hi mr.Babu,
I just came to know about the forum on crystal report.
I have a problem with crystal report which I have posted a thread just now on the following link.
www.codeguru.com/forum/showthread.php?s=&threadid=243456

Can u answer me on this immediately. I am stuck on that and i need solution immediately.
my email id is
ashish@sankhyainfotech.com

thanks in advance.
Ashish

**shethashish_a** · May 2nd, 2003, 01:21 AM

Hi all,
In my previous thread i have mentioned that I tried to connect to oracle database through crystal report wizard but it is not working. Now i have tried through code and still it is not working.
here is the code that i have written in crystal report's initialize event

Const ConString = "Provider=MSDAORA.1;User ID=gtsc;password=gtsc;Data Source=portal1;Persist Security Info=False"

Private Sub Report_Initialize()
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = ConString

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
con.Open
rs.Open "Select * from emp", con, 3, 2, 1

Database.SetDataSource rs
End Sub

Please help me immediately. it is urgent. I am stuck on that.

thanks,
ashish

**yeosc** · May 5th, 2003, 02:38 AM

Hi Babu,

I've created a report with a line chart. When I call the report from vb6 on a windows XP, it's running fine; but when the same report is called on Windows 98, the chart just dissapeared. Is there anything to do with any missing file? However, I didn't get any error message. The other info in the report was displayed properly. I'm using CR8.5.

Thanks
yeosc

**RIC_V** · May 5th, 2003, 12:28 PM

Hi People,

How can I set the database location at runtime from my vb app? When i was using an old version of Crystal report i was allowed to set "same as report".

Thanks in advance.

Ricardo

**OrangKampung** · May 5th, 2003, 08:32 PM

OK..the problem is like that.I connect the crystal report to MYSQL using ODBC.

Everything work perfect when i am just using 1 or 2 tables in a report. I use left outer join to connect each table.

But the problem occur when i am using the data from 3 or more tables in a report.It always appear a message " Fail to open a row set" What wrong actually?

Thanks for help.

**OrangKampung** · May 5th, 2003, 08:34 PM

I am using ODBC to connect crystal report to MYSQL database. I am wondering why i cant select a data from a tables where a field in a table is equal to "" (That mean it was nothing in the field,but not null,just nothing).

I right click on 1 field at the table..then click select expert
-> click equal to "" , but when run the crystal report,nothing select? how can i fix this problem?

thanks for help.

**lsavidge** · May 6th, 2003, 12:42 PM

Hi,

I'm having real problems trying to do something that ought to be very straightforward. I have a stored procedure that returns a recordset. This displays a nice tabulated report without problems. This stored procedure takes 3 parameters, 2 dates and an ID to identify a survey I'm reporting on. Also there is a sub report which is related to the main report but is designed to sumarise some columns with a view to creating a graph.

The sub report is a stored procedure which takes the same parameters but also another parameter which is the question number of a particular question in the given survey. This produces a small recordset with which I want to produce a pie chart from.

I can do all this seperately and I have also figured out how to link the parameters so that the subreport takes the parameters from the main report. However, for the sub report, I do not want the question ID parameter to be entered by the user, I want to hard code it (for reasons I won't go into right now). I have to run this sub report for 24 different questions so I need to be able to have a subreport generated from single stored procedure.

To summarise, if I were to run this in query analyser I would run:

exec MainReport @Date1, @Date2, @Survey

and then for the sub reports:

exec SubReport @Date1, @Date2, @Survey, 100
exec SubReport @Date1, @Date2, @Survey, 101
exec SubReport @Date1, @Date2, @Survey, 102
exec SubReport @Date1, @Date2, @Survey, 103
exec SubReport @Date1, @Date2, @Survey, 104

where the first 3 params in each case are the same.

This will then give crystal the recordsets with which it can create the charts from. I don't want to prompt the user to enter in the question numbers in the subreport, I just want to hardcode them into crystal.

Any help is most welcome.... I'm running Crystal 9 and Report Application Server. All I require is the end user to choose a report in the browser, type in the dates and state which survey to run and for crystal to show the report and the graphs. I have the SQL in the form I need, but not the knowledge of crystal to pull it off.

Cheers,

Lee

**Fumiseki** · May 7th, 2003, 03:26 AM

helo ,
nice to hear that's a crystal report specialist would resolve my question .
ok , i'm facing a problem of displaying my daily sales value into graph, my clients which running his operation hours from afternoon 3 pm to morning 3 am .... so ... it's raise a serious problem to me of displaying the sales value , you know .. by default crystal report uses default time as daily (00:00:00 to 00:00:00) ... so all my value getting wrong !! ... it should be 03:00:00 to 03:00:00 correct ? so i had been mad about this .. hope you can give me a hand .. i'm grade of hearing reply from you . thanks you!