Skip to Content
0
Former Member
Dec 05, 2011 at 05:38 PM

Hard Code some database parameters for Stored Proc in Crystal Report

179 Views

Hi,

I want have 2 crystal reports that get data from a SQL*Server proc 'MyProc'

MyProc has to SQL*Server parameters @Mode int, @Caller varchar(50)

What I want is for Report 1 to have only one Screen Parameter 'Enter your name' and default the value for the @Mode SQL*Server parameter to 1 (Not showing @Mode in the parameter screen when you run the report.

I want report2 to do the same thing, but setting the @Mode to 2 without showing @Node on the screen to the user, Just asking Your Name and passing that in as @caller.

How do I do this?

Help