Date Range Not Linking to CreatedDate field

[jaguar00]

Using CR8.5

I have the task of creating a Customer Quote List report based upon a parameter using date ranges based upon a CreatedDate in a quotes table as well as a Customer Name in a customer table. The report should also list the total $ for the quote. I've ran across a couple of issues;
1. I can get the quotes to list with the total $ but they list more than once if there are more than one item listed in the quote.
2. My date ranges aren't pulling from the CreatedDate field.

Everything I've tried doesn't work. Any suggestions??

Many Thanks!!!

 

[synapsevampire]

It sounds like you need to join the customer table to the quotes table, and then in the Report->Edit record selection->Record place something like:

{quotes.date} = {?MyDateParm}

As for the multiple items listed in the quote, Perhaps the field that you're summing is the total amount as opposed to the individual line item amount.

Try grouping on the Quote ID and then summing by each quote. If that fails, try just placing the fields of interest in the group footer section (this assumes that it's already summed).

To get better help, post example data and expected output.

-k