Hello,
here is an example of the problem
we are previewing a report via VB6.
The report is constitued of
Main Report (parameters: @id, @name, sub1,sub2) based on a SQL Server 6.5 stored proc with 2 parameters (id and name)
sub1 and sub2 are added parameters (no contained in a stored proc)
Sub Report1 (parameters: @name, sub1) based on a SQL Server 6.5 stored proc with 2 parameters (name, sub1)
Sub Report2(parameters : @name, sub2) based on a SQL Server 6.5 stored proc with 2 parameters (name, sub2)
We give via VB6 to the report only the parameters for the main Report (because the subs only take the sames of the main)
SO ->@id, @name in collection StoredProcParam(id)
->sub1, sub2 in collection ParameterFields(id)
Via CR 8.0 -> no problem if we call the report several times with different parameters
Via VB 6 -> no refresh of the subs.
Must we always give parameters in VB to sub reports of the Report. Do you have an example ?
here is an example of the problem
we are previewing a report via VB6.
The report is constitued of
Main Report (parameters: @id, @name, sub1,sub2) based on a SQL Server 6.5 stored proc with 2 parameters (id and name)
sub1 and sub2 are added parameters (no contained in a stored proc)
Sub Report1 (parameters: @name, sub1) based on a SQL Server 6.5 stored proc with 2 parameters (name, sub1)
Sub Report2(parameters : @name, sub2) based on a SQL Server 6.5 stored proc with 2 parameters (name, sub2)
We give via VB6 to the report only the parameters for the main Report (because the subs only take the sames of the main)
SO ->@id, @name in collection StoredProcParam(id)
->sub1, sub2 in collection ParameterFields(id)
Via CR 8.0 -> no problem if we call the report several times with different parameters
Via VB 6 -> no refresh of the subs.
Must we always give parameters in VB to sub reports of the Report. Do you have an example ?