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