Subreport Data not appearing on Main Report 1

[petercav]

Hello,

I am trying to link a subreport to a main report because I needed to change the data type of a field so that I could connect 2 tables. My problem is that I have created a formula to convert a number to a string in the subreport and then I have linked the two string fields together when inserting the subreport but it is not returning any data in the main report.
This is a pretty complex problem, but if anyone can make sense of what I just explained, your help would be appreciated.

Thanks

petercav

 

[lbass]

Make sure that both strings are formatted the same. If in the main report, the string appears like:

"1246"

Then when you convert the value in the subreport to a string, make sure to format it without decimals or a comma separator to match the format in the original report:

totext({table.number},0,"")

Otherwise, totext() will result in a string like "1246.00" which won't link correctly.

Before linking, check the format in both reports to make sure they match, and if they don't, adjust the formula in the subreport accordingly, and then insert the link.

-LB