Eclipse Community Forums: BIRT » replacing string with parameter

Help

Home

Home » Eclipse Projects » BIRT » replacing string with parameter(Replae Funcion)

Show: Today's Messages :: Show Polls :: Message Navigator

replacing string with parameter [message #885362]

Tue, 12 June 2012 17:54

A R
Messages: 104
Registered: April 2012

Senior Member

Hi,

I am working on a report design , in which I want to replace a value in where condition (which is read from sql query)with parameter.

Please help me with your inputs and suggestions.

Thanks
AR

Report message to a moderator

Re: replacing string with parameter [message #885605 is a reply to message #885362]

Wed, 13 June 2012 06:07

Dnns .
Messages: 30
Registered: May 2012

Member

Hi,

first you have to create a Parameter at the "Edit Data Set"-Dialog. Open the dialog and choose "Parameters" at the left side. Then click the "New..." Button. Enter a Name for this parameter at the first line. Then you have to think if you want to use a reportparameter directly, or not. If want to use it directly choose this parameter in the "Linked To Report Parameter" ComboBox. Otherwise you can enter a Default Value (Constant or JavaScript Syntax). You also have to choose the right Data Type!

If you have done this, you can use this parameter by entering a "?" in your Query.

SELECT * FROM table WHERE column = parameter

for parameter you have to use the "?"

SELECT * FROM table WHERE column = ?

I hope you understood my explanation, and it helped you. Otherwise let me know.

Dnns

Report message to a moderator

Re: replacing string with parameter [message #885855 is a reply to message #885605]

Wed, 13 June 2012 14:19

A R
Messages: 104
Registered: April 2012

Senior Member

Hi Dnns - Thanks for the response.

I am trying to do the same, but getting the following error, attached.

Thanks
AR

Attachment: error_jun13.txt
(Size: 5.30KB, Downloaded 60 times)

Report message to a moderator

Re: replacing string with parameter [message #886086 is a reply to message #885855]

Thu, 14 June 2012 04:12

Dnns .
Messages: 30
Registered: May 2012

Member

Please let me know, what your SQL Query was. Which datatype you have chosen? (Is it the same datatype than the column has?

Report message to a moderator

Previous Topic:	Custom StyleSheet not included when viewed?
Next Topic:	Multiple graphs per report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 08:37:19 EDT 2013