I have a report that i am writing. and i use a select for from and to dates on the invoicedate, and i also have a item select(between) which works.
for the date select the user inputs say 11/1/2014-11/30/2014.

and the report gives the qty/dollar sold for that range.

is there a way to create a column that will display the same data qty/dollar for 11/1/2013 - 11/30/2013.

if you create a SQL field will that go off the db table to pull the data no matter what date selection you do on the initial report select?

right now, i am only displaying group footer.
i am surpressing/no drill down on detail.

I have two parameters that i created. fromdate; todate.
very new to this, does this go in the SQL expression Fields or in the select expert under invoicedate??

Thanks for helping!!

You cannot use maximum in the select expert.  You might be able use it in a group select  (never tried before though).  The only option I can think of is a command or a stored procedure.

Z9962,

i changed my fields and made it a date range like your previous post, first time using that. thanks.

so, my select is.

{AR_InvoiceHistoryDetail.ItemCode} in {?FROM ITEM} to {?TO ITEM} and
({AR_InvoiceHistoryHeader.InvoiceDate} in {?daterange} or
{AR_InvoiceHistoryHeader.InvoiceDate} in DATEADD("yyyy",-1,minimum({?DateRange})) and
DATEADD("yyyy",-1,maximum({?daterange})))


when i check the syntax, i get the error:

A Date-Time range is required here, and it highlights the following part of the statement.
DATEADD("yyyy",-1,minimum({?DateRange}))

my daterange parameter was created with type:DATE (Static)



Peter