CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2001
    Posts
    254

    Conditional Dataenvironment

    i'm using dtaenvironment to create a report (datareport) if the field is null i insert this code into dataenvironment "isnull(fldname,0)" this works fine, my problem is how can i use " IF " statement in dataenvironment

    thank you
    cyrus

  2. #2
    Join Date
    Apr 2004
    Posts
    95

    Re: Conditional Dataenvironment

    Can you elaborate further on what you mean, please?

    Or, provide a vague example so we can understand what you mean.

  3. #3
    Join Date
    Jul 2005
    Location
    Kisumu, KENYA. EAST AFRICA
    Posts
    88

    Re: Conditional Dataenvironment

    Someone once gave me a hint here that if you want success in creating reports, create them in the folder that your application will be installing to on the FINAL computer. So if, say, you will be installing in c:\Program Files\Example1, then create that folder and move your program and the database into it.

    Finaly, set your dataenvironment to read the database inside this folder.

    All report problems will be history.

  4. #4
    Join Date
    Sep 2001
    Posts
    254

    Re: Conditional Dataenvironment

    Select A.*, Isnull(fldname,0), if(fldname=x,1,2) From Tblename

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured