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

    Grouping based on parameter

    I have tried presenting user with a prompt and asking them to select the field to group on. Then I tried to use that parameter as a group, but parameters aren't available for grouping, so I used the parameter in a formula (stringvar groupon:={?groupParam} and then used that formula to group on...
  2. amoeba102

    Grouping based on parameter

    I want to present the user with a list of fields from which they can choose the field to group on for a report. I get 'Invalid Argument', or a message about trying to group on a non-recurring field. Using CR XI
  3. amoeba102

    print statement based on activity

    Crystal Reports XI I am creating statements for lastfullmonth (CR function). I only want to print them for accounts that meet both of two criteria- 1. zero balance forward. 2. No activity during lastfullmonth. I am getting the balance forward info via a view in a group just below the...
  4. amoeba102

    is element in array 1 an element in array 2

    Using crystal XI Dealing with selection criteria I have 2 identically structured tables. I want to select the record if the value in table2.field1 does not exist in table1.field1 I've tried being creative with 'instr' and in [array], in both selection criteria and section expert, but either...
  5. amoeba102

    Can't edit commands or parameters in CR XI

    In CR XI have a report that gets data via 2 commands. It also uses a cascading parameter. All were done in XI. I was able to add the commands to the repository. Then I attempted to add the parameters to the repository and wasn't able to determine how to do it. But now I can't edit either of...
  6. amoeba102

    Sorting based on values from subreport

    CR XI I'm getting the balance from 3 subreports (invoice, payments, DrCrMemos) passing those values back to main, and doing the final calculation of the balance due in the main report. I want to group on the result of the balance due calculation. Is there any way?
  7. amoeba102

    subreport displaying multiple times

    Worked perfectly. Thank you!
  8. amoeba102

    subreport displaying multiple times

    Using CR9. I have a main report and 4 subreports. The ones pertinent to my question are: Invoice, context, person. They link this way: Invoice.Main_Context inner join to Context.Context_id. Context.Person inner join to Person.Person_id I have an invoice subreport. The invoice # is passed...
  9. amoeba102

    Need column formatting help

    yes, that's what I would like, but when I select down and then across it only wraps up to the second column when the first column fills the full length of the paper. It doesn't do 'column balancing', (which is my phrase) - if there are 9 items and 3 column, it should be only 3 lines long with...
  10. amoeba102

    Need column formatting help

    I want my data to look like this: Group A 1 4 7 10 2 5 8 11 3 6 9 12 Group B 1 4 7 10 2 5 8 11 3 6 9 12 I...
  11. amoeba102

    Emergency-dynamically select and print reports

    So simple - thank you . My hide has been saved.
  12. amoeba102

    Emergency-dynamically select and print reports

    Hm, that sounds too easy. I had thought about something like this but couldn't figure out where I would put these sections so the pages didn't print before the receipt was finished and I got a new page before the next receipt. I know I'm missing something here.
  13. amoeba102

    Emergency-dynamically select and print reports

    I have a report that is a receipt for classes that will run overnight. For each class, after the receipt it should print a requirements page. So the output should be something like: receipt 1, req 1, req 2, req 3 receipt 2, req 1 receipt 3, req 1, re1 2 etc, with req 1... being any of 50...
  14. amoeba102

    1 report to selectively trigger others

    Sorry, I wasn't clear. All receipts for transactions that occurred during that day print via a scheduled report at 2:00 AM. They are sitting on our printer when we come to work.. Now they want to pick up the pile of receipts and have it in this order: Cust1Receipt, RecptInfoSheet1...
  15. amoeba102

    1 report to selectively trigger others

    Using CE9 Prof. & CR9 Dev. I have a receipt running overnight. We want to have information reports print collated with the receipt, based on the items purchased. These information reports are separate CR reports. I've never tried this type of thing before. Is it easy/hard, possible/impossible??
  16. amoeba102

    CE10 & CR9 Compatible?

    I would like to install CE10 Professional on the Crystal server so I can take advantage of Business Views. I use CR9 Developer on another machine, and upload all reports to the web via the CMC. Will this work? Any compatibility issues? Couldn't find anything on the BO website. Couldn't even...
  17. amoeba102

    Connection to Repository fails

    The repository database is on the Crystal Enterprise 9 Server. I also used that machine as my workstation in the past, but want more freedom to install programs, so I moved to a different machine for a workstation. I am trying to connect to the repository on the CE server for editing my CR9...
  18. amoeba102

    totext(numeric) sorts wrong

    Thank you! I thought I had used every combination possible, but I guess I missed that one. It worked!
  19. amoeba102

    totext(numeric) sorts wrong

    I searched the archives but evidently used the wrong criteria. I'm trying to make the group tree more useful. The group name is numeric {cngroup} and right now all the user sees is 1 2 3 4 etc. but there are responsible individuals assigned to each group and I would like the tree to show 1...

Part and Inventory Search

Back
Top