By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Report to query parsing

jimleon
P: 74
I have 4 reports which all reference the same query. The query prompts for a dept code letter which dictates which dept the query works. Is there a way to parse this code letter to the query from report?

Thanks in advance.
Jan 11 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 218
Not sure I understand what you are trying to do...

Can you explain a bit more, then help might be easier to give

Steve
Jan 11 '07 #2

ADezii
Expert 5K+
P: 8,638
I have 4 reports which all reference the same query. The query prompts for a dept code letter which dictates which dept the query works. Is there a way to parse this code letter to the query from report?

Thanks in advance.
Create a Calculated Field within the Query that consists of the exact Parameter Prompt, e.g. LName:[ENTER Last Name]. Whatever value you enter for the Parameter will now be parsed to the Report. In the Field List Dialog, LName will now be displayed. Is this what you were referring to?
Jan 11 '07 #3

NeoPa
Expert Mod 15k+
P: 31,492
Try setting the report's Filter properties.
Jan 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.