Can 11 and/or 2008 evaluate a user's data access user ID online, real time? While using either Crystal version to access a SQL based database can the user ID used to access the data be reflected within a report? I'm not looking for IDs that are stored historically within the database. This is...
This might work -
Create four different variable formulas.
The first is to reset the variable and is placed in the patient header
whileprintingrecords;
datetimevar minstart := CDateTime (2100, 01, 11, 00, 00, 00);
datetimevar maxend := CDateTime (1900, 01, 11, 00, 00, 00);
The second is to...
The following should also work:
right({string.field},((length({string.field})) - (instr({string.field}," "))))
Note that the instr will find the first blank field, not subsequent ones. Also, if the data could possibly be entered with a blank before ACURA, this will be an issue as well.
Here's my last thought - create 12 different formulas for each month and qualify what appears for the formula based upon the month required. For example, if month({posting date field} = 4 then sum({fields used for posting}) else 0
A support person sent me the following message:
"I ran the corrected report that against production data on the host and received the same problem. The class on the top of page 4 had a standby count of 0/2 and all the othere ones that followed it contained the same value which was...
In order to improve response time, I want to limit the amount of data queried from an Oracle database. For example, if I'm querying a table to create a financial statement only reflecting data from period 9, I only want to query the database fields containing that period's data instead of all...
Beth,
Sorry that I'm late to the conversation. I've written and supported Crystal financial statements using Lawson. It does sound like an issue with joins.
Try a left join from GLMASTER to FBDETAIL and a left join from GLMASTER to GLAMOUNTS. Link on the Company, Accounting Unit and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.