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
- 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
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