generate report with a visual basic variable

[furlman41]

I'm a brand new CR user. I am working with a Visual Basic program. I was wondering if there was any way to filter a report with a variable from visual basic.

ex. I want to display the report WHERE Client.ClientID = clientID(variable from VB), rather than define the variable in CR.

Any advice?

 

[synapsevampire]

It's something like:

crxreport.RecordSelectionFormula = "{Client.ClientID} = " & VBVAR

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[furlman41]

Thanks for the quick response.

When i tried your piece of code I got the following error:

Run-Time Error 438:
Object doesn't support this property or method.

For some reason .RecordSelectionFormula isn't recognized. I am using the old version of CR(4.6) that comes with Visual Basic. Is this the reason?

-john