Print Page - Based on matching of two query items... data has to throw

Title: Based on matching of two query items... data has to throw
Post by: Prajam on 25 Apr 2013 09:32:27 AM

HI folks,

here is something im struggling in one of my reports,

here the challenge: consider
product_name product_code product_type transaction_reference_key

based on the transaction_reference_key, two matching columns of has to throw the data

i.e for product_name&product_code,---has to give the count for this matching and also the data which has some other columns
product_name&product_type,--- has to give the count for this matching and slo data
product_code_&product_type--- vice versa

Title: Re: Based on matching of two query items... data has to throw
Post by: blom0344 on 25 Apr 2013 03:07:31 PM

throwing data? Any chance you clarify your case with an example? Very, very difficult to understand where you are struggling with :o

Title: Re: Based on matching of two query items... data has to throw
Post by: Prajam on 26 Apr 2013 05:25:46 AM

In report:
we are entering 'account number' and 'date range' at prompt page,
based on this, it has show the "transactions" performed for that date range for particular account number..

so select any "transaction" having radio button(other columns
include 'date of trxn','trxn amt','merchant name',merchant code','merchant location','trxn amount(rupees)')
then click next(drill thru),has to show the details of that transaction..

here (for that particular transaction, has to show other transactions based upon
matching columns of 1."merchant name & merch.location"------ (has to show the trnxs and its count )
2."merchant code & merchant name"------(has to show the trnx and its count)
3. "merchant code & merch.location"------(has to show the trnx and its count )

hope u understood now... let me know if need more info. on this...

Title: Re: Based on matching of two query items... data has to throw
Post by: RKMI on 26 Apr 2013 10:56:10 AM

Hi,

It's very unclear what you are talking about,

Quoteso select any "transaction" having radio button(other columns
include 'date of trxn','trxn amt','merchant name',merchant code','merchant location','trxn amount(rupees)')
then click next(drill thru),has to show the details of that transaction..

I think it would be easy put you require in a excel file and show what you are tryin to achieve, also what part do have workign till now.

Basic understanding of your problem looks you are creating dynamic colums or you want to knw how to use render variables since you mention this thing below, which doesn't tie with your other statement.

Quotematching columns of 1."merchant name & merch.location"------ (has to show the trnxs and its count )
2."merchant code & merchant name"------(has to show the trnx and its count)
3. "merchant code & merch.location"------(has to show the trnx and its count )

Thanks,
RK

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Prajam on 25 Apr 2013 09:32:27 AM