Roger Choi

Using Prompts with a Query with Subquery..

First time poster here..

Is it even possible to using prompts in a query with a couple of subqueries?

I tried to filter results using a prompt for fiscal year and accounting period, but it doesn't filter out anything at all.

Any help would be greatly appreciated.

Tags: filter, prompts, query, subquery

Views: 13

▶ Reply to This

Replies to This Discussion

SharathPermalink Reply by Sharath on April 22, 2009 at 11:54pm
Hi Roger,
I am not sure if I understand you correctly. Copy paste the query and the record you're using for prompts.
Regards.
Roger ChoiPermalink Reply by Roger Choi on April 23, 2009 at 2:45pm
A query built by someone else had 3 tables joined and a subquery included. An end-user wanted to add prompts so he could enter a date range and such.

After a few hours of trial error, I was able to get the query working with prompts.

I added the same prompts on both top level query and the subquery.

Thanks for your concern!
srikanth reddyPermalink Reply by srikanth reddy on June 10, 2009 at 4:56pm
yes and yes. you can create prompt but did you USE it as a criteria is the question . please post the SQL i can check that for you
Roger ChoiPermalink Reply by Roger Choi on June 10, 2009 at 9:26pm
I have somewhat resolved the issue by adding the same prompts to both main query and the subquery.
Thank you for your help guys!

RSS

© 2012   Created by PSoftPros.

Badges  |  Report an Issue  |  Terms of Service