Creating reports and dashboards | Stimulsoft community forum

Hello all

please provide me a sample for passing a parameter of type datetime to the stimulsoft report, i am using the query in the .mrt file itself.

I am able to pass variable as parameter to .mrt file, it is working for all data type exept datetime.


Thanks in advanced

Hello,

You can use the following code: Thank you.

Hello

Thank you Aleksey for you reply.

I want query that make me able to pass datetime variable from stimulsoft to sqlserver.


Thank you.

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

ok thank you

I use this's function from asp to report stimulsoft

private void DisplayReport()
{
if (Request.QueryString["ReportName"] != null)
{
reportName = Convert.ToString(Request.QueryString["ReportName"]);

}
else
{
return;
}



lblSelectedreport.Text = reportName;


Session["Reportdt"] = (DataTable)dt;

string reportPath = Server.MapPath(@"./Reports/") + reportName;

Session["ReportPath"] = reportPath;

StiReport report = new StiReport();

report.Load(Server.MapPath(@"./Reports/") + reportName);
report.Dictionary.Databases.Clear();

string connectionString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString.ToString();
report.Dictionary.Databases.Add(new StiSqlDatabase("Connection", connectionString));

((StiText)report.Pages["Page1"].GetComponents()["Variable1"]).Text.Value = txtStartdate.Text;
((StiText)report.Pages["Page1"].GetComponents()["Variable2"]).Text.Value = txtExpirydate.Text;

report.Compile();

StiWebViewer1.Report = report;
}


I want to use the query between (Variable1 and Variable2) in the stimulsoft
Thanks again

Hello,

If we understood your question correctly, you can create 2 variables in a report, which are used in the query And pass values of these variables from the code Thank you.

Thank you very much

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

Hello Aleksey
I am pleased and honored your interlocutor again

I ask forgiveness and a big thanks to you from me
Can send an example to display the data between two dates, because I tried to Carry out the code I can not
I've got two dates I do first of the program and then I send dates to the report and there is data is displayed depending on the dates sent
Please send example fully
Wait for your answer my teacher Mr.

Note
I am use a language asp and charp
thank you

Hello,

When you use the DateTime type in the query with the Between construction, the date should be in the 'YYYYMMDD' format. Otherwise, you need to write a converter that will convert the date to your desired format.

Thank you.