*This post is locked for comments
I believe to make a column a parameter field you have to use
DrillDownFieldName
like
DrillDownFieldName = [item].[lastupdated]
-Jerry
Hi Danny,
Don't think cast and convert would work - when you try to filter by date, now you're filtering on a string. If my other suggestion doesn't work for you, try this:
1. Connect to the database in Administrator.
2. Open a new Query window.
3. Run the following: UPDATE Item SET LastSold = '1990-01-01 00:00:01' WHERE LastSold IS NULL
4. Repeat for LastReceived.
Of course, I would be remiss if I didn't tell you to BACKUP FIRST! :)
Ron Rahhal
Best POS Sales
Ron
Thanks for the suggestion. Trying to make this easy to use for my wife and staff.
Was wondering if I could change something in the column setting to make it a string? so that I don't get a date range in my QRP report. Maybe I could use a formula to convert or cast the string to a date?
FieldName = "Item.LastReceived"
VBDataType = String
Formula = "" <<<< not sure what to do here or if I need to do anything >>>>>
Any ideas if this would work?
Dan
-------------------Current Column ------------------------------------
Begin Column
FieldName = "Item.LastReceived"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Last Received"
VBDataType = vbDate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 900
GroupMethod = groupmethodNone
ColFormat = ""
End Column
Try changing the selection criteria, instead of the column.
Begin ReportSummary
ReportType = reporttypeItems
ReportTitle = "Item Quantity List"
PageOrientation = pageorientationLandscape
WordWrap = False
ShowDateTimePicker = False
OutLineMode = True
Groups = 1
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
PreQuery1 = ""
PreQuery2 = ""
TablesQueried = "FROM Item WITH(NOLOCK) LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID = Department.ID LEFT JOIN Category WITH(NOLOCK) ON
Item.CategoryID = Category.ID LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID = Supplier.ID LEFT JOIN SupplierList ON SupplierList.SupplierID =
Supplier.ID AND SupplierList.ItemID = Item.ID"
SelCriteria = "Item.LastReceived < '01-01/2010' or Item.LastReceived IS NULL"
GroupBy = ""
SortOrder = ""
End ReportSummary
Ron Rahhal
Best POS Sales
Any advice would be appreciated - running out of time for this report. - see above.
I can get what I want via a batch sql query but would rather do it via the QRP reports more user friendly.
select * from Item where LastReceived = '01/01/2000' or LastSold < '01/01//2000'
In QRP report the date always appear with two parms start date and end dat, how do I change this?
I do also not select everything and do some sorting, etc...
Thank-you
Danny
Small Single RMS site
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154