Solved

SRS report in Dynamics CRM only outputs partial report

Posted on 2008-10-06
4
517 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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