A good percentage of my day is spent writing reports. The report formats could be SQL Server Reporting Services (SSRS), Crystal Reports, M2M VFP reports, or ODBC Excel Spreadsheets. The latter three methods usually involve T-SQL, which I write by hand using TOAD for SQL Server or the SQL Server Management Studio (SSMS). In the past, I have searched the web for report design information, and didn’t find much. Anyway, each day this week, I will offer guidelines and suggestions I’ve learned over the years because I know many of you write reports as I do. For the most part, these will be general and not pertain to any specific report medium. Also, keep in mind that these are simply my guidelines for report creation. Your mileage may vary.
Day One – Requesting Reports
Day Two – Standardize Your Layouts
Day Three – Know What Your User Wants and Your Target Number(s)
Day Four – Exporting Reports
Day Five – Report Approval and Deployment
[…] Reporting Guidelines: Standardize Your Layouts Basic Reporting Guidelines – Week of Articles […]
[…] Reporting Guidelines: Standardize Your Layouts This article is day two in a week of reporting articles. […]
[…] Report Guidelines: Exporting Reports This article is day four in a week of reporting articles. […]
[…] Report Guidelines: Know What Your User Wants and Your Target Number(s) This article is day three in a week of reporting articles. […]
[…] Report Guidelines: Report Approval and Deployment This article is day five in a week of reporting articles. […]
Creating a customer A/R statement in Crystal Reports.
I am tryting to create a customer A/R statement in Crystal Reports. So, I am doing an outer join between fcinvoice.glcshi and fcinvoice.armast I am enforcing the join. There are unpaid invoices in Armast that do not have a matching payment in glcshi. When I try to subtract a payment that does not exist from an invoice amount that does exist, I get a null. How do I structure the formula to show the full amount of the invoice being due?
I also need to only select records where fnnumber.glchsi is null. How do I select that?