We are using VSReportDesigner 8. When i try to retrieve the report's connectionstring property at runtime on the OnOpen event with VBScript, i do not get a value returned.
the code i am using is: msgbox "Main Report Connection String: " & report.DataSource.ConnectionString
this gives me a blank messagebox. I need a way to extract the connection string with vbscript at runtime so i can make a change to the connection string and re-assign the new connection string to a subreport in the main report.
note that i can pull the subreport's existing connection string in the OnOpen event successfully with the following code : msgbox "SubReport Conn String: " & subRpt1.subreport.DataSource.ConnectionString
Is there a way to extract the main report's connection string property value with VBScript? if so, can someone please tell me what it is?
thanks.