Passing a multiline formula from VB to CR possible??

[rchandr3]

Hi Crystal Geniuses,

I wish to pass a multiline formula with select and case from VB to Crystal. Is that possible?

I tried chr(13) and vbnewline... They dont work...

I am using VB 6 and Crystal Reports 8.5

Thanks in Advance

 

[synapsevampire]

I think that you're better served demonstrating what you need, there's no reason to have a formula of multiple lines as it's just code and multiple lines doesn't change anything.

Perhaps you mean that you're trying to output multiple lines from a formula?

If so, chr(13) is correct, but you need to set the property to can grow.

If that isn't it, post example data, what you tried, and expected output.

-k

 

[rchandr3]

Thanks Synapsevampire....

My problem is this:

I want to display a Pie-chart based on the formulae passed from VB. The formula has select and cases and works well withing Crystal without any VB connection. Newline expected message comes when I make the formula in one line with VB Syntax. In Crystal Syntax, its okay with a single line.

When I pass the formula, the formula string appears instead of the required output in the Pie-Chart. This is with bothe the VB and Crystal Syntax formulae.

I am confused and am struggling with that for a few days and my deadline is fast approaching...

Please help me further.

 

[synapsevampire]

Try posting what you tried.

It sounds like it's being passed as a string, possibly a quote problem.

-k