Find Code:
All Words
Any of the Words
Exact Phrase
Home
:
Code
:
Forums
:
Submit
:
Mailing List
:
About
:
Contact
Code
All
VB.NET
ASP.NET
C#
VB Classic
ASP Classic
Snippets
Popular
Resources
Submit Code
Forums
Articles
Tips
Links
Books
Contest
Link to us
Refresh subreport in Crystal Report
Author:
Dipak Tanuj
E-mail:
Click to e-mail author
Submitted:
12/4/2004
Version:
VB6
Compatibility:
VB6
Category:
Databases
Views:
21178
Here we explain how you refresh subreport from Visual Basic code.
Declarations:
'Here use CrystalReport Active X Control 'Here we use SQL 2000 as backhand. 'if u any doubt then mail me back
Code:
ReportFileName = App.Path & "FileName.rpt" ParameterFields(0) = "ParameterField;" & Argument & ";True" DataFiles(0) = DSNname & ".dbo.TableName" Connect = "dsn=" & DSNName & ";uid=sa;pwd=sq;dsq=" & DSNName SelectionFormula = "Selection Criteria" '====== For SubReport Change ===== SubreportToChange = "subreportname.rpt" DataFiles(0) = DSNName& ".dbo.TableName" SubreportToChange = "" '======= COMPLETE =========== WindowState = crptMaximized Destination = crptToWindow Action = 1
Home
|
Forums
|
Submit
|
Books
|
Mailing List
|
Advertising
|
About
|
Contact
© 2024 A1VBCode. All rights reserved.
Legal disclaimer & terms of use
Privacy statement