Search results for query: *

Never mind I finally figured it out, just had to have the right fields to work with!

Crystal 6.0, I have a field {WORKORDER.REPORTDATE}and another field @Date that gives me a number. How can I add the 2 fields together to increase the {WORKORDER.REPORTDATE} by the amount of days stated in the @date field. I tried if {@Days} = "1" then {WORKORDER.REPORTDATE} + 500...

I have a text box that I would like to enter a date in, when I do I would like to have an option group that contains 2 options used and unused make the used box active, if I remove the date I would like the unused box active, is there a way of doing this with Access 97?

I tried this but it does not find the last records at all that deal with the 1/2Days {Employees.Day1} in {@StartDate} to {@EndDate} or {Employees.Day2} in {@StartDate} to {@EndDate} or {Employees.Day3} in {@StartDate} to {@EndDate} or {Employees.Day4} in {@StartDate} to {@EndDate} or...

I am trying to figure out how to search a report that I have 26 field that are dates. I would like to be able to just have the records show up that are within a date range. I have done it by 1 date before, not sure how to cover all 26 dates though??

I use Crystal Desk to print out my reports, is there a way to have a report not print out anything if none of the data you were looking for is not found, right now alot of my reports contain text followed by the information being looked for, depending on the time of month when the other reports...

Crystal has a way to suppress duplicates, Is there a way of only showing duplicate fields?

I have a crystal6 report that accesses an oracle db. This report uses a subreport linked by the equipment record which is the only field available to link on. I have the subreport suppressing if the item field is null but the equipment record still shows up and takes up space on the report. Is...

Thanks Ken this is exactly what I was looking for.

Ken I use the date as a parameter field to search a report for records between 2 dates. I just wanted to know how to input the dates so crystal could use them. Presently I use if {?Start Date} = "" then PrintDate Else If NumericText(Left({?Start Date},2)) = True Then if...

What is a good formula for dates in using to search a report. The one I presently use requires the mm/dd/yyyy. Is there one available that would allow mm/dd/yy. What are some of the ones you experts use, the more selections the better. TIA

Is there a way of formating a positive number to have brackets around it as ($100.00)

Got it Thanks

Crystal 6 I have a field that consists of names as McCormick Ed. How would I be able to make this into 2 fields say FirstName, LastName.Each Name has a space between first and last name or just be able to split it up so I could get the first name or the last name in another field.

I solved it just had to go 1 more step, Thanks

Morning Using CR6 to pull info out of a stock room db. In the details line I selected all of the info and told it to suppress if a certain field was = to return, I need this in the report to cancel out the issue. The only problem this leaves is that the report now has blank lines and looks...

I have a memo field in the database (Oracle 7) that I need to do search on. Crystal comes back and tells me that I cannot search on this type of field, is there anything I can do here.

I am already using a parameter field, But if you were new to this report and had 20 choices is there a way to show these 20 choices so you can pick one?

Is there a way in crystal of inserting a field that is like a drop down box as in access. I would like to be able to have a user use a field that they could choose from multiple inputs.

I am writing a report that searches a stockroom database, I would like to find out the total number of an item that is listed to say a cost center. The problem I am having is that when one item is issued more than once it only shows up once, you could have issued it 20 times but only have 1 show...