Bar Chart Problem?

[nmmure]

Hi,

I am preparing BAR Chart Report, Chart is display right data and working fine, my problem is records are more Chart is not readable manner, for that how can we restrict the records. ex: my report is having Group by, in that one group is having 150 records, displaying 150 records on chart looking very Ugly and it is not in readable manner, how can we show 20 records one chart , 20 - 40 records in another chart, 40-60 records another chart.. Like that how can we do?

In another group only one record is there that displays entire graph, how can we reduce marker width?

Please help me any one have idea

Any help will be appreciated

Thanks
Mure

 

[lbass]

Create a formula {@grp}:

whilereadingrecords;
numbervar cnt := cnt + 1;
if cnt in 1 to 20 then 1 else
if cnt in 21 to 40 then 2 else
if cnt in 41 to 60 then 3 else//etc.

Insert a group on this formula and then place your chart in a group footer or group header section. Suppress the details. Use the same "on change of" field and "show value" field that you have been using.

If you are already placing the chart in a group section, make this new group group #2, and move the chart to one of the Group #2 sections.

-LB

 

[nmmure]

Hi,
thanks for the idea, i will try on that, In the bar chart report,If the report is having 15 to 20 records Chart look & feel was very good. if the chart is having 1 or 2 records bar is occupaying entire chart this chart Look & feel is very very bad. i didn't get the idea how to fix the Bar width?
please help me.
Thanks & Regards
MURE

 

[lbass]

I don't know of a way to adjust the width. Maybe someone else does.

-LB

 

[nmmure]

Hi sir,

I try that formula, it is not working, before my database is having 5 records, i think formula is working now testers will enter 30 more records,
formula shows the value 2. But details section 38 records are displaying,

Sir, please help me how to do the formula, may iam using in wrong way, I created one formula field with
whilereadingrecords;
numbervar cnt := cnt + 1;
if cnt in 1 to 20 then 1 else
if cnt in 21 to 40 then 2 else
if cnt in 41 to 60 then 3 else
4
and created Group on this field and place the chart, Formula field is showing value 2 & chart is displaing 35 records.

please help me

Thanks in advace

 

[lbass]

Place the formula in the detail section and then insert a group on it.

You must add additional ranges to the formula to accommodate the maximum number of records in the report. Your current formula would only work if therer were 80 records.

-LB

 

[nmmure]

Thank'Q' very much. It's working fine.

Thanks & Regards
Mure