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 Westi 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. trapset4

    arrays and group name issue

    Still having trouble!! The summary works great. BUT, my hierarchy is series->species->finish. I need: top 3 finishes for each species. This works, thanks lbass. total for each species within series. total for each series. This works because it is just a total. Report should look like: Qty...
  2. trapset4

    arrays and group name issue

    Nevermind. I revamped a some stuff and now it works. Thank you for your time on Summary issue.
  3. trapset4

    arrays and group name issue

    Thought I would include more info. I break the code into its 2 parts successfully and store as Shared variables MaxFinish1 and MaxFinish2. In the subreport( placed in a second Species Group line) I have this code in the details section where C1, C2, and Colors are defined as "" in the subreport...
  4. trapset4

    arrays and group name issue

    I figured out how to capture the finish group name - it wasn't hard once I knew what I was looking at. But, I am having trouble sending the code to the subreport to find the name ( I have done this as parameters, but not as shared variables before). Is there a trick with variables between...
  5. trapset4

    arrays and group name issue

    OK, I got the summary working - many thanks! However there is a 2nd part that I stayed away from until I saw what I could do with the grouping. My finish color is actually a 4 character code consisting of 2 colors (2 characters each). I have successfully parsed them into the 2 codes and used a...
  6. trapset4

    arrays and group name issue

    Here is the array of occurrences (it is in details section) WhilePrintingRecords; Shared Numbervar i; // counter Shared Numbervar array fc; //series species finish count If GroupName ({@Finish})<>"" Then ( Local NumberVar r:= {VM_ORDER_LINES_AC_HS.QTY_ORDERED}; //quantity ordered Redim...
  7. trapset4

    arrays and group name issue

    I am using 2 arrays. 1 array captures the groupname(finish name). The other captures occurrences of the groupname. I then find the max of occurrences and use my counter to find the corresponding finish name. The counter works and I can capture the occurrences, but I cannot capture the finish...
  8. trapset4

    Subreport use

    That did the trick. But, in later versions, is this not necessary? It seems that this is a little clunky of a work-around. I am asking because we are looking to upgrade and wondering if it is worth the effort.
  9. trapset4

    Subreport use

    Is it possible to have a "Master" report with no tables connected and then just have the 2 subrreports? I am using Crystal 10 with XP.
  10. trapset4

    Subreport use

    I have a report that I would like to run current year data if this year is selected and historical year data (different tables) if a prior year is selected. I figured the best way was to use a master report to collect the date ranges and generate the page headers and then use subreports for the...
  11. trapset4

    Charts and Formulas

    I am very new to charts in Crystal - though I produced them in Access. My x-axis data is dates. I want the 12 full weeks prior to today (preferably the Sundays). My y-data includes Order totals for these 12 weeks. I would also like to show our target and breakeven points. The dates I...

Part and Inventory Search

Back
Top