Prepare fails
Hello
I'm slightly new to FastReport, please bear with me...! [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> I'm trying to create a Windows Service in .NET that will periodically email out reports. The report is defined with a SQL Server query. The connection object is set to the parameter ConnectionString. The code I have is : using (Report report = new Report()) { report.Load(@c:\temp\untitled.frx); report.SetParameterValue("ConnectionString", @Data Source=whatever;AttachDbFilename=;Initial Catalog=ppg_head;Integrated Security=False;Persist Security Info=False;User ID=whatever;Password=whatever); report.Prepare(); } The call to Prepare() fails. What have I missed out?? Thanks! EDIT: I've worked it out... the ConnectionString was wrong. Sorry for wasting peoples' time![/img]
I'm slightly new to FastReport, please bear with me...! [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> I'm trying to create a Windows Service in .NET that will periodically email out reports. The report is defined with a SQL Server query. The connection object is set to the parameter ConnectionString. The code I have is : using (Report report = new Report()) { report.Load(@c:\temp\untitled.frx); report.SetParameterValue("ConnectionString", @Data Source=whatever;AttachDbFilename=;Initial Catalog=ppg_head;Integrated Security=False;Persist Security Info=False;User ID=whatever;Password=whatever); report.Prepare(); } The call to Prepare() fails. What have I missed out?? Thanks! EDIT: I've worked it out... the ConnectionString was wrong. Sorry for wasting peoples' time![/img]