Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cbolton652
- Order by date
-
Adding additional parameters
Thanks Brian, here it is. I used >0 to prompt for any code Record Selection Formula Editor view. {vwNCTA_ExpoRevenueByCompany.OrderDate} >= {?StartDate} and {vwNCTA_ExpoRevenueByCompany.OrderDate} <= {?AsOfDate} and {vwExpos.ProductID} > 0- cbolton652
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Adding additional parameters
Thanks for your reply. And also, I am on 8.5 not 9. But yes I can see it under field explorer > parameter field. This is how my SQL view looks. The date prompts but not the product id WHERE vwNCTA_ExpoRevenueByCompany.OrderDate >= {ts '2004-03-11 00:00:00.00'} AND...- cbolton652
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Adding additional parameters
I am using Crystal v9. I am trying to add a new criteria to prompt users when the report is run. Users are currently prompted for the date and I want to add a prompt for product. I went the insert>field object>and added the new parameter however it still does not show in the prompt. I also...- cbolton652
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
