A New Report Requirement 1

[saran26]

Hi All,

I have the following fields in my table

DTEntered
State
id

I have to create a report which shows count of defects on a weekly basis on "open" and "closed" state and also their cumulative counts on a weekly basis

Example

classicifcation state (open) State (open)cumulative
WeeK1 3 3
Week2 4 7
Week3 2 9

etc, is it possible! Please help me with that.

Thanks
Saran

 

[lbass]

What have you tried, and what problem have you run into?

-LB

 

[saran26]

I created a cross tab report, I am able to get the first one

classification count
Week1 3
Week2 5

I dont know how to get the cumulative count using the cross tab?

Thanks
Saran

 

[lbass]

How have you added in the open/closed distinction?

-LB

 

[saran26]

yes

right now it shows as
open closed
Week1 2 1
Week2 3 2

The only which is missing is , cumulative count !!1.

Thanks
Saran

 

[saran26]

Can i use a running total ?

Thanks
Saran

 

[lbass]

Add the summary field a second time, and in preview mode select the new summary->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar cl;
numbervar op;
if gridrowcolumnvalue("table.state") = "Closed" then
cl := cl + currentfieldvalue;
if gridrowcolumnvalue("table.state") = "Open" then
op := op + currentfieldvalue;
false

Then in the same screen->display string->x+2, enter:

whileprintingrecords;
numbervar cl;
numbervar op;
if gridrowcolumnvalue("table.state") = "Closed" then
totext(cl,2) else
if gridrowcolumnvalue("table.state") = "Open" then
totext(op,2)

In both formulas, replace "table" with your table name.
In the customize style tab, choose summary fields->horizontal->show labels, and also check "suppress row totals" and "suppress column totals".

-LB

 

[saran26]

Thanks I will try this and let you know tomorrow.

Saran

 

[saran26]

Hi LB,

It worked great, but I am not able to display the added summary field in the chart.

Do you know why ? How can I show that in the chart.

Is it possible to show both summary field in a single chart, please let me know.

Thanks
Saran

 

[lbass]

Chart? What chart? You should have specified that upfront.

-LB

 

[saran26]

sorry about that LB.

I am displaying the count of id, time period in week along with the state in a chart.

It displays the first summary field correctly in the chart. But while I am trying to display the second summary field.

It displays the same value again.

Please help me out.

Thanks
Saran

 

[saran26]

Hi LB,

Any ideas why it is not displayed in the chart?

Please help me out.

Thanks
Saran