Parameter passing in Sub query used in Crystal Reports
Posted on 1998-07-23
Can Parameters or formulas be passed to a subquery used in Crystal Reports from VB.
For example look at this query shown by Crystal Report "Show SQL Query" option
Select a.field1,b.field2 from a,b where a.field1 = b.field1 and a.field2 not in (select c.field1 from c where c.field1 = <formula>)
Here we are not able to insert a formula in Crystal Report Designer.
We created a Stored Procedure with a parameter in sub query and tried to use this stored procedure in Crystal Report to design a report, but during design time of the report itself, the parameter value is accepted and stored along with the report. So we are not able to change this parameter value during runtime from VB.
Is there any other way we can pass a parameter or formula to a sub query from VB to CR?
We are using VB5.0,MS-SQL Server 6.5, Crystal Report 6.0