Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 559
  • Last Modified:

Graph formula Fields

I'm working in a .NET environment and I’m trying to graph some formula fields. When I go to insert a graph on the form and look at the data that I can put on it I can’t see my formula fields. I can only see my database fields and my running totals. Why can’t I see the formula fields?? Is there a limit or does the formula fields have to be a certain type?? Any help is appreciated….thanks.
0
Code_Buzz
Asked:
Code_Buzz
  • 3
  • 2
1 Solution
 
frodomanCommented:
There's no reason that you can't graph a formula in general so the problem is probably with the specific formula.  For example, you can't graph a formula that is only valid during the print phase of a Crystal Report.

What is the formula that you're trying to graph?  
0
 
Code_BuzzAuthor Commented:
I'm try to graph some formula fields that are being populated at runtime. So I guess that I won't be able to graph them?? They are basically some counts of some running totals with some calculations in them. Is there anyway around this or just not possible to get them to graph.
0
 
frodomanCommented:
What you might be able to do is to create a subreport and pass the values from your running totals into your subreport (as parameters) and then do the graph in your subreport.  This is a *maybe* solution though as it very much depends on the type of graph you're looking for and that organization of your data.

Sometimes the grouping on a report can also mess up the running totals.  You might be able to create a report that's sorted but not grouped and use your formulas there and create your graph.  You'd probably then suppress most of it and create another nearly identical report with the groupings that you want displayed.  Again this is a *maybe* solution though.

Bottom line is the above suggestions might work in very narrow situations.  Otherwise you may not be able to do it.  Crystal's graphing tools aren't the best and can't handle lots of stuff that they should (IMHO) be able to handle.

I've seen people discuss some 3rd party graphing tools that work with Crystal.  I don't use them myself and can't speak to if they're worth the $'s but it might be something to investigate.

frodoman
0
 
Code_BuzzAuthor Commented:
Thanks!!
0
 
frodomanCommented:
Glad to help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now