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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I add PAL variables to reports 1
- Thread starter paulvos
- Start date
-
1
- #2
Check out the writeEnvironmentString method. Use it and a calculated field (with readEnvironmentString) in the report.
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
- Thread starter
- #3
I dont think you can directly link the variable from code to the report. What I would do (and this is me), is I would add the value from variable to a table and then link the field in the report to the filed in the table.
But once again that's just me, and there should be a easier way.
But once again that's just me, and there should be a easier way.
No Paul, you were clear. I was assuming you clicked a button or something to generate the report. In the button code before the call for the report simply add the line:
writeEnvironmentString("myVar",ReportTitleVar)
Where "myVar" (quotes required) is the environment variable you are creating, and ReportTitleVar is a string variable to which you assign the return value from your title naming form. Don't forget to declare ReportTitleVar in your var/endvar statement.
In your report design, add an unbound field where you want the title. Right-click the field and choose 'define field'. When the dialog box opens, check the 'calculated field' box and put this code in the calculation blank:
readEnvironmentString("myVar"
When you run the report using your code, the report title appears. If you do it manually using QBE there will be no title since the ReportTitleVar variable is never assigned.
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
writeEnvironmentString("myVar",ReportTitleVar)
Where "myVar" (quotes required) is the environment variable you are creating, and ReportTitleVar is a string variable to which you assign the return value from your title naming form. Don't forget to declare ReportTitleVar in your var/endvar statement.
In your report design, add an unbound field where you want the title. Right-click the field and choose 'define field'. When the dialog box opens, check the 'calculated field' box and put this code in the calculation blank:
readEnvironmentString("myVar"
When you run the report using your code, the report title appears. If you do it manually using QBE there will be no title since the ReportTitleVar variable is never assigned.
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question