If you are unable to create a new account, please email support@bspsoftware.com

 

Trying to Drill-Through passing a parameter from Stored Procedure

Started by rvitatoe, 20 Apr 2006 04:03:26 PM

Previous topic - Next topic

rvitatoe

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