How to get Main report value to Display as link for On Demand Report

[ckwizard77]

I have a Main Report in Crystal 10. Inside the Main report there are columns of data that I need to display an ON Demand subreport if they are clicked on. Right now the Main Report works but the column values are not clickable and the sub report names are listed over the top of the Main report values. I tried just putting in a caption value of "" which makes the report names disappear but the column values are still not clickable. If I put anything in the caption for the On Demand subreport it becomes clickable and works fine, but I need to have the value in the columns be clickable. Does anybody have any suggestions????
I am pretty new to Crystal.

 

[IanWaterman]

Right click subreport - Format Subreport
Subreport Tab - you will see a formula box opposite Subreport on demand caption. You can enter a formula in there or just select a field or an existing formula.

This value will appear blue in your report amd will launch your subreport.

Ian

 

[ckwizard77]

It gives me an error stating that the entry must be a string value?? How do you format the formula if the field is a number?

 

[IanWaterman]

totext(numberfield,0,"")

first argument defines number of decimal places
second defines thousand separator

so above is no decimal place and no separator.

Ian

 

[ckwizard77]

I will not be able to test this out until tomorrow.

If I have any problems will follow up.

Thank you for your help so far.

 

[ckwizard77]

That did the trick. Thank you very much!