884
We have a relatively simple report setup in SSRS ,Report has worked fine but It takes (a) longer time to open.Like, 10-15 minutes to generate the report
I can set multiple sub report in Main Report as per our requirement.
Please help
*This post is locked for comments
Is your link type = outer necessary to get your requirements.
Try like this:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="opportunity" >
<attribute name="name" />
<attribute name="opportunityid" />
<attribute name="customerid" />
<attribute name="estimatedvalue" />
<attribute name="estimatedclosedate" />
<attribute name="statuscode" />
<attribute name="new_mostrecentreview" />
<order attribute="name" descending="false" />
<filter type="and">
<condition attribute="statecode" operator="in">
<value>0</value>
<value>1</value>
</condition>
<condition attribute="opportunityid" operator="eq" value="@Opportunity" />
</filter>
<link-entity name="new_review" from="new_reviewid" to="new_mostrecentreview" link-type="outer" alias="MRR">
<attribute name="new_reviewid" />
<attribute name="new_score" />
<attribute name="new_reviewdate" />
</link-entity>
</entity>
</fetch>
Thanks David
CRM Online
Code here :-
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="opportunity" >
<attribute name="name" />
<attribute name="opportunityid" />
<attribute name="customerid" />
<attribute name="estimatedvalue" />
<attribute name="estimatedclosedate" />
<attribute name="statuscode" />
<attribute name="new_mostrecentreview" />
<order attribute="name" descending="false" />
<filter type="and">
<condition attribute="statecode" operator="in">
<value>0</value>
<value>1</value>
</condition>
</filter>
<filter type="and">
<condition attribute="opportunityid" operator="eq" value="@Opportunity" />
</filter>
<link-entity name="new_review" from="new_reviewid" to="new_mostrecentreview" link-type="outer" alias="MRR">
<attribute name="new_reviewid" />
<attribute name="new_score" />
<attribute name="new_reviewdate" />
</link-entity>
</entity>
</fetch>
Hello;
The other thing that can be done is to setup these to pre-generate so you load from last loaded report. Have it as a scheduled report; this would stop this long load time; it just depends on how up to date you need the data.
Is this CRM Online or OnPremise ? If it's OnPremise then I'd check the SQL query and see if that can be optimised by adding any indexes
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (