How can I make a label (Text Field) invisible?

[vbasic]

Hello all, and a big thanks to everyone who responded to my last question about printing across a section. Since this lame product wont support that, I have had to resort to createing subreports for each section across the main report sections. Unfortuatnly, this has left my main report with like 8 subreports. My delimna is this: How can I make a text field (not a DB field) = to a "" when the corresponding DB value is empty? Basically, I want to supress the subreport when no records are returned. I searched, and see that this is yet another shortcoming in good old crystal that seems to require a major workaround. What a surprise.

Also, one other question, is there an easy way to pass a concatinated string to the subreport as a param?
For example, I have 4 subreports in my section, and for each section I want to exclude the previous records that have already printed. IE - the first pass I am passing in nothing so that record A will print in that subreport then I want to pass a value from record A so that B will print, then I want to pass in A,B so that C will print and so on. Is there a way to do this that doesnt take a week's worth of programming effort?? All I need to do is pass the string as a single parm and I have a SQL routine to parse it properly. So Basically, can I pass a value that looks like the following
A,B first subreport
A,B,C second subreport
A,B,C,D third subreport. etc.

Thanks again!!!!!

 

[kenhamady]

If you can create a formula field in the main report that has your string, you can also create a parameter field in the subreport and link the paramter field so that it takes its value from the formula. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.