Skip to Content
author's profile photo Deborah Handley
0
Deborah Handley

Rolling grid and line graph & formatting axis labels

Posted on Dec 03, 2014 at 06:16 AM 13 Views

I need a few rolling reports. Months across the top; Data below need to be grouped in various ways, eg States (SA, VIC etc); Divisions, employee category, Test type etc.

I need a grid of details first, followed by a chart. I managed to get one report working by assigning names like month-1 to month-12 in formulae. I can get the grid heading to show the month name & year. Data is correct in the grid and chart. Chart labels are generic only.

Questions:

1. How do I get the chart to reference the actual month names & year on the axis, all I can get is the 'month-1' to 'month-12' formulae name.

2. Is there a better way to do this, say an array or something else? I have 7 formulae for each month so producing a 3 year report is rather impractical.

3. One report requires the top 10 employees (eg for sick leave). I can produce this in a chart with employee number on the axis. Is there a way to add the employee name as well? I can't produce data via employee name as we have duplicate employee names within the company.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Jennifer Jacob
    Jennifer Jacob
    Posted on Dec 04, 2014 at 08:20 AM
    0

    Hi Deborah,

    It would be best if we could visualise the layout expected.

    Could you provide a prototype of what you are trying to achieve here?

    Regards,

    Jennifer

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Deborah Handley
      Dec 15, 2014 at 09:00 PM

      Hi,

      Try these ways:

      1. You didn't convert the date to text and just added the date field to the crosstab as the column field grouped by each month it would sort ascending by default.

      2. Right click on column field i.e Dec-13 -> Column Options -> Group Options -> Select 'in specified order' -> you can give correct order i.e jan-13,feb-13 etc -> ok ---This is apllicable for limited data means one year data.

      or

      Write a formula in Group formula for Group sort Order formula editor i.e

      if Date(Year({your field}), Month({your field}), 1) then crAscendingOrder else crDescendingOrder.

      3. Chart issue see these: The Crystal Reports® Underground

      Thanks,

      dj

    Comment on This Answer
  • author's profile photo Deborah Handley
    Deborah Handley
    Posted on Dec 16, 2014 at 10:56 PM
    0

    I can't get the date at all in the graph. I set up 12 formulas with name Month-1 to Month-12 and populate these with the actual month. I only get these names on the graph, not the value in them. I can get the chart with the correct months displayed. I just attached an example of what I need. I have now attached what I have from my successful rolling report.


    Sample report with Month names missing.JPG (39.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.