I have a little VB.net web application which connects to Oracle using ADO.NET so i make connection
Dim Oraclecon As OleDbConnection = New OleDbConnection("Provider=MSDAORA.1;Data Source=name;Password=pass;User ID=name;")
and all work good till i try to use crystal report. it generate...
In my report i have parameter in sql query. And i found 2 ways how to change parameter in VB.NET 2003(using crParameterValues.Add and crReportDocument.SetParameterValue) but then i save my report (crReportDocument.SaveAs("c:\\name.rpt", ReportFileFormat.VSNetFileFormat)) it's blank!! It's blank...
In my report i have parameter in sql query. And i found 2 ways how to change parameter in VB.NET 2003(using crParameterValues.Add and crReportDocument.SetParameterValue) but then i save my report (crReportDocument.SaveAs("c:\\name.rpt", ReportFileFormat.VSNetFileFormat)) it's blank!! It's blank...
in my report i have parameter in sql query something like this select * from table where id = {?docid}. i want it to change then refresh data and save report as .pdf
i found an example how to change parameters :
some defintions and choice parameter to change
crParameterDiscreteValue =...
I make a simple module but fucnions in it should know where from they are called - file name and line in the file. Is it possible?? and how?? thanks in advance..
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.