I've been trying to do some research on passing prompt values from one report to a linked report, and it seems like about the only way to do this is via a stored process that updated/reads a table... Is there some other solution that I'm just missing? In report 1, you select a start and end date. Report one is linked to another report and some of variables are tied to filters on report 2. But report 2 always prompts me for the start and end date because I can't figure out how to pass those values... This seems like something that should be built in, but I'm guessing it's not? I'm not having a great deal of luck with the "stored process/table update" method, and I'd prefer not to create 2 seperate information maps tied to seperate stored procs as described in that method. Any other ideas that I could try?
... View more