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

[Prajam]

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

[blom0344]

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

[Prajam]

 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...

[RKMI]

Hi,

It's very unclear what you are talking about,

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..

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.

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 )

Thanks,
RK