Crystal Report Graph

Hi Everybody,
I have just started to work with Crystal Report(shipped with vb.net 2003) and I am facing I problem in drawing a line graph.I have to draw a simple graph from a table where one column is time(datatype is datetime in sql server) and another column is Flow(datatype is float).Flow is recorded in every minute.I have to plot the graph where time is at X axis and flow at Y axis(no summerized value).
But in Chart expert whenever I select time in X axis(that is on change of value), I find Find flow is coming as summerized value like sum,average etc(but I want simple plotting without summerization).
If I take 'each record' option from chart expert for time column,I find X axis is showing mere numbers like 0,1,2.... instead of time which I require.
If anybody can help me I will be greatful to this group.
Thanking you.
Siddhartha.In both the cases what values are coming on the Y axis|||Hi
Thank you for your help,can you tell me how can I change at least one series to x axis.I am using Crystal report shipped with vb.net 2003.
Siddhartha|||If possible can you send me the project in zipped as a zip file|||I am facing the same problem too, I used the advanced layout in the chart expert , but still i get summarized values ,once i choose the "on change of value"
The don't summarize check box is disabled too.
I am using crystal report version 10

Could anyone pleease help,|||Since you are trying to draw a graph between two values, on change of 1 value so X-axis will have only 1 entry for 1 value. Lets say your table looks like this

Time Value

10:34 10.13
10:34 10.14
10:34 9.5
10:35
10:35
10:36

then as you see there are 3 entries for same time value (10:34) so how this will be displayed in the graph since a graph will have only 1 entry for 10:34. Thats why when you choose the value it comes to be a summarized value. So you can choose the corect type of summarization for your report it can be average, sum or any other even you own function. I think this clears your problem. :)

Crystal Report 9 And VB6 with Oracle (This Combination is possible or Not)

Hi everybody,

Still I have a problem that I can't show a report in VB6 by using Oracle9i as database and Crystal Report 9. coz There is no CrystalReport.OCX control in Crystal Report 9. So i made my report in VB6 by using add Crystal Reports 9 and whenever i try to show report by using Crystal Report Viewer Control then it gives an error that is "Login Failure". I am sure that i have to pass servername, username and password but how can i do it realy confuse.

please anybody help me with a example.

I am using Crystal Report 9, Oracle9i, VB6

bye
bappyHi,

Have you tested in Crystal Report IDE Mode, Try to connect oracle database in cr IDE mode.

Yours Friendly,
K.Babu

Originally posted by BappySha
Hi everybody,

Still I have a problem that I can't show a report in VB6 by using Oracle9i as database and Crystal Report 9. coz There is no CrystalReport.OCX control in Crystal Report 9. So i made my report in VB6 by using add Crystal Reports 9 and whenever i try to show report by using Crystal Report Viewer Control then it gives an error that is "Login Failure". I am sure that i have to pass servername, username and password but how can i do it realy confuse.

please anybody help me with a example.

I am using Crystal Report 9, Oracle9i, VB6

bye
bappy|||Thanks Boss,
I got connection with oracle.

bappy

Crystal localization issues

Hi everybody,

I have developped an multilingual application that uses Crystal to generate statistical reports. I want to use Crystal promts to ask the user the various parameters values, but each string (like 'please type a value for parameter ...') is displayed in one language (in my case french), and I don't know how to use another language...

I have seen jscript files that are used to display these strings (promptengine_strings_fr.js in Business Objects\3.0\crystalreportviewers11\prompting\js) but I can't find a way to change it...

Can anyone help ?? I would really like to avoid developping my own pages to ask the user all parameters, especially for cascaded dynamic prompts...

PS : I am using Crystal XI, my app is C# aspxreply test