Jump to content

BIRT Developer Center
Download


Photo
- - - - -

BIRT Report Query


  • Please log in to reply
4 replies to this topic

#1 Khoza

Khoza

    Member

  • Members
  • PipPip
  • 21 posts

Posted 10 February 2012 - 06:21 AM

Hi Birt Developer(s)

At the moment i'm having a birt report that displays the following data:

Merchant_ID | Merchant_Name | Total_Income | Cost_Of_Sales | Gross_Profit_(%)
-----------------------------------------------------------------------------
10000 NuPay R 500.00 R 0.00 100%
10144 Marais R 500.00 R 0.00 100%
10146 Randhart R 500.00 R 0.00 100%
10148 BAFF R 500.00 R 0.00 100%
10150 GLIBSA TTU R 500.00 R 0.00 100%
10151 Kredihold R 500.00 R 0.00 100%
10153 Legal Protec R 500.00 R 0.00 100%

and now i want to set a hyperlink for all the merchant/customer IDs and when i click a merchant ID, I want to actual assign the value to a birt parameter, that i will pass to another birt report which is expecting merchant ID as parameter.

Could someone help me with this because i've been working on this for the whole week.

Thanks in advance.

Kind Regards,
Lucky - Junior BIRT Developer.

Attached Files



#2 For Birt

For Birt

    Member

  • Members
  • PipPip
  • 29 posts

Posted 10 February 2012 - 06:38 AM

Hi Birt Developer(s)

At the moment i'm having a birt report that displays the following data:

Merchant_ID | Merchant_Name | Total_Income | Cost_Of_Sales | Gross_Profit_(%)
-----------------------------------------------------------------------------
10000 NuPay R 500.00 R 0.00 100%
10144 Marais R 500.00 R 0.00 100%
10146 Randhart R 500.00 R 0.00 100%
10148 BAFF R 500.00 R 0.00 100%
10150 GLIBSA TTU R 500.00 R 0.00 100%
10151 Kredihold R 500.00 R 0.00 100%
10153 Legal Protec R 500.00 R 0.00 100%

and now i want to set a hyperlink for all the merchant/customer IDs and when i click a merchant ID, I want to actual assign the value to a birt parameter, that i will pass to another birt report which is expecting merchant ID as parameter.

Could someone help me with this because i've been working on this for the whole week.

Thanks in advance.

Kind Regards,
Lucky - Junior BIRT Developer.



#3 For Birt

For Birt

    Member

  • Members
  • PipPip
  • 29 posts

Posted 10 February 2012 - 06:40 AM

Hi,

i hope this will help you,in properties editor you can find hyperlink in expression editor you can select report parameter which you want to assign that customer id.

Thanks!!
Sowjanya.

#4 johnw

johnw

    Senior Member

  • Members
  • 772 posts

Posted 10 February 2012 - 12:46 PM

Set the Hyperlink type as Drill-Through. Then, select the target report. There will be whatever parameters you have available in the target report. You then set the value expression to row["myColumnValueToPassThrough"]. Each hyperlink gets created in respect to the data binding it can see, and in the case of a data element in a detail row, it will be able to see any data value in that row.

John Ward

BIRT Expert

 

Help us improve the BIRT Product and Community by taking this survey.


#5 Khoza

Khoza

    Member

  • Members
  • PipPip
  • 21 posts

Posted 13 February 2012 - 05:05 AM

Set the Hyperlink type as Drill-Through. Then, select the target report. There will be whatever parameters you have available in the target report. You then set the value expression to row["myColumnValueToPassThrough"]. Each hyperlink gets created in respect to the data binding it can see, and in the case of a data element in a detail row, it will be able to see any data value in that row.



johnw, your response helped me a lot, Thanks man.