I have created a document and there are four reports. Is there a way to write one prompt to fill all four of the reports instead of typing the information in four times?


BY MAKING ALL PROMPTS EXACTLY THE SAME, ONLY ONE PROMPT SHOWS UP. ON SOME REPORTS THE FIELD WAS CALLED ITEM_ID AND ON SOME IT WAS ITEM_NO. I JUST RENAMED THE FIELDS.

THANKS!!!

This message has been edited. Last edited by: Pops,

Pops

While creating your reports make the common field the "Coordinated" field in each report and then when it runs there will be a drop down to choose which one you want to use and it will update all 4 reports.

Thank You. No to show just how limited my knowledge is in regard to Info Assist, how do I make a field the "Coordinated" field?

Thanks.

Pops

Not a problem... When you create a Document with InfoAssit under the Query panel you will see Sum, By, Across and Coordinated as parts of the Query. Drag the field you want to coordinate the reports with to the Coordinated portion of the query.

In what release did Coordinated fields start?

I only have SUM, BY and ACROSS.