Sagae
MIS
- Mar 27, 2003
- 50
- 0
- 0
Hi,
I need to get information for a parent part number and the project it is assigned to. The problem is that the original database really does not have the tables related.
My solution was:
Impromptu#1 - prompt user for parent part # - save result as hot file. ((I need to display all the child parts to this whether or not it is assigned to a Project))
Impromput#2 - prompt user for parent part # and Project number
Impromptu# 3 - Report using both hot files joined on child part and outer join on Material hot file
This is working on the client and Web if the user runs each report separtately. I can also write a script to run all three reports on the client.
I have tried a million combinations of dependencies on the Web, but cannot get the prompts to be passed to all steps.
Any ideas???
Thanks in advance,
m
I need to get information for a parent part number and the project it is assigned to. The problem is that the original database really does not have the tables related.
My solution was:
Impromptu#1 - prompt user for parent part # - save result as hot file. ((I need to display all the child parts to this whether or not it is assigned to a Project))
Impromput#2 - prompt user for parent part # and Project number
Impromptu# 3 - Report using both hot files joined on child part and outer join on Material hot file
This is working on the client and Web if the user runs each report separtately. I can also write a script to run all three reports on the client.
I have tried a million combinations of dependencies on the Web, but cannot get the prompts to be passed to all steps.
Any ideas???
Thanks in advance,
m