| Take the Pain out of Customizing SOP Reports
How GP Reports Viewer can help replace SOP reports |
|
Want to change the formatting of your Dynamics GP SOP reports? Don't want to have to make the same change on 10 reports? Don't like working with GP's Report Writer?
With GP Reports Viewer you can replace any SOP reports with Crystal and/or SSRS reports. Do this for as few or as many reports as you want. Use the included sample reports and simply change the logo and address on them or create your own reports - it's up to you.
The best part? Your users won't even be able to tell the difference, they can keep printing SOP reports in GP like they have always done. They'll simply have much nicer looking reports. |
Dynamics GP Phone Numbers in Crystal
How to format a string with a custom formula |
|
Want to add a phone number from Dynamics GP to a report, but when you add the field you get something that looks like "55555512121234"? Would you rather have this display as "(555) 555-1212 x1234"?
You can create a custom formula in Crystal Reports to do this using the following syntax:
if {RM00101.PHONE1}="" then "" else
"(" + Left({RM00101.PHONE1},3) + ") " +
Mid ({RM00101.PHONE1},4,3) + "-" +
Mid ({RM00101.PHONE1},7,4) +
if Right({RM00101.PHONE1},4) = "0000"
then "" else
" x" + Right({RM00101.PHONE1},4)
This will return a blank if there is no phone number and will only show the extension if it's not all zeros. |
Dynamics GP Phone Numbers in SSRS
How to format a string with regular expressions
|
 Want to add a phone number from Dynamics GP to a report, but using SSRS? You can do something similar to the Crystal tip above using a string manipulation formula in SSRS but try it instead with Regular Expressions! Yes they are scary at first, but once you get the hang of them they are actually quite powerful. Here is how to achieve the same effect in SSRS:
=Replace(System.Text.RegularExpressions.Regex.Replace
(Fields!PHONE1.Value, "(\d{3})(\d{3})(\d{4})(\d{4})",
"($1) $2-$3 x$4"),"x0000","")
The phone number with extension is formatted first and then the outer replace will hide the extension if it is blank. If there is no phone number there will be no match and therefore this will return a blank. |
