Eclipse Community Forums: BIRT » replacing string with parameter

Home » Archived » BIRT » replacing string with parameter(Replae Funcion)

replacing string with parameter [message #885362]

Tue, 12 June 2012 17:54

Eclipse User

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

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

Wed, 13 June 2012 06:07

Eclipse User

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

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

Wed, 13 June 2012 14:19

Eclipse User

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 1124 times)

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

Thu, 14 June 2012 04:12

Eclipse User

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Nov 01 04:08:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter