Creating reports and dashboards | Stimulsoft community forum

I'm a new user with Stimulsoft. We are actually evaluating the product to see if it meets our needs. So far I'm been very impressed with the product.

. With our previous reporting tool SSRS...We would pass in parameters to the report that the report could use. The main purpose was to use the parameters for localization.

Example:

ReportHeader had a text field called customer.

I set the text field to use use Parameter_1.Value as the text that gets displayed in the report. I know there's the localization built within Report Writer, but we really don't want to maintain two lists (one within our product and one for reports.

. Similar with the above question - We not only want to pass in a parameter with text in to be used by the report..but to also pass in a parameter to use for string parsing.

Example:

Some of our customers may have people from several different countries using our product. We fully support localization on all screens. This includes the Date. When a report was created with SSRS that contained a date field we could specify to use a formatting based on an inputted parameter. When the end-user runs the report it is first determined what language and date/time format they were using. This was then passed into the report and datatime field would parse the date based on the inputted parameter.

If you know of a different approach I'm fine with that too.

Hi Mike,

Please see the 'Globalized report' sample application from standard installation.

And there is also some links on how to use parameters in our products:

Here are the links on how to use named and unnamed parameters:
Named parameters:
http://www.stimulsoft.com/livedemos/Rep ... eters.html

Unnamed parameters:
http://www.stimulsoft.com/livedemos/Rep ... ers_2.html

you can pass parameter into the report's datasource as follows:

report["@MyParameter"] = 5;

The same way is to passing a variable value into the report:

report["MyVariable"] = 5;

Thank you.

I figured out how to add a variable to the report.

I still have the question of how to localize dates.

Localizing text is no longer a problem.



When I create a report which has a datefield somewhere on the report. That date field needs to display the correct date for the person running the report. We have customers who have clients all over the world and they want to see when a document was added. So they created a report with the name of the document and the date it was created. If the person creating the report was in London and the report was created on 2/13/2010 5:00pm. Person B runs a report that lists the name of the document and date/time it was created. Person B lives in Austin TX (a time difference of about 10 hours). The date on the report should show 2/13/2010 7am.

Before the report gets run I can calculate the Time Delta. In this case it would be -10 hours.

Is there a way of adjusting the date fields to add the -10 hours to the date/time field so the date/time gets displayed correctly?

I looked at the video you provided. But those video's are for the WindowForms designer...NOT the Web designer.


After getting more into this I have some issues that need to be resolved.

1) Dates. I need to format the dates based on the user running the report. Many reports will be viewed by people in Europe or the US or Canada. Dates are need to be displayed differently for each of the users.

US - 2/15/2010
Europe - 15 Feb 2010.

2) Date/time needs to display the correct data and time for the user running the report. A report is created that displays a date. User A lives in NYC runs the report and sees the data/time as 1/15/2010::4:00pm. User B lives in Austin TX runs the report and should see the date/time as 1/15/2010::1:00pm.

3) I have a report that shows all the users and their location grouped by Location. Is there a way of passing in a parameter or a dialog that allows the user to only view all the users from a specific location. With our current reporting system (SSRS) I can select the location to report on.

Hi Mike,

You can localize all the report at once using the following property from the code of your application before showing i:

Thread.CurrentThread.CurrentCulture = "en-US"

And you also can create dialogue forms in the winforms designer and use the following rules to display these forms to enter report parameters:

Here is requirements on using dialogs inside Web page:

1) StiWebViewer.RederMode must be AjaxWithCache or UseCache.

2) Code of rendering report must be in any other place but not in PageLoad event of the WebPage. You can place this code for example inside the ButtonClick event.

3) Dialogs will work in web only when StartMode property in Dialog Form is set in 'OnStart'

If these three requirements are satisfied, then your report will work with dialogs in Web environment.

Unfortunately web designer does not support adding of forms at the moment, we will add that option to Web Designer later.

Thank you.