OfficeWriter designer .net for excel - parameters dialog not showing?

Question

I am trying to view an SSRS report (2008 R2 .rdl) with parameters in OfficeWriter designer .NET for excel but its not showing the parameters dialog also not displaying any alert/error. How can i show the parameters dialog? Thanks.

Answer 1

Pass parameters programmatically (most common)

If you’re rendering the report via code (ASP.NET / WinForms / etc.), you must explicitly add the parameters before rendering.

Example (C#):

SSRSReport report = new SSRSReport();

report.ReportPath = "/YourReportPath/ReportName";

// Add parameters manually

report.Parameters.Add("StartDate", "2024-01-01");

report.Parameters.Add("EndDate", "2024-12-31");

// Then render

ExcelApplication excel = new ExcelApplication();

excel.Workbooks.Add();

report.Render(excel);

If parameters are missing, OfficeWriter does not show a dialog, it just renders nothing or defaults.