show variable value.

Hello, how can display variable value declare in any method related to table,report,etc in birt version 2.3. As we do in actuate using showfactorystatus.

Find more posts tagged with

Comments

luananicho

I usually just add a Data object to the report, which creates a Column Binding, and type the name of the variable I want to check. Then, run the report.

1. Go to the Palette, and drag a Data object to somplace in your report.
2. On the New Data Binding dialog, you can enter a column binding name, but you don't have to. It will give it the name "Column Binding".
3. Select the Data Type.
4. In the Expression field, type the name of your variable.

Run the report and you'll see the variable value.

When you're done with the Data object just delete it from your report. If you want to "clean up", also go to the Binding tab in the Property Editor - Table window and Remove the Column Binding from the bindings list.

athermehdi

Thanks MR. luananicho for your reply.

I do not need to add a data column to get variable value.

Actually i want to use the last row number which the report display and use it in footer row.

say five data rows ouput variable value five

for six data rows ouput variable value six .......................

AbbyNL

For predefined messages I use the debug log file you can setup. I can see the parameters passed to the Select and the complete Select. I will copy this out and plop it into SQL manager to test. Adding spaces or forgetting a comma on a line gets me sometimes.

To do this in the Outline highlight the Report and using the Script tab look at the initialize method. Add these 2 lines:

mxReportScriptContext.setDefaultLogLevel("DEBUG");
mxReportScriptContext.setDefaultLogFile("c:/temp/myreport.log");

You can set the path and filename to anything.

There is also a bulky replacement to the Actuate showFactoryStatus().

use the mxReportScriptContext variable anywhere you want a custom message to the script logger.

With V7116 you can also Run a preview through BIRT Designer directly to PDF format. This helps if you are adding extra columns and need to get spacing straight.

Hope this helps.