×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Required Help in 3D Raiser Chart.

Required Help in 3D Raiser Chart.

Required Help in 3D Raiser Chart.

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close