Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Previewing a report via a VB 6 application

Status
Not open for further replies.

Yothepapy

Programmer
Feb 1, 2001
3
BE
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 ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top