Eclipse Community Forums: BIRT » Passing result of one dataset as a parameter of another in the same report

Home » Archived » BIRT » Passing result of one dataset as a parameter of another in the same report(Datasets and parameters )

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

Passing result of one dataset as a parameter of another in the same report [message #1775525]

Tue, 31 October 2017 11:55

Stuart Streitberg

Messages: 1
Registered: October 2017

Junior Member

Hi all new to Birt and wondering if and how to use the results of one dataset as a parameter in another?

The scenaro i am working with is i have a list of vehicle ids and licence plate numbers which i am wanting to find trips for.

Using where txt_lpn =ABC123 is costly via sql.
My thought was to use seperate queries one to look up the id for the lpn and pass over as an imput to the main query.

Ay thoughts

Report message to a moderator

Re: Passing result of one dataset as a parameter of another in the same report [message #1791377 is a reply to message #1775525]

Thu, 28 June 2018 13:07

Phil Grant

Messages: 1
Registered: June 2018

Junior Member

Hi Stuart,

Been a while since you posted this but its exactly what I am trying to do and I can't find out how to do it.

I don't suppose you had any joy did you?

Thanks
Phil

Report message to a moderator

Previous Topic:	Setting a default DB Connection
Next Topic:	mysql request with list param

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 20:16:45 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter