Archive for November 2005
29
Crystal Reports: ElapsedTime() Function
1 Comment · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Converts a number of seconds into a string in the format of days.hours:minutes:seconds.
24
Crystal Reports: Named-Date-Range Parameters
9 Comments · Posted by Craig Buchanan in Crystal Reports
Often it’s useful to be able to use date ranges that are relative to the date the report was run, like ‘Month to Date’, when running a report. While Crystal Reports’ parameters do not possess this level of flexibility, it is fairly simple to approximate this capability. This approach uses two parameters and Crystal Reports’ date ranges to do so.
24
Crystal Reports: Optional-Multi-Select Parameters
24 Comments · Posted by Craig Buchanan in Crystal Reports
Most report designers are familiar with the parameter’s ‘Allow Multiple Values’ option. When enabled, this option allows a report’s user to select one or more values for a parameter at runtime. The individual running the report could select one or more countries, for example. Should the individual want to select all countries, he or she would need to add each country individually when the prompt is presented. If there are a lot of countries, this could be a time-consuming task. Fortunately, there is a better way.
23
Crystal Report: Include Terms and Conditions on a Form Letter
No comments · Posted by Craig Buchanan in Crystal Reports
In this sample, we will create a report that generates a form letter to each customer, with terms and conditions on the back side (represented as Cogniza’s logo). Moreover, the page numbering will only count the front of each page.
20
Oracle: Object Dependencies
No comments · Posted by Craig Buchanan in Oracle, Programming, SQL
This article demonstrates a SQL query that lists Oracle views and functions and the functions and tables that are contained in them.
Oracle · PL/SQL · Programming · SQL
7
Crystal Reports: ShellSort() Function
No comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, Functions, Programming
Sort an array of numbers using the Shell sort algorythm. This sorting algorythm will quickly sort arrays in Crystal Reports.
Business Objects · Crystal Reports · Functions · Programming
7
Crystal Reports: Using SQL Expression Fields
20 Comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports
This document discusses the syntax requirements for SQL Expression fields.
3
Considerations For Reporting Against Remedy ARS Based Applications
6 Comments · Posted by Craig Buchanan in Crystal Reports, Remedy ARS
Applications built with the Remedy® Action Request System™ (ARS) client/server workflow engine are wonderful online transaction processing (OLTP) environments. When it comes to getting meaningful information back out of ARS environments, the users and application designers get a bit befuddled on what is available to them; what’s right for their organization.
Access · Crystal Reports · Date/Time · Remedy ARS · Timezone
