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 dencom 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: terrym777
  • Content: Threads
  • Order by date
  1. terrym777

    Passing values from an array to subreports

    Hi, I hope someone can help me figure out how to approach this problem. I have a main report that has one grouping by classname. Currently the report passes one parameter date to 5 subreports. I now need to modify this report by giving the user the option to run this for one day of the week or...
  2. terrym777

    Multiple subreports in a main report

    I have created a report using Crystal XI but it is being run in an older Crystal Runtime version 9. I do have other reports with multiple subreports that run ok. I am getting an Invalid Table Number crystal runtime error. The main report is simply a container for 5 independent subreports with no...
  3. terrym777

    Running Total variables

    I am using formulas for my data as in some cases I need to make the value zero if it has been brought in twice. As such, I am using running total variables and not the RT function. The question I have is why the last value in a group is being added into my group total line? Here is my example...
  4. terrym777

    Multivalue Time Parameters

    I am using Crystal XI and I need to sort my report by user selected time parameters. I know that you cannot group by parameter selects so I am trying to create a formula to group or sort by. I am having trouble trying to extract these into a display field which might subsequently help me to sort...
  5. terrym777

    Fatal System Error - Database is unreachable

    I am intermittently getting this error message when opening Crystal XI on my Getting Started Page. Fatal System Error -- Database is unreachable -- please email this message to webmaster. I am not having any problems that I am aware of but was just wondering what might be generating this error...
  6. terrym777

    Formula not showing up in Group Sort dropdown

    thread149-1608140 I am trying a new approach and I thought I might have had the solution until I tried to Group by a formula that I created. What I am trying to do is to somehow print statements with multiple pages at the beginning of the print job. Using a line counter is too complicated as I...
  7. terrym777

    Replace using a wildcard and for a certain length

    I am having difficulty trying to strip out a variable length string at the end of a title text field. There are 4 different cases and they may be a different length. For example, Yoga Class - Spring Yoga Class - Summer Yoga Class - Fall Yoga Class - Winter I want my output to just be Yoga...
  8. terrym777

    Array Parameters

    I have very basic Crystal skills and I need help with an array parameter. We have a camp database where a child may attend camp for any number of 8 weeks. For example, a camper may attend weeks 1,2,3,7,8 stored in this format. We want the user to be able to select all weeks or multiple weeks in...
  9. terrym777

    Subreport problem

    Our batch report calls a subreport which links by a parameter date equal to a batch transaction date. The subreport works fine for all dates except for one particular date and when this date is selected the subreport will only print text fields. If I run the subreport by itself in...
  10. terrym777

    Sort invoices first or last if multiple pages

    I'm trying to find a way to have our invoices with multiple pages to sort either at the beginning or the end so that they can be easily pulled out and not put through our fold and stuff mail machine. I would like to use the Page N of M feature because each invoice has a variable number of...

Part and Inventory Search

Back
Top