I am trying to build a report with parameters that are entered on a vb.net form. I am taking that dynamic sql and creating a dataset with it. I have a stored procedure that utilizes the COALESCE function so it deals with parameters with and without values...problem is the Crystal report is always prompting for the values.....How do I pass the values to crystal. I am filling the dataset with a dynamic sql statement ie...
@sql = 'Select * from tblProducts '
@strSQL = @sql & 'WHERE ' & xxxxxxxxxxxxxxxxxxx
Basically, it started out as a form with parameters, and I loaded a datagrid depending on what was selected. Then i thought, great I want to pass that dataset to crystal and run a report on it....Thats what I am trying to do....
@sql = 'Select * from tblProducts '
@strSQL = @sql & 'WHERE ' & xxxxxxxxxxxxxxxxxxx
Basically, it started out as a form with parameters, and I loaded a datagrid depending on what was selected. Then i thought, great I want to pass that dataset to crystal and run a report on it....Thats what I am trying to do....