I am able to change edit a report by exporting it to a RDL file. WHen we print the report it shows the FIlter notes, I am trying to remove those or hide those.. any suggestions
*This post is locked for comments
Hello ITsavvy,
Please refer my answer on the below link :
https://community.dynamics.com/crm/f/117/p/187166/676863#676863
Regards,
Pradip
Hi,
Just download BIDS for Visual Studio 2012, you don't have to have Visual Studio 2012 installed:
Yes this is pn-premise.. and I am using VS2015 which apparently isnt compatible
The error might be caused by an incompatible version of Visual Studio and/or BIDS. I'm running VS 2012 with BIDS (SSDTBI_VS2012_x86_ENU).
Take a look at these posts:
https://community.dynamics.com/crm/f/117/t/187166
https://community.dynamics.com/crm/f/117/t/200795
Also make sure that the CRM Report Authoring Extensions are installed.
Is this on-premises or CRM Online?
I am getting close. Had to download a few more things and was able to edit the view.
All I did was delete the @CRM filter field saved it, and now getting an error loading it back into CRM
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'schemas.microsoft.com/.../reportdefinition&; which cannot be upgraded.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorCode>-2147188072</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'schemas.microsoft.com/.../reportdefinition&; which cannot be upgraded.</Message>
<Timestamp>2017-01-17T21:18:32.0971224Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
Make sure your VS project is a "Report Server Project". To create a new one in VS, click File -> New -> Project. Select "Report Server Project" and click OK. Then you should see a Reports folder in the Solution Explorer window.
Thanks Gary... I am brand new to VS. I can find the solution Explorer, but no buttons that say report.
It looks like you're opening the RDL file directly. Instead, create a new Report Server project in Visual Studio. In the Visual Studio's Solution Explorer window, right-click Reports and select Add -> Existing Item. Browse to the RDL file and click Add.
Now you can edit the report in a visual environment.
Thanks Gary, where would I set it to Hide.. not sure what to delete as there is alot of code there
FilterText.Value) OrElse (Parameters!CRM_FilterText.Value.Trim().Length = 0)</Hidden></Visibility><ReportItems><Textbox Name="txtFilterSummary"><CanGrow>true</CanGrow><Width>10in</Width><Height>0.25in</Height><Left>0.0in</Left><Top>0.0in</Top><Value>="Filter Summary"</Value><Style><FontFamily>Tahoma</FontFamily><FontSize>12pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>11pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign></Style></Textbox><Textbox Name="txtFilterSummaryValue"><CanGrow>true</CanGrow><Width>10.5in</Width><Height>0.25in</Height><Left>0.0in</Left><Top>0.25in</Top><Value>=Parameters!CRM_FilterText.Value</Value><Style><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>=Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureName(Parameters!CRM_UILanguageId.Value)</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>20pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign></Style><Visibility><Hidden>true</Hidden><ToggleItem>txtFilterSummary</ToggleItem></Visibility></Textbox></ReportItems></Rectangle><Table Name="Table0"><DataSetName>DSMain</DataSetName><DataElementOutput>Output</DataElementOutput><NoRows>="No Data"</NoRows><Left>0.052in</Left><Height>5.25in</Height><Top>1.25in</Top><Style><TextAlign>Left</TextAlign></Style><TableColumns><TableColumn><Width>0.521in</Width></TableColumn><TableColumn><Width>1.042in</Width><Visibility><Hidden>=(Globals!RenderFormat.
When you open the RDL file in Visual Studio, look for a parameter field named "@CRM_FilterText", having an expression like "=Parameters!CRM_FilterText.Value", at the top of the report. This is intended to print the run-time filter settings at the beginning of the report.
To remove it, delete the field from the report, or set the text box Visibility property to "Hide".
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (