Months(which has no data) not displaying in chart

[devnaren]

Hi All,

I am using CRXI with Oracle 9i as backend. I created a report in which i inserted a Line chart in it. On x-axis, i am using months and on y-axis, sum of products. Now when i am running this report its not showing up all the months in x-axis, its showing only those months which have the data init and it is not showing those months which are null.

In chart expert Data tab(Advanced), i am using month field in the On change of and using specified order for this as Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov and Dec. and showing the value for sum of products.

Can anyone help me out how to display all the months including those months which has no data for it.

 

[dgillz]

Crystal does not report on non-existent data. You need to have data for the missing months, even if the values are zeros.

Try using a date field from a table that has ALL dates in it, rather than your current table. Like it to your current table by the date field, and use the All Dates table as your crosstab column rather than your current table.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Madawc]

AS dgillz says, the best solution is to create a table for each category, and then link it using a left-outer to link to the details. This depends on you being allowed to create a new table, or can easily get one created to your specifications.

Another solution is to include a wider range of date in your data, one that will include something for every vendor. Then suppress printing for those outside of the date range, showing just the group header or footer. This is an inefficient use of machine-time, but might be the simplest solution from your point of view.

A third way is to create running totals for all possible vendors. Show them in the report footer when the total is zero. Suppose that records may be for apples, oranges, pears, bananas or guavas. You can group by type of fruit, but that does not show cases where there are no oranges. So you do a set of running totals (which are an option under the [Field Object] on the [Insert] menu). Each of them does a count of something, maybe account number. But each uses the formula option on the [Evaluate] section, and counts just for the one fruit.

You could also put each running total in a different section of the report footer. Suppress that section when the total is greater than zero, so only omitted groups are mentioned. It must be the report footer, because running totals are accumulated during the course of the run.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10