Creating reports and dashboards | Stimulsoft community forum

Hi There

I'm using Stimulsoft WebDesign in my ASP.NET, to create reports using my custom dictionary during runtime. If works fine most of the time. I've 2 problems

1. When I add sorting, it refuse to save, It doesn't come back to my code behind, where I'm code to save the MRT. It gives me following error with an alert - "Error at Saving, Server Doesn't respond". When I remove the sorting, it comes back to my code behind and I can save it fine. I've attach the event log error below.

2. When I add totals like "Count", when I run the report it give me an error -

"Error generating report : c:\WINDOWS\Temp\qgznqcpb.0.cs(779,18) : error CS0117: 'Reports.Report' does not contain a definition for 'Users_EmploymentType'c:\WINDOWS\Temp\qgznqcpb.0.cs(780,18) : error CS0117: 'Reports.Report' does not contain a definition for 'Users_EmploymentType'c:\WINDOWS\Temp\qgznqcpb.0.cs(781,18) : error CS0117: 'Reports.Report' does not contain a definition for 'Users_EmploymentType'

Thanks
Kishor

Version - Stimulsoft.Report.WebDesign.dll - 2011.3.1200.0


Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/13/2013 9:07:12 PM
Event time (UTC): 6/14/2013 4:07:12 AM
Event ID: 1763b6557a9e4ca0a888e053f4faa02b
Event sequence: 89
Event occurrence: 7
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT/LSGLM-1-130156559665724102
Trust level: Full
Application Virtual Path: /LSGLM
Application Path: C:\inetpub\wwwroot\LSGLM\
Machine name: KAALIEN-LP

Process information:
Process ID: 5096
Process name: w3wp.exe
Account name: IIS APPPOOL\Classic .NET AppPool

Exception information:
Exception type: InvalidCastException
Exception message: Unable to cast object of type 'System.String' to type 'Stimulsoft.Report.Components.StiComponent'.

Request information:
Request URL: http://localhost/XXXX/XXXXXXX/ReportDes ... da3a857293
Request path: /LSGLM/MasterPage/ReportDesigner.aspx
User host address: ::1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\Classic .NET AppPool

Thread information:
Thread ID: 11
Thread account name: IIS APPPOOL\Classic .NET AppPool
Is impersonating: False
Stack trace: at Stimulsoft.Report.Components.StiComponentsCollection.AddRange(StiComponentsCollection components)
at Stimulsoft.Report.Components.StiContainer.GetComponents()
at Stimulsoft.Report.SaveLoad.StiXmlReportSLService.Load(StiReport report, Stream stream)
at Stimulsoft.Report.StiReport.Load(StiReportSLService service, Stream stream)
at Stimulsoft.Report.StiReport.Load(Stream stream)
at Stimulsoft.Report.StiReport.LoadFromString(String reportStr)
at Stimulsoft.Report.Web.StiWebDesigner.LoadReportFromString(String reportString, Boolean packed, Boolean regData)
at Stimulsoft.Report.Web.StiWebDesigner.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hello.

Sorry, we need a little more time to prepare an answer for you.

Thank you.

Do you need any more information? Please let me know.

Hello.

Could you send us a sample project which reproduces the issue?

Thank you.

Here you go. I've attached a zip file with the VS2005 project. If has a default.aspx. Here are the steps

1. Click on "Design New Report" button
2. Create a Standard Report via Wizard.
3. Select "User" Table
4. Select UserID, EmploymentType, FirstName, LastName & HireDate
5. Add Sort on HireDate
6. Add Grouping on EmploymentType
7. Add Total on EmploymentType as Count
8. Click on the Save button

This reproduces item 1 in my problem list. This problem occurs only when I select Sort. If you remove sort. It it save correctly.

For Item 2, Select ReportSample from Browse file and click on Design. Once in design mode, click on Preview and you will get my second problem. Typically I get that at runtime, but you can reproduce this way also. I've created ReportSample.mrt in the similar way as describe in the step above(without adding sort)

Please let me know, what you find.

Thanks
Kishor

Hello.

Sorry, but we can't reproduce your issue on the latest build.
There were many improvements in this direction.
Please, download the latest prerelease build that is already available on our site.

Thank you.