Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating controls dynamically 1

Status
Not open for further replies.

sphungtham

Programmer
May 26, 2004
18
CA
Just wondering if anyone knows how to create a control dynamically and then show it in a frame of a report. I'm actually trying to show a logo on a report if the correct parameter is sent to the report.

Thanks.

-Somsong
 
You don't need to create the logo dynamically. Just put it there and then just hide it or not depending on the parameter.
 
Yeah that's what I tried too.

For the conditional section, by using the expression editor you can only use columns in the datastream right. the parameter I'm passing is coming in through a web browser.

 
Using SQL, can you create an additional column that would assume different values depending on the parameter, and then use the column in the expression editor?
Something like
decode(<parameter>, yes_value, 'Show', 'Not Show')
The value of the new column will depend only on the parameter and be the same for all rows.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top