The tips below come from the Flexible Solutions GP Reports Viewer newsletter. GP Reports Viewer is an add-on for Dynamics GP that allows running Crystal and SSRS reports directly from GP.
- Adding watermarks to Crystal Reports
- Alternating shading for lines in Crystal Reports
- Checkboxes in Crystal Reports
- Coding for specific dates in Crystal Reports
- Crystal Reports book recommendation
- Crystal Reports service packs and versions
- Dynamically change decimal places in Crystal Reports
- How to get a definition of your Crystal report
- How to get next Monday’s date in Crystal Reports
- How to get rid of the blank page at the end of a Crystal report
- Renaming tables in Crystal Reports
- Running Totals in Crystal Reports
- Selective Highlighting in Crystal Reports
- Suppressing blank lines in Crystal Reports
Victoria
It’s me again looking for help. I am trying to format my report to eliminate blanks from suppressed sub reports. I have five detail sections and I always want the first and the last section to show in their places. The three middle sections I want to suppress (while still running the variables). I have done this with suppressing the blank reports. This leaves a gap where the report would of been. I have used underlay following button but they underlay whether they are blank or not. I haven’t been able to find a way to get them to underlay only when blank. Any ideas?
Patrick
Hi Patrick,
Have you tried supressing the whole section (from the Section Expert) based on a formula?
-Victoria
I can suppress the content but it leaves a blank space in the report for each subreport that I suppress. That is why I want to underlay the reports when they are empty so that I don’t end up with one line….several inches of blank… the last line. The underlay has a formula box but I can’t seem to get to work only when there is no data in the subreport.
Patrick,
If each subreport is in a separate section of the report, can you go to the Section Expert and choose Suppress Blank Section?
-Victoria
I have the section expert suppress blank clicked and it leaves a blank space on the report where the subreport would have been. As this report is many pages long and each item reported against can have any and or all the reports filled or empty. I need away to control just how much blank space is showing and that is why I want to underlay blank reports so that they appear to not be there when they are not needed. If I am being dense let me know but It seems it should work. Also, I have variables in each subreport that need to work for calculations no matter if the data is blank so I have to be careful on how completely I suppress the reports.
Patrick,
Underlay is typically used to make something shown on top of something else, like for a watermark, so I am not sure that is what you want. Maybe it will work, but I have never used it that way and am not sure how to help you with that. You might want to try a Crystal Reports forum to see if you can get some other opinions or help for using Underlay.
Suppress Blank Section should work – I just tested it with a report I have and it works perfectly. However, you must also suppress the actual subreport field, that’s the only way the section will be considered blank. I don’t think this will be an issue with the variables on the subreport – I believe the suppression is simply on the printing, not the calculations.
Another option I am fond of is making the subreport field tiny in height and selecting ‘Can Grow’ for it – that way you can put it anywhere you want and it takes a tiny amount of space if blank, but will grow if needed. You will still need a suppress formula on the subreport field itself for this option to work.
-Victoria
I think the can grow will do what I need. Thanks again for your help
Hi victoria,
Can you help me how to insert my customized crystal report in GP dynamics 10.0?
I’ve downloaded and installed a GP report viewer, but I don’t have any idea how to use it.
I just wanted to use my customized report in GP dynamics 10.0
Thanks a lot!
- Rhon
Hi Rhon,
Thanks for your interest in GP Reports Viewer. There is a User Guide included in the GP Reports Viewer installation (it will install into the GP directory) that will walk you through the steps of setting up and using GP Reports Viewer. However, if you are looking to try GP Reports Viewer with your live GP company, you would need to get trial registration keys, because the download will only work with the Fabrikam company without registration keys. To request trial registration keys, please email a screenshot of your About Microsoft Dynamics GP window to sales@flex-solutions.com. There are also some demo videos that may help: http://www.GPReportsViewer.com/demos.html.
-Victoria
Hello Ms Victoria,
How To Print Multiple copy (Customer’s Copy,Office ‘s Copy) in the Same A4 page for a Sale Invoice by Crystal Report
Subhas,
Are you using Dynamics GP?
-Victoria
Hi Victoria,
My customers have been using GP Report Viewer with GP 2010 to view Crystal Reports. Today they have been getting the following error message – Database connector error:’[Database Vendor Code: 1105]‘
How do I resolve this?
Hi Victoria,
I have another question: We are planning on applying GP2010 Service Pack 2 for one of our customers who are also using GP Report Viewer. Is GP Report Viewer compatible with GP2010 SP2 and above?
Thanks.
Saras
Saras,
GP Reports Viewer is compatible with GP 2010 SP2 (also called R2), however, you must be on build 55 or higher of GP Reports Viewer. If you need additional help with GP Reports Viewer, please submit a ticket on the GP Reports Viewer Support Center.
-Victoria
Hi Saras,
Error 1105 is a SQL Server error indicating the tempdb is full. Here is a link to a Microsoft support article about this: http://support.microsoft.com/kb/199364. If you need additional help with GP Reports Viewer, please submit a ticket on the GP Reports Viewer Support Center.
-Victoria
Hi Vic
I’m using CR V.10
I’ve created a customer Statement report related to(the Sales Person ID) which is required to be enter by the user.
But I need to print a separate statement for each customer in the report.. can you help me please? where I’m just a beginner in CR..I read something about page break after/before but I didn’t know how/where to use..!
I really need your help.
Yassir,
In the Section Expert you should be able to select a checkbox for ‘new page after’ on the group footer for the customer. It’s been many years since I have used Crystal Reports version 10, so I am not 100% sure of the exact steps to give you, as some of this may have changed…
-Victoria
Hello Ms Victoria,
I am using Crystal Reports version: 11.5.12.1838 with Dynamics GP. I have set up a sales report using the following tables: IV00101, SOP10100, SOP10106, SOP10200, and SOP60300. On the report I have our product number and our product description..I also have the customer product number and customer product name. The problem I can’t figure out is when in Dynamics an order is entered if there is no customer product number or name that line is not showing up in the Crystal Reports.
The tables are linked as such:
SOP10200.ITEMNMBR → IV00101.ITEMNMBR
SOP10200.SOPNUMBE → SOP10100.SOPNUMBE
SOP10200.SOPNUMBE → SOP10106.SOPNUMBE
SOP10200.ITEMNMBR → SOP60300.ITEMNMBR
SOP10100.CUSTNMBR→ SOP60300.CUSTNMBR
I would really appreciate any help you can give me with this.
Thank you,
Cindy W
Hi Cindy,
It’s a bit tough to diagnose without looking at the report, but I would suspect this is being caused by the type of link you have set up between one or both of the following:
SOP10200.ITEMNMBR → SOP60300.ITEMNMBR
SOP10100.CUSTNMBR → SOP60300.CUSTNMBR
These should both be Left Outer Joins.
-Victoria