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 IamaSherpa 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. Canthros

    Pick Lists with multiple selections in unmanaged reports

    Much thanks. I've been looking at this problem for more than a month now and I hadn't seen the thing with brackets anywhere.
  2. Canthros

    Pick Lists with multiple selections in unmanaged reports

    Basic rundown of current situation: To facilitate the use of dynamic pick lists/parameter lists, several of the Crystal Reports (v8.5) here are accessed by some ASP wrappers to populate the selection lists at run-time, rather than design-time. This has been working very well so far, but recent...
  3. Canthros

    Crystal Reports Viewers and ASP/HTML

    Basic rundown of current situation: To facilitate the use of dynamic pick lists/parameter lists, several of the Crystal Reports (v8.5) here are accessed by some ASP wrappers to populate the selection lists at run-time, rather than design-time. This has been working very well so far, but recent...
  4. Canthros

    Dynamically updating default values for a report parameter

    Not sure if this is quite the right place to ask, but I'm not sure anywhere else is wholly appropriate, either. Problem: I have a report that filters based on the contents of a field (a person's name). The values that it filters on are entered by the person who brings up the report. Because the...
  5. Canthros

    DB Logons

    End result: needed to use a File DSN rather than a System DSN for pulling information out of the Access database. Once the File DSN was set up on the systems involved, things worked just fine.
  6. Canthros

    DB Logons

    We have several reports which (currently) corss-reference some information from SQL Server with some information in an Access database. These reports work fine in Crystal Reports, but, once they've been exported to Enterprise, they cannot seem to log in to the Access database, though they appear...
  7. Canthros

    Displaying Empty Groups

    By custom group, I meant that the group was on a particular attribute/field but in a specified order (rather than ascending/descending on the group name or field value), which also requires specifying a name for the group. This terminology was used in the Crystal Reports 8.5 help file, so I...
  8. Canthros

    Using Count function to find duplicate entries, problem

    Group on the P.O. Number Create a Summary -> Count on the P.O. Number Use Report->Edit Selection Formula->Group... Double-click your summary in the field box. Type > 1 after it in the formula area. At this point, you should be able to save the formula and have only the P.O. Numbers with...
  9. Canthros

    Displaying Empty Groups

    View of report (with records in all groups) Group 1 $80 Group 2 $85 Group 3 $20 Total $185 View of report (without records in Group 1) Group 1 $0 Group 2 $85 Group 3 $20 Total...
  10. Canthros

    Displaying Empty Groups

    Sorry, it just occurred to me that some information is missing that might be helpful: All three groups are custom groups. That is, each group already has a set criterion on which it matches records and pulls them into itself. They group on an existing field on each of three values in the field...
  11. Canthros

    Displaying Empty Groups

    Not quite what I was getting at, I'm afraid. I have no records for this group, right now. In the future there might be records in the group, or there might not (I don't control data entry), but, for the report, I need to show the group name and the summary value (null or 0, or whatever). Doing...
  12. Canthros

    Displaying Empty Groups

    I've got a situation where I need to display a group which doesn't have any records associated with it. For instance: Group 1 Summary Group 2 Summary Group 3 Summary Total Sum In the current situation, Group 1 does not display because the query does not return any...

Part and Inventory Search

Back
Top