|
Re: INPUT PARAMETERS [message #702553 is a reply to message #702461] |
Tue, 26 July 2011 14:04 |
|
Is PROGRAMNAME a report parameter?
Jason
On 7/26/2011 7:59 AM, jeyinul wrote:
> HI ALL,
>
> AND (P.PROJECTNAME='&PN'
> OR P.PROJECTID IN(SELECT EDFI.ITEMID FROM EFORMDYNAMICFIELDINSTANCE EDFI
> where EDFI.FIELD18='&PROGRAMNAME'));
>
> THE ABOVE IS THE CONDITION I AM USING IN MY SQL.
>
> HOW TO ADD THIS INPUT IN BIRT USING REPORT PARAMETERS.
>
> 1. THERE IS NO PROBLEM IN ADDING PROJECTNAME AS A INPUT.
>
> 2. THE PROBLEM IS NEXT INPUT. HERE EDFI.FILED18 IS THE INPUT AND FROM
> THE CODE IT WILL COLLECT EDFI.ITEMID AND STORE IN PROJECTID.
>
> Please help me on this.
|
|
|
Re: INPUT PARAMETERS [message #703255 is a reply to message #702553] |
Wed, 27 July 2011 11:05 |
jeyinul Messages: 60 Registered: June 2011 |
Member |
|
|
YES JASON,
THE BELOW QUERY, I AM USING.
SELECT EDFI.OWNERTYPE,EDFI.ITEMTYPE,P.PROJECTNAME,EDFI.ITEMID,EDFI.OWNERID,
P.PROJECTID,P.STATUS
FROM EFORMDYNAMICFIELDINSTANCE EDFI,PROJECT P WHERE EDFI.ENTERPRISEID='90040'
and EDFI.ITEMTYPE LIKE '%PRGM%'
AND P.PROJECTID=EDFI.OWNERID
AND P.STATUS='Open'
and p.projectapprovalstatus='Approved'
AND (P.PROJECTNAME='&PN'
OR P.PROJECTID IN(SELECT EDFI.ITEMID FROM EFORMDYNAMICFIELDINSTANCE EDFI where EDFI.FIELD18='&PROGRAMNAME'));
|
|
|
Re: INPUT PARAMETERS [message #703402 is a reply to message #703255] |
Wed, 27 July 2011 14:21 |
|
If you replace the value with ? this will create a dataset parameter.
In the parameters tab on the dataset editor you can then link this to a
report parameter. Suppose I have a report parameter named ordernumber.
I can create a dataset with a query like:
select * from orders where ordernumber = ?
this will create a dataset parameter named something like param1. In
the dataset editor under parameters I can link param1 to the report
parameter ordernumber.
Jason
On 7/27/2011 7:05 AM, jeyinul wrote:
>
> YES JASON,
>
> THE BELOW QUERY, I AM USING.
>
> SELECT EDFI.OWNERTYPE,EDFI.ITEMTYPE,P.PROJECTNAME,EDFI.ITEMID,EDFI.OWNERID,
> P.PROJECTID,P.STATUS
>
> FROM EFORMDYNAMICFIELDINSTANCE EDFI,PROJECT P WHERE
> EDFI.ENTERPRISEID='90040'
> and EDFI.ITEMTYPE LIKE '%PRGM%'
> AND P.PROJECTID=EDFI.OWNERID
> AND P.STATUS='Open'
> and p.projectapprovalstatus='Approved'
> AND (P.PROJECTNAME='&PN'
> OR P.PROJECTID IN(SELECT EDFI.ITEMID FROM EFORMDYNAMICFIELDINSTANCE EDFI
> where EDFI.FIELD18='&PROGRAMNAME'));
|
|
|
Powered by
FUDForum. Page generated in 0.01855 seconds