?
Solved

SRS report in Dynamics CRM only outputs partial report

Posted on 2008-10-06
4
Medium Priority
?
522 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

777 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