Any help on this impromptu report problem.

[garry1]

Hi Gurus,

I am new to cognos and I am trying to create a report using impromptu. I am having problem in formatting the report.Any help is greatly appreciated.

Here is the example.
I inserted a text frame into the report and I am naming the column heading as description. Total is the computed feild of the data using the total function based on the date range
I am getting the below data in the report.

Description Total
Number of Calls 49395
Number of Calls 49395

But I am interested in seeing only one row like..

Number of Calls 49395

Instead of two rows.

Thanks a lot

 

[Sagae]

I can think of 2 possibilities. Open the query and select the filter tab. Check the box for remove duplicate lines.

Or if you have any sort/groupings you may be getting a total line for the group and a total line for the report. If that is the case you can delete one of the totals from the Data tab or you can highlight it on the report and press the delete key.

 

[garry1]

Hi Sagae,

Here is the example I am trying to accomplish and having problems;

1) I have column called data_string in table a
2) I try to relate the table a with table b on the primary key
3) Created a prompt based on the created date from table b as the user
is interested in seeing the weekly data.
3) data_string column has data that looks like "AYFPD111"
4) I need to do a substring and get each charater and do total count on
them and display in the report.

example if (substring(data_string,1,1)='A) then (1) else (0) --
computecolumn a
if (substring(data_string,2,1)='Y') then (1) else (0) --
computecolumn b
if (substring(data_string,3,1)='F') then (1) else (0) --
computecolumn c

Now I need to sum all the three computecolumns and display like this in
one row in the report

Description Total

#Count of data received total(computecolumn a + computecolumn b +
computecolumn c)

But I am having problem with displaying the "#Count of data received"
as I am having tough time grouping the report. When I run the report
data is showing up like this.

==
#Count of data received 2000
#Count of data received 2000
#Count of data received 2000

But I am interested inseeing only #Count of data received
2000

Any help is really appreciated on this.

 

[SCRRT]

This is a bit late and you probably have it fixed but here is what I would try. I am guessing that you have removed the calculated columns from the report display but they are still in the query. Go into Report/Query/Data and remove the calculated fields a b and c. They will still be used in the total calculation. Go into Report/Query/Filter and select Eliminate Duplicate Records.