I am running into a strange issue, that I can't seem to figure out. I have a summary report based on the results of a stored procedure... I have a prompt page the asks for a StartDate and an EndDate which are passed to the Stored Procedure.Â
My problem starts when I try to create a drill-through from my summary to a detailed report. I am trying to add the StartDate and EndDate Parameters to my query as Query Items so they are available to pass to the drill-through report:
I am adding a data item as a fact, and giving it the value ?StartDate?
Even before trying to link it to the drill through, when the report runs, I get the error:
QE-DEF-0374 Prompt 'StartDate' is used multiple times with conflicting data types.When I look at the SQL being generated to call my stored procedure, it is using my date as a timestamp (But I can't seem to change that).Â
I have cast ?StartDate? as every conceivable data-type in my data item, but continue to get the same error, no matter what I do...Â
Any insight would be GREATLY APPRECIATED!! It's Driving me Crazy!! Â
Oh, and my only work around so far is to re-ask for dates between my summary report and the drill-through report, and that won't fly for long around here
