Pass Value to Report Heading

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

ログインを記憶

パスワードを忘れましたか？

解決済み Pass Value to Report Heading

Hi
How i can pass values to only display on the Reporte Heading to show example name of person who make the Reports
From XOJO

SOLVED!

There are no comments made yet.

返信 (13)

Sergey Pashkov 承諾済みの回答

Hi Alexis,

You can use report parameters for it, here is an article

You should use parameter in expression.

There are no comments made yet.

Jochen Peters 承諾済みの回答

but parameters is for the query and the values i need to pass is no for the query

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

Parameters can be used in expressions as well since the version 6.3

There are no comments made yet.

Jochen Peters 承諾済みの回答

ok
how i use that expression from XOJO to the Report

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

For example you have defined param1 in expression:



dim theReport as VReport

 

theReport = my_project.MakeNewReport( 

               "report_1", 

               "sqlite://c:/somedb.sqlite", 

                "SELECT fldName, fldPhone FROM tblPerson" )

 

theReport.SetParameterValue( "param1", "value1" )

There are no comments made yet.

Jochen Peters 承諾済みの回答

ok
Thanks

There are no comments made yet.

Jochen Peters 承諾済みの回答

this my XOJO Code
mReport.SetParameterValue("param1",TxtDateFrom.text.Trim)

this is the code in the expression and do no show the date on the Report
$P(param1)
what i am doing wrong

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

Looks correct.

You can also try with a default value of parameter.
$P(param1=default_value)

Is the parameter recognised and you can see the default value in the preview?
And from Xojo app?

There are no comments made yet.

Jochen Peters 承諾済みの回答

if $P(param1=default_value) it show on the report default_value but if i send the parameter from XOJO no show any value

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

Without SetParameterValue it shows default_value.
With SetParameterValue it is empty, right?

There are no comments made yet.

Jochen Peters 承諾済みの回答

with SetParameterValue it shows default_value and without it shows default_value

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

And the sequence of calls is:
1. MakeNewReport
2. SetParameterValue
3. PrintToDisk/PrintToBuffer

Right?

There are no comments made yet.

Jochen Peters 承諾済みの回答

ok
thanks
that was the problem the order of the call for the SetParameterValue

now works

There are no comments made yet.

ページ :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

返信するにはログインしてください

投稿するにはログインする必要があります。右側のフォームからログインするか、新規アカウントを作成してください。ここで登録 »

パスワードを忘れましたか？

解決済み Pass Value to Report Heading

Categories

Products

Support

Company