Eclipse Community Forums: BIRT » report parameter as dataset filter works in dev, not on production

Home » Archived » BIRT » report parameter as dataset filter works in dev, not on production

report parameter as dataset filter works in dev, not on production [message #903584]

Fri, 24 August 2012 08:24

Eclipse User

so I successfully created my nested table, (Thanks Jason), and migrated it to the production system (Birt 3.2.21)

my leaf most dataset uses a defined filter (its second filter) which uses the report parameter.

in the designer testing it work perfectly..
in the production system this parameter appears to be ignored.
the Birt version shipped with IBM Ration Team Concert is unknown to me,
but the product shipped last October, and the major version was released June 2011,
over year ago..
(so this could be a bug or lack of feature in the runtime)

is there another way, short of passing the parm thru the nested tables as a calculated field? (this wouldn't be hard, just time consuming)

Thanks

Sam

Re: report parameter as dataset filter works in dev, not on production [message #903623 is a reply to message #903584]

Fri, 24 August 2012 11:06

Eclipse User

Sam

Can you put that file io im I sent you in the filter to see what the
parameter value is when the filter is calculated?

Jason

On 8/24/2012 8:24 AM, sam detewiler wrote:
> so I successfully created my nested table, (Thanks Jason), and migrated
> it to the production system (Birt 3.2.21)
>
> my leaf most dataset uses a defined filter (its second filter) which
> uses the report parameter.
> in the designer testing it work perfectly.. in the production system
> this parameter appears to be ignored. the Birt version shipped with IBM
> Ration Team Concert is unknown to me,
> but the product shipped last October, and the major version was released
> June 2011,
> over year ago..
> (so this could be a bug or lack of feature in the runtime)
>
> is there another way, short of passing the parm thru the nested tables
> as a calculated field? (this wouldn't be hard, just time consuming)
>
> Thanks
>
> Sam
>
>
>

Re: report parameter as dataset filter works in dev, not on production [message #903638 is a reply to message #903623]

Fri, 24 August 2012 11:42

Eclipse User

that out.print will run on the server and store on the server disk, which I don't have access to

Re: report parameter as dataset filter works in dev, not on production [message #903644 is a reply to message #903638]

Fri, 24 August 2012 12:20

Eclipse User

Can you add a data item to the table and set its value to
params["yourparametername"]

Jason

On 8/24/2012 11:42 AM, sam detweiler wrote:
> that out.print will run on the server and store on the server disk,
> which I don't have access to
>
>

Re: report parameter as dataset filter works in dev, not on production [message #903649 is a reply to message #903644]

Fri, 24 August 2012 13:07

Eclipse User

on the production server the parameter is in 'quotes'.

the input is UDM, the displayed calculated column is 'UDM'
(I didn't add the quotes)

Re: report parameter as dataset filter works in dev, not on production [message #903653 is a reply to message #903649]

Fri, 24 August 2012 13:30

Eclipse User

and the function we put in to control visibility of the headers also isn't working.
on the production machine

so I deployed the report design as a template
then created a report from the template
then ran the report (it prompted for project name)

it reported the right stuff except

1. the filter didn't exclude records
2. the functions on the header rows didn't fire

Re: report parameter as dataset filter works in dev, not on production [message #903673 is a reply to message #903653]

Fri, 24 August 2012 16:15

Eclipse User

Sam

Do you have any details on the production server?
Is is using the BIRT viewer? What is the url to run the report?

Jason

On 8/24/2012 1:30 PM, sam detweiler wrote:
> and the function we put in to control visibility of the headers also
> isn't working.
> on the production machine
>
> so I deployed the report design as a template
> then created a report from the template
> then ran the report (it prompted for project name)
>
> it reported the right stuff except
>
> 1. the filter didn't exclude records
> 2. the functions on the header rows didn't fire
>
>

Re: report parameter as dataset filter works in dev, not on production [message #903675 is a reply to message #903673]

Fri, 24 August 2012 16:22

Eclipse User

quotes is a known difference

jazz.net/wiki/bin/view/Main/ReportsViewingDifferences

[Updated on: Fri, 24 August 2012 16:23] by Moderator

Re: report parameter as dataset filter works in dev, not on production [message #903682 is a reply to message #903675]

Fri, 24 August 2012 17:11

Eclipse User

this is working now

Previous Topic:	how to edit the value of a result table field
Next Topic:	BIRT 2.7 WebSphere 7

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 04 19:21:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter