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 :)