Rob Diamant
- Total activity 43
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 18
Articles
Recent activity by Rob Diamant-
Keep Group Sections Together
Many times when having multiple sections in a Group Header or Footer, the page breaks between two sections. To keep all of the Header or Footer Sections together, go to the Section Expert, select p...
-
Determining EZ Writer Table and Column Widths
EZ Writer (HTML) tables are measured in Pixels. The standard conversion is 96 pixels per inch. Here is a handy conversion table. However, keep in mind that MS Word will shrink the table to fit with...
-
Finding First Monday of the Month
Use the following formula to find the first Monday of the following month (based on current date): DateVar varDate := cDate(DateAdd("M", 1, Today));varDate := date(year(varDate), month(varDate),...
-
Improving Performance When Using a SQL Command Data Source
When using SQL Commands for a data source, always supply default values to the command parameters. These are used when the Crystal Engine (and Momentus Enterprise) loads the report and verifies the...
-
Using AND and OR in WHERE SQL Clauses
This article contains information for On-Premise accounts. If your account is hosted in the cloud, this article is not applicable. When writing the WHERE clause of a SQL statement, it is imp...
-
Replace an Existing Report Field in Design Mode
Instead of having to delete then add a new field and then having to reformat the new object, you can do the following: 1. From the Field Explorer, select the new field. 2. On the keyboard, use Sh...
-
Change Links on a Subreport
To changing the link on a subreport, follow the below steps: Select the Subreport, right-click, and select Change Subreport Links. In the right pane select the old field being passed. Click th...
-
Pass a Shared Variable Between Subreports
When having two subreport side-by-side, if the Shared Value is not being passed from the one on the left to the one on the right, follow the below process: When passing shared variables between sub...
-
Crystal Formula For Last Day of the Month
The following formula will return the last day of any month, taking into account the end of year or leap years: DateAdd("m", 1, Date(Year(Today), Month(Today), 1)) - 1
-
Dynamic Grouping with Crystal Reports
Rather than maintaining multiple reports which display the same data but are grouped by different criteria, you can allow users to select their own groupings for a single report. To allow a user t...