I'm sorry but I dont quite understand. Can you give some more details
case 1
if I want a report when fld1 has data but fld2 and fld3 are empty what does the "IF" formula for fld1 do if it's not empty and how is it different from the formula from fld2/3 which are empty
if (not IsNull...
If a single database has 3 fields (table.fld1, table.fld2, table.fld3). Each field can contain data or be empty (null). How do I generate a report (formula) based on whether the field contains data or is empty.
Meaning, how do I generate a CR on fld1 if, fld2 and fld3 are empty. On fld1 and...
Thanks k
I wish I could say I understood your last reply but I regret I don't. I understand about changing the DB and I'm familiar with SQL statements but what I don't understand is your reference to
"CDate({table.field})
and use a date type parameter to compare against"
Is...
I'd like to thank You for your reply it sovled my problem, I think, however I'd like to give some observations
The procedure I followed was to drag and drop the table.datefield on to the crystalreport1.rpt, create a
DateRangeParm and create a formula for the datefield:
{table.datefield} =...
- MS-Access (DB) table fields:
table.recordId,table.date1,table.name, payperiod, ...
- Using: Visual Studio .Net - C# (OLE DB)
- table.date1 is a "range value"
1. What formula (code) do I use to get only the dates (DB records) in my report for the range I specify in the Crystal...
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.