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!

Register Log in
  • Congratulations derfloh 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. msi30502

    Numbering Group Headers, then sum

    Hi, this is a proprietary program that was developed by Aspen Systems. They included a report generator that allows me to creat reports using SQL expressions.
  2. msi30502

    Numbering Group Headers, then sum

    Almost there. The values are now 4, which IS the total number of stops. See attached
  3. msi30502

    Numbering Group Headers, then sum

    My appologies I incorrectly typed OE_Orders.OrderDate where I should have written OE_Orders.InvoiceDate In your code, Where OrderDate = '08/06/2021' And RouteCode = 12 you assigned hard values. I need it to pull the values from my parameter settings. How can I do that?
  4. msi30502

    Numbering Group Headers, then sum

    Just tried it and didn't work: It assigned each transaction/invoice a default value of 423, then summed by customer and by grand total (see attached) Select COUNT(DISTINCT CustomerKey) From OE_Orders Where OrderDate = OE_Orders.InvoiceDate And RouteCode =...
  5. msi30502

    Numbering Group Headers, then sum

    Okay, let me back up. I have two tables AR_Customers and OE_Orders. AR_Customers is just the list of customers with basic information (name, number, address, etc.) OE_Orders holds information about each order that is processed (product, prices, item codes, etc.) They are both linked by the...
  6. msi30502

    Numbering Group Headers, then sum

    Is this what you mean? SELECT COUNT (*) FROM AR_Customers AS s WHERE EXISTS ( SELECT * FROM OE_Orders AS t WHERE s.CustomerKey = t.CustomerKey AND t.CustomerKey = 1 ) Because the result is still zero.
  7. msi30502

    Numbering Group Headers, then sum

    Thanks for the Reply @Andrzejek. To answer your questions/comments, 1. When I select a particular customer code I get zero. 2. "Why here is an Order By?" - I copied the code from another website and filled in the blanks. After your question, I removed the GROUP BY. 3. I don't mind getting...
  8. msi30502

    Numbering Group Headers, then sum

    Hi, I'm having difficulty with the following: --------------------------------------------------- SELECT COUNT (*) FROM OE_Orders AS s WHERE EXISTS ( SELECT * FROM OE_Orders AS t WHERE s.CustomerKey = t.CustomerKey AND t.CustomerKey= 1 ) GROUP BY...
  9. msi30502

    Filtering out pages

    Thanks LB worked out beautifully! [pc2] I don't know why I didn't think of that before? Your the best!
  10. msi30502

    Filtering out pages

    ...My question is, how can I generate ONLY the invoices with relevant products, in the original format (including all other line items on said invoice(s))? ***Images Attached*** Thanks in advance.https://files.engineering.com/getfile.aspx?folder=f0969acd-c331-4c23-9571-c565687f949c&file=91200.pdf
  11. msi30502

    Footer VALUE into details section

    Thanks for the reply, but that's not going to work. I din't want to complicate things further, but the year numbers are derived from a number formula not from the database itself. They are actually formulas using global and shared variables. So, I wanted to simplify by just extracting the...
  12. msi30502

    Footer VALUE into details section

    Good Morning...I need help. I have the following situation: In my details section I have a column with 5 years the first year is counted as 0 X 0 1 2 3 4 The total number of years is 5 on the formula summary section in the footer. then I need only the value of 5 to be used as a denominator...
  13. msi30502

    Seasonal Index Forecasting Rolling Totals

    By the way, I'm using CR 2008
  14. msi30502

    Seasonal Index Forecasting Rolling Totals

    Sorry guys this didn't come out looking right. Please see attached file.https://picasaweb.google.com/lh/photo/77dVV_H07do6Th-WBIbu7dYHTvCxFQZKv3vDnTu-4lg?feat=directlink
  15. msi30502

    Seasonal Index Forecasting Rolling Totals

    Hello, I'm stuck! I want to create a report to that a rolling totals. Here's what I mean: Year Quarter Quantity Rolling total 2013 1 10 2 20 100 ---> 100 = 10+20+30+40 3 30 140 ---> 140 =...
  16. msi30502

    Adding 2 Cross Tab Summarized Fields

    Here's the Link Below. You can click the Zoom button to see details. Hope this is enough. If not, let me know. CR8 Cross Tab Details Link
  17. msi30502

    Adding 2 Cross Tab Summarized Fields

    2008
  18. msi30502

    Adding 2 Cross Tab Summarized Fields

    Hi All, I have two summarized fields I need to add in a Cross Tab: Median @Cases Sold + PopStdDev @Cases Sold How can I create a third Column in the same Cross tab that adds these two up? Thanks in advance
  19. msi30502

    1 Year Date Range Formula in Filters

    Thanks, it worked. I'm guessing that If I wanted to go back only 6 months it would be: {JrnlHdr.TransactionDate} > DateAdd("MM", -6, CurrentDate) Is this correct?
  20. msi30502

    Static OLE object to be embedded into a Crystal Report

    Oops! Sorry, thought I was posting on another forum. ====== I am definately sure it has to do with your linking. I've had the same issue with using attached photos to the database. Eventually, I had to work around it and do as I mentioned above. Sorry I'm not skilled enough to help you...

Part and Inventory Search

Back
Top