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 bkrike 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: *

  1. lawsonreports

    Sort grouped data by a different field?

    I know this must be simple, and I have read through dozens of posts, so maybe I have just missed it somehow. I have a report that is grouped by the employee ID number. It displays the groups in that order. But I need to sort and print the groups themselves by the employee Name field. I can't...
  2. lawsonreports

    Any other way to do this other than a subreport?

    I know this is simple, but I am new to Crystal, and I'm stumped. I have a table with these fields (greatly simplified): Emp#, License_type, Active_flag There are many License_types for each Emp#, but only one where Active_flag = Y. Here is what I want: Show all records, by employee, for...
  3. lawsonreports

    Stupid question on Basic vs Crystal Syntax

    This is a basic formula. How would this be written in Crystal syntax? And is there any advantage to using one over the other?? formula = "From " + ToText(Minimum({?ActivityDateRange})) + " To " + ToText(Maximum({?ActivityDateRange}))
  4. lawsonreports

    Linking to a specific report on Intranet? (& passing it a parameter)

    We have a staff section on our intranet where the users login with their SSN number. We want to replace an existing report with a similar one in CE. This report has a parameter for SSN. Is there a way to place a link on our intranet that will allow a user to run the report, without any...
  5. lawsonreports

    How to conditionally suppress date

    I have a date field that occasionally has a SQL server default value of 01/01/1753 in it (no nulls allowed, yet the application does not require the date to be entered!). I want to show this value as blank on a report. After I had no success figuring out a Crystal syntax formula, a co-worker...

Part and Inventory Search

Back
Top