Forums » General Discussion

Thread: how to include a drop-down selection list (sub-query) in a report

This question is answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 3 - Pages: 1 - Last Post: Aug 30, 2012 12:44 PM by: dbyy
dbyy

Posts: 12
Registered: 2/20/11
how to include a drop-down selection list (sub-query) in a report
Posted: Aug 17, 2012 4:47 AM
 
  Click to reply to this thread Reply

Hi everyone,

I'm trying to figure out how I could include a drop-down selection list in a Toad4Mysql report.

i.e. I'm using the tables "Tasks" and "Projects" from dotProject.
When running a task report, I would like to select a specific project from the DDL to get all tasks for this project?

I know I could add a parameter field to the report to enter the project ID, but I do not always have the Project ID handy and I would have to run a stand-alone query to get the needed ID.

I'm certain the report writer will allow this, I just can't figure it out.

Any help much appreciated.

TIA
Fred



dbyy

Posts: 12
Registered: 2/20/11
Re: how to include a drop-down selection list (sub-query) in a report
Posted: Aug 29, 2012 6:14 PM   in response to: dbyy
 
  Click to reply to this thread Reply

No information available from one of the experts?





Mauritz

Posts: 313
Registered: 8/23/07
Re: how to include a drop-down selection list (sub-query) in a report
Posted: Aug 29, 2012 8:21 PM   in response to: dbyy
 
  Click to reply to this thread Reply

Sorry but this is not possible.


dbyy

Posts: 12
Registered: 2/20/11
Re: how to include a drop-down selection list (sub-query) in a report
Posted: Aug 30, 2012 12:44 PM   in response to: Mauritz
 
  Click to reply to this thread Reply

That is not the answer I was hoping for.
However, thank you for the reply.

Fred


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums