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. jsaint

    Running CR8.5 reports from Command prompt

    I would like to set up a .bat file to run an 8.5 CR rpt, passing multiple parameters, and then saving the report to a PDF file. Does anyone know if this can be done without using a VB container? thanks, Jack
  2. jsaint

    Date Columns in SQL Designer

    I am trying to use a .qry file created from an SQL statement as the datasource for a Crystal 8.5 report and then pass it a parameter to only select rows where a date field year is what is selected. When I create a .qry file from SQL Designer, it always converts my date fields to strings and...
  3. jsaint

    Column Reports Using Groups

    I need a fairly simple report that looks like: Group 1 Group 2 1 3 2 4 But reporting with multiple columns wraps headings inappropriatley. Anyone else figure out how to report when you only have 1 column of data that is grouped and you want to use the whole width of...
  4. jsaint

    Query Refresh Problems

    I added columns to an existing query. Then I followed the steps recommended in other threads on this subject: 1. Set Location and changed to the new query, which had all the same columns as the old plus 3 new additional columns. 2. Verify Database. 3. Field Explorer shows all fields including...
  5. jsaint

    Reporting on MS Outlook over a network

    At my current site, I need to be able to write Crystal reports on the Tasks and Calendar folders in MS Outlook. I have been able to connect using MS Exchange to the Outlook folders on my own laptop which runs NT 4.0, but when I try to connect using MS Exchange at this site, where MS Outlook is...
  6. jsaint

    Hierarchical Grouping Levels

    Thanks, Steve. I ended up creating a formula in the group header to display the level. It creates an array of parent ids. Since Crystal sorts hierarchically by id, the parent is always before the child. Every time a child is read, I spin back through the array looking for the parent and...
  7. jsaint

    Hierarchical Grouping Levels

    I am trying to determine # of levels deep into a hieracrhical grouping I am so I can conditionally format based on level. I want to be able to have the users input # of levels deep to display and then only have the hieracrhical group go that number. I also want to indent the group name, but not...

Part and Inventory Search

Back
Top