If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

MIN() function automatically set

Started by amu, 29 May 2012 12:31:12 AM

Previous topic - Next topic

amu

Hi,

I am having one main report which will display the count of patients ,when clicking on the count it will drill through to a report which will explain the detailed information of the patient's.

Pblm: The count in the main report and the drill through is not matching

Main report is working fine.
I am having some 10 data items in the drill through Query item.In that 2 data items are automatically set the Min() function . I found this by taking a profiller query.

Data item property are set as follows :

Type:Data item
Name : Patient No
Label:
Expression:[Report Views ].[VIEW4].[Patient No]
Aggregate Function : None
Rollup Aggregate function : Automatic
Pre-sort : Don't sort
Detail : Automatic
Calculation Intersection :Show value
Solve order :


Following is the profiller query which will set the min() function automatically...

min("VIEW4"."Patient no") AS "C13",
min(case  when  NOT "VIEW4"."level3_name" is null then "VIEW4"."level3_name" when "VIEW4"."level3_name" is null and  NOT "VIEW4"."level2_name" is null then "VIEW4"."level2_name" else "VIEW4"."level1_name" end ) AS "C14"



The Min() function and group by are set automaticaly in the Query generated...If i remove the group and min() function i get the exact data in the DB...

How to remove the  the MIN() function in the report ?

amu

Found a solution:

Autogroup & Summarise property is set to No in the properties pane of that Query item....

Now the MIN() is not displayed....

While setting this option to Yes ..it is automatically using any of the aggregate function...

blom0344

Instead of passing all this data through the drillthrough, would it not be easier to start another report concerning the same set of patients - with details? It sounds like you are not passing through individual Id's