Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sbianco

    Reports with Null fields

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

    Reports with Null fields

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

    Another...Date in Range Quest.

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

    Another...Date in Range Quest.

    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} =...
  5. sbianco

    Another...Date in Range Quest.

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

Part and Inventory Search

Back
Top