?
Solved

SRS report in Dynamics CRM only outputs partial report

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

590 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