Skip to Content
author's profile photo Former Member
Former Member

Getting only one record from simple report

Hi. I'm pretty new to CR. Wrote one substantial report on version 8, using a lot of the basics anyway. Upgraded to version 2011. I tried to write an extremely simple report linking three tables by customer number (Great Plains accountng system). There is one input parameter, a date. The selection criterion is simply that the "last transaction date" (table 2) be equal to or greater than the input date. I then ask for the customer name, city, state and telephone (table one), last transaction date, year-to-date and last-year total activity (table 2) and email address (table 3). It works fine--except I'M ONLY GETTING ONE RECORD! It's so simple, I can't find anything to change. Is there a problem with date comparisons? There could be a null in the last tranaction date of the next record, though that isn't likely. Are nulls a problem in date comparisons? Surely this is very simple for someone who knows what he or she is doing. Sure would appreciate a tip!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 11, 2012 at 05:39 PM

    Can you show your Database Expert - how the tables are linked?


    SQL statement?

    Also, How do you pass the parameter to the SQL statement for the last transactin date?

    In Select Expert - can you show me how you pass the parameter?



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.