Solved

SRS report in Dynamics CRM only outputs partial report

Posted on 2008-10-06
4
511 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

914 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

16 Experts available now in Live!

Get 1:1 Help Now