Hi,
I AM USING CRYSTAL REPORT 7.0.
I am making a 3D Raiser chart. Its Z axis contains the "Total Kilo Byte Transferred", Y axis contains the "Day of the week" (i.e. Sun, Mon, Tue, Wed...) and X axis contains the "Protocol" (e.g. FTP, HTTP, Telnet etc).
My whole project is in VB, have all the queries in VB project and will send the data from VB to crystal report.
For that I've made 5 formulas named FTP, HTTP, Telnet, POP and SMTP (on the basis of protocol) and in the Charts-Expert Data tab, I inserted these formulas in the show value list. The report is connected to DB from which my VB application is connected.
Now my questions are.
Q#1) In the formula I've inserted arbitrary field values, as there are few computations performed in VB project and then I've to send the values in Formula. Is it a correct method???
Q#2) On Y axis of graph it shows the record ID from the DB, I want to show the Days of the week on Y axis how can I change it.
Q#3) My Y axis will be variable, i.e charts can contain only one day (only SUN) or can contain 14 days (SUN, MON, TUE......, SUN, MON, TUE....) on Y axis how can I accomplish this task so that my Y axis can also be control from my VB application.
Q#4) When displaying charts I insert values in formula field from my VB application. I'm using Crystal report automation server.
With Report
.FormulaFields("HTTP"
.Text = 23
.FormulaFields("FTP".Text = 12
.FormulaFields("Telnet".Text = 34
.FormulaFields("SMTP".Text = 15
.FormulaFields("Other".Text = 29
.FormulaFields("POP".Text = 17
End With
Set creView = Report.Preview(strFileName)
If I've added 6 formulas on the report then the graph is not displayed, but If I either add one more formula and do not use it in my graph or just remark the last line in the with block the graph is displayed in the smart viewer. Can some one explain me why this is happening?
I know it is a quite lengthy mail and take a lot of presious time of reader, but I just stuck and unable to come up with some solution. Can any body help me.
Looking forward to get the answers.
Regards and thanks in advance.
Abid.
I AM USING CRYSTAL REPORT 7.0.
I am making a 3D Raiser chart. Its Z axis contains the "Total Kilo Byte Transferred", Y axis contains the "Day of the week" (i.e. Sun, Mon, Tue, Wed...) and X axis contains the "Protocol" (e.g. FTP, HTTP, Telnet etc).
My whole project is in VB, have all the queries in VB project and will send the data from VB to crystal report.
For that I've made 5 formulas named FTP, HTTP, Telnet, POP and SMTP (on the basis of protocol) and in the Charts-Expert Data tab, I inserted these formulas in the show value list. The report is connected to DB from which my VB application is connected.
Now my questions are.
Q#1) In the formula I've inserted arbitrary field values, as there are few computations performed in VB project and then I've to send the values in Formula. Is it a correct method???
Q#2) On Y axis of graph it shows the record ID from the DB, I want to show the Days of the week on Y axis how can I change it.
Q#3) My Y axis will be variable, i.e charts can contain only one day (only SUN) or can contain 14 days (SUN, MON, TUE......, SUN, MON, TUE....) on Y axis how can I accomplish this task so that my Y axis can also be control from my VB application.
Q#4) When displaying charts I insert values in formula field from my VB application. I'm using Crystal report automation server.
With Report
.FormulaFields("HTTP"
.Text = 23.FormulaFields("FTP"
.Text = 12.FormulaFields("Telnet"
.Text = 34.FormulaFields("SMTP"
.Text = 15.FormulaFields("Other"
.Text = 29.FormulaFields("POP"
.Text = 17End With
Set creView = Report.Preview(strFileName)
If I've added 6 formulas on the report then the graph is not displayed, but If I either add one more formula and do not use it in my graph or just remark the last line in the with block the graph is displayed in the smart viewer. Can some one explain me why this is happening?
I know it is a quite lengthy mail and take a lot of presious time of reader, but I just stuck and unable to come up with some solution. Can any body help me.
Looking forward to get the answers.
Regards and thanks in advance.
Abid.