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