Selecting records by UserID and CaseID

[ausmoran]

I have developed a Stored Procedure in MS SQL2000 which combines (UNION) simple select statements from four different tables to produce one data set of names and addresses. Each of these tables are linked via a USERID and a CASEID.

I have spent too many hours trying to figure out how to create simple parameterized mailing labels in Crystal Report version 9 that will generate a page of labels for only a unique USERID and CASEID. As it is now, when I run the labels, I generate a special page for EACH CASEID but there is NO parameter asking which caseID to use, nor is there a parameter asking which USERID to use.

Can someone give me a hand with this, or point me towards a white paper that might help me out? Thanks very much, in advance. I really appreciate your assitance,

- Austin (very much, a novice when it comes to Crystal)

 

[Durango122]

hi
in your storeprocedure
delare @UserID
and @CaseID
then when you run your report it will prompt for user id and case id

good luck


Durango122
Remember to used all fingers when waving to policemen