Results 1 to 4 of 4

Thread: [RESOLVED] [2005] Crystal reports and null values

  1. Aug 7th, 2007, 08:43 AM #1
    kadem
    kadem is offline

    Thread Starter
    Member kadem's Avatar
    Join Date
    Nov 2004
    Posts
    50

    Resolved [RESOLVED] [2005] Crystal reports and null values

    I have two related tables in my Access database Student and Advisor, related in advisor_id field.
    The problem is that when I try to print a student report , all field are empty if the advisor_id is null.
    Last edited by kadem; Aug 7th, 2007 at 08:47 AM.
    Reply With Quote Reply With Quote
  2. Aug 7th, 2007, 09:20 AM #2
    bmahler
    bmahler is offline
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Re: [2005] Crystal reports and null values

    you need to check you links in your report. Most likely you have an inner join set up and it needs to be an outer join if you want records from one table when the joined field is null in the other table.
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
  3. Aug 7th, 2007, 10:14 AM #3
    kadem
    kadem is offline

    Thread Starter
    Member kadem's Avatar
    Join Date
    Nov 2004
    Posts
    50

    Re: [2005] Crystal reports and null values

    It worked thanks!
    Reply With Quote Reply With Quote
  4. Aug 7th, 2007, 10:27 AM #4
    bmahler
    bmahler is offline
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Re: [RESOLVED] [2005] Crystal reports and null values

    you bet
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width