Shared Variables and Graphs

Posted on 2006-05-01
Last Modified: 2008-02-26
I have a report which is laid out as follows.

                         Jan          Feb      Mar etc
No of Calls          10           11          25
No of Enquiries    11           10           5

Totals                 21          21          30

The report   has a sub report. The No. of Enquries uses a shared variable to obtain the values from the sub report. The totals adds the shared variable to the formula used to obtain the No of Calls in the main report.

My problem is I want to use the totals figures in a  graph, but cant do so because of using a shared variable.

Is there anyway around this


Question by:polynominal
    LVL 100

    Expert Comment


    Author Comment

    Thanks for the answer

    The information is for graphing in the subreport from the main report.

    Mine is the other way round, from the subreport to the main report, so does not work.
    LVL 100

    Accepted Solution

    There may not be a way to do this since the subreport isn't run until the printing report pass which I believe is after the graph gets built.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now