Forums Home / ActiveReports / General Discussion
Posted by: andy.beaulieu on 23 January 2019, 11:20 am EST
andy.beaulieu
Posted 23 January 2019, 11:20 am EST
We noticed that, if we upload an RDL report (from SSRS) to ActiveReports Server with a 2016 schema:
http://schemas.microsoft.com/sqlserver/reporting/[b]2016[/b]/01/reportdefinition
… and then, we edit the report and save it, it downgrades to a 2005 schema:
http://schemas.microsoft.com/sqlserver/reporting/[b]2005[/b]/01/reportdefinition
is this “normal?” Is 2005 the latest supported schema for RDLX?
Thanks!
mohitg
Posted 23 January 2019, 5:54 pm EST
Hello Andy,
The latest hotfix of AR12 has now supported RDL 2016 schema. You can download the same from the following link:
http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports-v12.2.15826.0.msi
Thanks.
andy.beaulieu
Posted 24 January 2019, 5:34 am EST
Is there a separate hotfix for ActiveReports Server?
We are using AR Server 12.2.9258.0.
mohitg
Posted 24 January 2019, 2:34 pm EST
Andy,
Yes, we have the separate hotfix for the ARS. You can download the same from the following link:
http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports12Server-v12.2.9292.0.exe
Hope it helps.
Thanks.
sanapathi
Posted 14 April 2020, 8:27 am EST
Hi Does this happen in AR14 as well? I have trial version now trying to see how can we load some legacy ssrs reports. When i inspect the report.ToRdlString(), I see 2005 definition. And when I run the report, i get the following exception.
SharedDataSourceLoadException: Missing requried XML element.
mohitg
Posted 15 April 2020, 4:06 am EST
Hello,
AR report still contains the 2005 definition but it supports SSRS report with the 2016 definition.
If you are getting issue while loading the SSRS report in the AR then could you please share the SSRS report with us so that we can narrow down the issue at our end.
Thanks,
Mohit
mohitg
Posted 16 April 2020, 4:25 am EST
Hello,
I have checked several reports in the attached folder. All reports opened successfully at my end with AR14 Designer.
Could you please share the exact report which you are unable to open at your end.
You can refer to the following link to know about the parameter:
https://www.grapecity.com/activereports/docs/v14/online/add-a-parameter.html
Thanks,
Mohit
sanapathi
Posted 20 April 2020, 12:46 am EST
Thank you Mohit for checking. For security reasons I could not upload actual reports i was told. And when you were able to open reports, how could you load with no datasource? Is it just the templates opening in AR14 did you mean?
Also, to surpass the parameters issue, i hardcoded parameter values in ssrs rdl itself, and was able to load a simple report page. But one of the pages is giving the following error. What are my pointers when errors like this happen? It says an anonymous call in Tablix membercell…but how do I trace it? Thanks!
GrapeCity.ActiveReports.ReportException
HResult=0x80131600
Message=An unexpected error occurred. Additional information: ‘Object reference not set to an instance of an object.’
Source=GrapeCity.ActiveReports
StackTrace:
at This exception was originally thrown at this call stack:
GrapeCity.ActiveReports.Layout.TablixImpl.LayoutRowMember.AnonymousMethod__35_6(GrapeCity.ActiveReports.Extensibility.Rendering.Components.Tablix.ITablixCell)
System.Linq.Enumerable.All(System.Collections.Generic.IEnumerable, System.Func<TSource, bool>)
GrapeCity.ActiveReports.Layout.TablixImpl.LayoutRowMember(GrapeCity.ActiveReports.Extensibility.Rendering.Components.Tablix.ITablixMember, bool, bool)
GrapeCity.ActiveReports.Layout.TablixImpl.LayoutMemberGroups.AnonymousMethod__5(GrapeCity.ActiveReports.Extensibility.Rendering.Components.Tablix.ITablixMember)
GrapeCity.ActiveReports.LazyList.Select<T, TR>(GrapeCity.ActiveReports.LazyList, System.Func<T, TR>)
GrapeCity.ActiveReports.Layout.TablixImpl.LayoutMemberGroups(System.Collections.Generic.IEnumerable<GrapeCity.ActiveReports.Extensibility.Rendering.Components.Tablix.ITablixMember>, bool)
GrapeCity.ActiveReports.LazyList.ToLazyList(System.Collections.Generic.IEnumerator)
GrapeCity.ActiveReports.Layout.TablixImpl.LayoutRowMembers(System.Collections.Generic.IEnumerable<GrapeCity.ActiveReports.Extensibility.Rendering.Components.Tablix.ITablixMember>, bool)
GrapeCity.ActiveReports.Layout.TablixImpl.BuildLayout()
GrapeCity.ActiveReports.Layout.ReportItemImpl.SelectLayout(GrapeCity.ActiveReports.Layout.LayoutScope, GrapeCity.ActiveReports.Extensibility.Rendering.Components.IReportItem, GrapeCity.ActiveReports.Layout.Size)
…
[Call Stack Truncated]
Inner Exception 1:
NullReferenceException: Object reference not set to an instance of an object.
mohitg
Posted 21 April 2020, 12:02 am EST
Hello,
Yes, I mean template open in AR14. I tried to preview the reports but there is no data source available.
It is very hard to narrow down the issue with stack trace. You can share the dummy template with dummy data so that I can look into the issue.
You can share the report at the following location:
https://www.dropbox.com/request/pFA0F5us00EgMOzRzWv7
Thanks,
Mohit
sanapathi
Posted 21 April 2020, 1:30 am EST
How do I open RDL in AR14 as a template?
mohitg
Posted 21 April 2020, 6:59 pm EST
Hello,
Sorry for the confusion, I meant that open RDL report directly in AR14 Designer. Could you please confirm the following things:
1: Are you facing any issue while RDL Report opening in AR14 Designer?
2: Are you facing any issue with database connectivity at your end?
3: Are you facing any issue while previewing the report?
If yes, is it reproducible with all reports or with a specific report?
Thanks,
Mohit
Thanks,
Mohit
sanapathi
Posted 23 April 2020, 8:37 am EST
Hi Mohit,
I had a call with Evan Warren and showed him the issue I was facing.
I was trying to load the ssrs .rdl into a page report in code.
When i try to use pdfRenderingExtension, i get all sorts of errors.
To make sure database/parameters were not an issue, I hardcoded parameter values and made the dataset an embedded one (verified with a simple subreport and worked fine).
Here is the case# if that helps: https://supportone.componentone.com/home/casedetail/432033
You said you were able to load the reports fine in AR designer.
I was not able to load as mentioned in that support ticket.
Can you please send me the same if you can load them in designer?
Thanks,
Madhuri
