Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with chart using crosstab layout for data

Status
Not open for further replies.

espltd

Programmer
Apr 6, 2005
233
US
Hi I have a column of data that is either 1,2,3,4 and have changed the name of the column in a crosstab where 1 = Data Entry, 2 = Missing Data, ect by adding the following;
In the crosstab expert, selected the row field (that results in the numbers)->group options->options->customize group name->use a formula->x+2 and entered:

select {table.number} //your row field
case 1 : "Data Entry"
case 2 : "Missing Data"
case 3 : "Old Data"
case 4 : "Virtual Data"

I also created a chart and in the layout selected the crosstab and have the table.number selected for (subdivided by). The chart works fine except that I added a case 5 (case 5 : "All Other Data")to the crosstab formula above for table.number. The crosstab still works correctly (displays data for all cases, case 1 through case 5) but for some reason now the chart does not display any data for case 5 but still displays data for case 0 through case 4. I checked the data the report is using and there are all values 1-5 for table.number.
Any ideas, thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top