Solved

SRS report in Dynamics CRM only outputs partial report

Posted on 2008-10-06
4
509 Views
Last Modified: 2013-11-24
We have created a quoting solution for MS Dynamics CRM that allows us to create quotes for our customers.  At the end of the process, users execute an SRS report from within CRM that should pull the customers name, contact info, salesperson info, products, and our boilerplate and create a report that salespeople can then provide to the customer.

We had this report working previously.  It consisted of the main report and 3 sub-reports.  The three sub-reports consist of the cover page, line items, and finally the boilerplate.  When we are in CRM and we execute the report, the preview prints fine and we are able to see every single page that should be in the report.

The problem is when we attempt to output the report.  If we attempt to print or save the report/quote to a PDF, only the cover page and line items are printed., the boilerplate is cut off.  It is previewing just fine on from within CRM, but it is cut off when printed or output.

Any help in troubleshooting this issue would be greatly appreciated.  If someone would like copies of the SRS report itself, please let me know.

Joe
0
Comment
Question by:juselding
  • 3
4 Comments
 

Author Comment

by:juselding
ID: 22670129
Here is some additional information that might help.  I have the main report in SRS and the 3 sub reports.  From within SRS I can print all pages in the report via an HTML export.  I cannot get the last page of the report to output via my printer or my to a PDF.  

Anyone have any suggestions?

Joe
0
 
LVL 4

Accepted Solution

by:
gregowens earned 500 total points
ID: 22676457
Is there a chance that it is a slightly-overlapping section/table that is encroaching on the boilerplate subreport? I'm sure I've encountered this before and it only becomes a problem when the PDF rendering doesn't deal with layering as you might expect. Scrutinise all items around that come near the boilerplate - perhaps remove some items temporarily (or on a copy that you are happy to hack about on) to try and isolate the problem element.
0
 

Author Closing Comment

by:juselding
ID: 31503500
Thank you so much for the help.  I went into the report and found out that the page margins were not properly set.  After that I made changes to all of the report files and re-uploaded.  That seems to have done the trick!
0
 

Author Comment

by:juselding
ID: 22681929
It appears that the body prefs for each sub-report were not set.  In addition, after setting those correctly I realigned the data and now things seem to be pretty happy.  Thanks so much for your help.

Joe
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now