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 strongm 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. terrym777

    Passing values from an array to subreports

    Thank you for replying but I still don't see how doing it this way will work in my case. Let me explain further: Main Report GH1 - Class name D - Suppressed GF1a - Subreport 1 - Parents report GF1b - Subreport 2 - Early Attendance report GF1c - Subreport 3 - Regular Attendance report GF1d -...
  2. terrym777

    Passing values from an array to subreports

    Any further suggestions? Basically, I'm trying to get the main report to process all 5 subreports with one date and then repeat the process if the user wants to run the report for a weeks worth of data.
  3. 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...
  4. terrym777

    Multiple subreports in a main report

    I figured out my problem. I needed to have something in the main report so I just brought in one table and one field that I placed on the detail line, which I then suppressed and now the subreports run fine.
  5. 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...
  6. terrym777

    Running Total variables

    Hi again, It looked like it worked this time. Thanks!
  7. terrym777

    Running Total variables

    Hi Ian, I thought I tried that and it still did not work but I will try it again. Do I place these new Display formulas on the GH and RF lines? Thanks for your help, Terry
  8. 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...
  9. terrym777

    Multivalue Time Parameters

    Thanks for your response! I will look into this approach.
  10. terrym777

    Multivalue Time Parameters

    We are thinking of having, for example, 5 separate time prompts and having subreports for each time that they select. Does this sound doable?
  11. terrym777

    Multivalue Time Parameters

    This is what they would like the report to look like: Weekly Staff Schedule Report 6/3/2012 - 6/7/2012 Parameter Times selected - For example, 6:00AM, 11:00AM Group by School Site Group by selected Parameter Times (picked from a list of times) (Was trying to create a formula to group by)...
  12. terrym777

    Multivalue Time Parameters

    The problem is that the time field will never equal the parameter. Let me explain further. This is a teachers schedule where one day they may work from 9am to 1pm and another day from Noon to 5pm. The multiple value parameter lists every hour on the half hour from 6am to 6pm. The user can select...
  13. 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...
  14. 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...
  15. 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...
  16. terrym777

    Replace using a wildcard and for a certain length

    Thanks also to you too Mike. I had the same typo in your formula and it worked also. And thank you too Fisheromacse for your suggestion.
  17. terrym777

    Replace using a wildcard and for a certain length

    Hi lbass, I just found my typo in your formula! Thanks for the help again. Terry
  18. terrym777

    Replace using a wildcard and for a certain length

    If Ubound(Split({SESSION.Title},"-")) > 1 Then Trim(Split({SESSION.Title}),"-")[1]) Else {SESSION.Title}

Part and Inventory Search

Back
Top