Passing parameter results to subreport command

Question

I have a subreport that will search a table pulling all matches depending on two things. 1.) Some filtering criteria in the command for the subreport and 2.)it will search based on the criteria pulled by a parameter from the main report.

1.) Is this possible? I have tried for a few days now to get this to work but I feel I am missing something. I cannot get the field in the main report to pass the information to the parameter for the command in the subreport.

Here is the command for the subreport.....

DECLARE @DIE VARCHAR (20)
SET @DIE = '1315240018'

SELECT DISTINCT BCKUPDIE.TOOL1

FROM FS11HD AS BCKUPDIE

JOIN FS11HD AS ORGDIE 
    ON 
    BCKUPDIE.DIE_SHAPE = ORGDIE.DIE_SHAPE
    AND BCKUPDIE.AROUND1 = ORGDIE.AROUND1
    AND BCKUPDIE.ACROSS1 = ORGDIE.ACROSS1
    WHERE ORGDIE.TOOL1 = @DIE

When run in sql it will give me any TOOL1 rows that have matching criteria. This is what I want my subreport to, am I going about this the wrong way?

did you try linking the subreport by the parameter on the main report? — cojimarmiami
Yes that was one of my first tries but I ran into several issues doing that..... How am I suppesed to "SET" the declared variable as a parameter coming from the main report? More importantly what is the syntax? Secondly, when i got rid of the declare and just used where, I was unable to assign the variable to that command statement — Matthew Jakachira
Lastly, when I try to change subreport links my declare @die never shows up so that I can link that with my dies field from the main report — Matthew Jakachira

Stephen Bodine Stephen Bodine · Accepted Answer · 2014-12-15T21:25:31

We have an old version of Crystal report (XI) but the logic might be the same with your version.

On the menu select [Edit] [Subreport Links].

Select the sub report from the pick list then map your select choices to the sub reports selection criteria.

On the sub report you will have to have parameter fields that will match the values up with the values you wish to pass. Such as if you select date as a selection criteria on the main report and you want the sub report to also filter by this date create a date pram in the sub report. By linking all the select criteria with [linked] values it will behave as a straight through pass of the parameters without a prompt box being all have been answered via the linkage between documents.

Passing parameter results to subreport command

2 Answers