Problem with subrpt links in crystal reports 8.5 (cr 9 and 2008 installed)

[Former Member]

I am trying to add a subreport to an existing CR 8.5 report. I currently have Cr 8.5, cr 9 and cr 2008 on my pc (xp). The subrpt is pointing to a sql 2005 stored procedure that has a parameter (@vvcrCono). When I try to set up the link, the parameter is not listed in the of available parameters to link to. I select a field from the available fields on the main report, hit the > to move it over as a field to link to, and the dropdown that contains the list of parms to link to on the subreport will change to ?pm-(fieldname). I do not see the parm list from the subreport. I am unable to get the link defined. This occurs even when trying to edit an existing subreport.

Is there a problem with running these crystal report versions on the same machine? Or am I just missing something? It has been a while since I've used cr 8.5.

[Former Member]

Well...I opened this question needlessly. Turns out I just wasn't seeing the tiny scroll bar when I clicked on the 'subreport parameter field to use' drop down..lol. I almost didn't post this but figured somebody else might have the same problem. Looks like they made it more obvious in CR 9, smile.

[Former Member]

Joanne, thank you for your posted solution and specifically your mention of miniscule scroll bar of the 'subreport parameter field to use' drop down, I had been on several forums but none of them mentioned this, my subreport now accepts the passed parameter and main report works well. Hope your post helps others as it did me, only wish we could include a graphic to illustrate this as I have seen same question posed several times and several different msg boards.

[former_member260594]

Joanne,

Having the 3 versions of Crystal on 1 machine shouldn't be an issue as they all have their own folder structure.

I would suggest double checking the parameter type and the field type you are trying to link to. If they are not the same type then the SP parameter will not appear in the list.

[Former Member]

Thanks for the reply. I did check the parameter types and they are the same data types. The Crystal Reports versions are also installed in different folders.

I'm going to have a coworker try it on his machine sometime today...He only has cr 8.5 and cr 9. I'll let you know if it works or not.

[former_member260594]

Joanne,

You might want to test this in CR2008 as CR8.5 was never tested against SQL Server 2005 just to make sure it isn't a db compatibility issue.