Mark Minasi's Tech Forum
Sign up Calendar Latest Topics
 
 
 


Reply
  Author   Comment  
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 252
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 on 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
spam spam bacon spam

Avatar / Picture

New Friend (or an Old Friend who Built a New Account)
Registered:
Posts: 36
Reply with quote  #2 
MUST.DIG.OUT.MY.WORK NOTES.FROM.THE"Point-of-share"PLACE.

Remember that place?
The place that was getting a "point-of-share" server because the owner wanted a calendar?

Your story reminds me of them.
(ahhh......hell..... it reminds me of the last 52,3869.247 places I've been....)

One day, I thought of writing 30 separate, small "memories"... a collection of 30 short writings  that described the gawd awful things I "encountered" at that place... I even went so far as to write down a list of 30 individual "oh-my-frikkin-gawd" things I could use as fodder.

Some of them need pictures, though.  I mean, you REALLY need pictures to do justice to their network... their entire network consisted of a circa 1994 NetGear 24 port switch sitting atop a typical 8 gal garbage can -- of course, the garbage can was right side up, and positioned right behind the door between the office and the warehouse.

Every time someone opened the door (often), they had to stop the door from hitting the can.  If it did hit the can, the switch would fall in the garbage can and *maybe* we'd have a network outage...  of course, you could never tell from looking at the switch as the port lights NO LONGER WORKED.  So there was no indication that anything was going on inside that switch (except, I'm sure, a lot of cussing and swearing by the store-and-foward gremlins)   


Glad to hear you dug smart enough to find the problem.
But then, you're smart like that.


~akthy

__________________
If at first you don't succeed, destroy all evidence that you tried.

0
Donato

New Friend (or an Old Friend who Built a New Account)
Registered:
Posts: 67
Reply with quote  #3 
I know what a page break is but I wish I knew what a matrix was.
0
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 252
Reply with quote  #4 
Sorry about that.  I should explain.   Many companies have Microsoft CRM on premise deployed in their environments. 

For environments like these SQL server and SQL Reporting Server are used for the database back end and the reporting engine.

There is a free download for creating T-SQL and FETCHXML coded reports in a SQL Server Reporting Service environment.  

Aside from reports that are similar to spread sheet reports you can have a matrix.  The official description of which by Wikipedia is : 
In SSRS, Matrix is generally used for cross tab reports. It display’s the report data in rows and columns, and allows us to organize the data in aggregated groups. Generally Matrix is used when there is no fixed columns in the report. It also allows to add pivot like features to our SSRS reports.

The point I was making was this.   You can get the form to look ok in one single record.
But when you have many records and your are trying to print the form, you have to know how to get the formatting correct.    It's very easy to mess up the matrix and get it wrong in the long run.    I'm sure James Summerlin will chime in on this and discourse on length regarding the use of a Matrix in an SSRS report.   The fact is that SSRS and SSIS folks are a special breed in their own right.   We will see if Power BI and FLOW can help in this space, but for now, there is plenty of work out there for Reporting and ETL.   In Dynamics 365 for Sales and customer service, there is an extensive use of reports, charts and Dashboards.    These reports act like stand alone programs that normally have to be modified on a regular basis.   So you might say that skill sets have to expand for both on premise and cloud environments.   





__________________
Curt Spanburgh
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.