Creating reports and dashboards | Stimulsoft community forum

amarinelli wrote:it's possibile to build a report with a dialog form that is shown only if a certain parameter is not set?

for example:
- I made a simple list of items and I want to view them based on their Category ID
- added a datasource with named parameter @pCategoryID (int) in query
- I added Form1 with a combobox with all categories
- in certain cases, from code, I know the desired category, and I can add it to datasource with this code:

Code: Select all

            if (newReport.Dictionary.Variables.Contains("@pCategoryID"))
            {
                newReport.Dictionary.Variables["@pCategoryID"].ValueObject = m_category;
            }

Despite this, the dialog form is always shown, "overwriting" the category ID value...

there's a way to not show the dialog form is the parameter is already set?

using Stimulsoft.Report.Dialogs;

.................

(report.Pages["Form1"] as StiForm).Visible = false;

StiReport newReport = new Stimulsoft.Report.StiReport();
newReport.Load(@"C:\VariablesReport.mrt");
newReport.Dictionary.Synchronize();

if (newReport.DataSources["MyDS"].Parameters.Contains("@pCategory"))
newReport.DataSources["MyDS"].Parameters["@pCategory"].ParameterValue = 2;

newReport.Show(true);

// if(Dictionary.DataSources["MyDS"].Parameters["@pCategory"].ParameterValue) // doesn't work, always empty
// if(MyDS.Parameters["@pCategory"]) // doesn't work, always empty
// if(MyDS.Parameters["@pCategory"].Value) // doesn't work, always empty
// if(MyDS.Parameters["@pCategory"].ParameterValue) // doesn't work, always empty
// if(MyDS.Parameters["@pCategory"].GetParameterValue()) // doesn't work, always empty

//if already set, don't show dialog
if(Dictionary.DataSources["MyDS"].Parameters["@pCategory"].ParameterValue!=null) // doesn't work, always empty
{
MyDS.Connect();

Form1.Visible=false;
}