Skip to Content
0
Former Member
Apr 14, 2010 at 12:03 AM

Pulling Parameters from SQL Database

51 Views

This is probably something simple that I'm missing, but I'm new to CR.

I have a report where I am trying to populate a parameter value from a database field...how do I do this?

I do not want the end user to have to enter this parameter.

The parameter (database value) changes on a regular basis.

More Detailed Explination:

Report executes a SQL stored procedure with declared variable data. This particular report is looking for a startdate and enddate. There is a seperate table which is populated with these values - ONLY ONE RECORD called mindate and maxdate.

I need CR to set parameter.startdate=SQLtable.mindate and parameter.enddate=SQLtable.maxdate, and then pass this to the stored procedure.

Thanks for your help.