Mark Minasi's Tech Forum
Register Calendar Latest Topics
 
 
 


Reply
  Author   Comment  
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 232
Reply with quote  #1 
Inheriting sins from the original developer of some undocumented SSRS reports is no fun.

Seems the developer created a matrix for a form and put a rectangle at the top of the "Page".
First run of the form ran ok for one record. But in preview and when printing multiple copies from many records, the rectangle showed on the bottom as well as the top.
I looked in the report margins, and all the other places where you would put page breaks and tested them to no avail.

I clicked o
n Details of the Group and at the bottom of the Matrix I right clicked and saw "Row Group".
Aha, Group Properties | Page Break| Between each instance of a Group.
Saved and ran the preview. "Perfect" I guess the original Dev just gave up.
Now that was not a place that I had seen page breaks before. But then reality is often not what you think it is ...... in the Matrix.

__________________
Curt Spanburgh
0
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 232
Reply with quote  #2 
Just a bit of FYI on why getting this right on the report was so important.

If a client has a Microsoft CRM deployment that is either hosted on a VM in a data center or in house it is SQL based in the back end.

SQL based reports using T-SQL can be created with SQL Server Reporting Services tools that can be downloaded for free.   

For different versions of CRM there is a Report Authoring Extension that needs to be installed on the machine where you have SQL tools installed.
This will allow you to create SQL based reports and Fetchxml based reports.
Once you have your RDL file created you can upload it to the CRM reports area and create a new report.    For this client , they have at present a highly customized CRM 2013 deployment.  The report I made changes too, helps them keep services for Elderly and Nursing homes.    A place I hope I never have to be.  

Nevertheless , the report provides functionality somewhat like an application to produce documents that keep the management of thousands of facilities organized by just 15 people.

All of this, for sure is being replaced by Power BI and or Power Apps.   I hope to have some material for posting that will not just show the maintenance of the older systems, but the advancement of the newer systems.


__________________
Curt Spanburgh
0
lady_mcse

Avatar / Picture

New Friend (or an Old Friend who Built a New Account)
Registered:
Posts: 98
Reply with quote  #3 
Highly customized is wonderful.  Until it breaks.  :-) 

Glad you found it, and there's a phrase that comes to mind with respect to Power BI ... "may you live in interesting times." 
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.