|
Replies:
3
-
Pages:
1
-
Last Post:
Aug 30, 2012 12:44 PM
by: dbyy
|
Threads:
[
Previous
|
Next
]
|
|
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
|
|
|
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
|
|
|
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
|
|
|
No information available from one of the experts?

|
|
|
Posts:
314
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
|
|
|
Sorry but this is not possible.
|
|
|
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
|
|
|
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)
|
|