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

    Print something in a page footer only on the page a group ends on?

    Hi, (Crystal 8.5) I have a report with a number of groups. I do a page break after each group so that each group starts on a new page. I need to print something in the page footer relevant to the current group. But only on the page that displays the last line of that group. So how can I...
  2. uczmeg

    Column layouts - Keeping groups together?

    Hi MrBill, That looks great! Thank you! (You've probably saved a few trees too!) I'll give that a try as soon as I can. Cheers Marc
  3. uczmeg

    Column layouts - Keeping groups together?

    Thanks for the reply Bill. It was the answer I was expecting, if not hoping for! The groups are between 1 and 10 lines, so unfortunately starting each group in a column wouldn't help.
  4. uczmeg

    Column layouts - Keeping groups together?

    Hi, I'm trying to save a few trees by making a 'thin' report use multiple columns. If I do this I really need my groups to stay together rather than get split across columns. Using 'keep group togther' works fine between pages, but doesn't seem to between columns. Is it possible to make it...
  5. uczmeg

    How do I approach this? (Grouping by time ranges)

    And once more I reply to myself! Found the problem. It's not: sum({table.sales},{table.datetime},"hourly") but: sum({table.sales},{table.datetime},"by hour") All works fine now. Thanks.
  6. uczmeg

    How do I approach this? (Grouping by time ranges)

    Hi Having a bit of a proplem putting this into operation. When trying to create either formula field I get the error: "The summary / running total field could not be created" Googling on this has found when other have reported it a problem it is because the group for 'condfld' in the sum...
  7. uczmeg

    How do I approach this? (Grouping by time ranges)

    Thanks LB. I was sure I'd put crosstab in my third post! Clearly not. I had no idea Crystal could group by time in the way it allows, and only noticed it when messing with a crosstab and assumed it must have been related to that, I didn't think of trying it to a normal report. As you can...
  8. uczmeg

    How do I approach this? (Grouping by time ranges)

    Thanks for the help LB. Sadly I don't have a clue what you mean, in the cross tab I can't see any reference to group headers or footers. Can you be a little more 'Crosstabs for dummies' please!
  9. uczmeg

    How do I approach this? (Grouping by time ranges)

    I'm getting there, now that I have discovered I can have a by hour break down on the dates on the rows. I have got a count of the sale_ids by time, and a sum of the sales by time now. Buy can't work out how to get a relation to a percentage of the total qty and sales. I also can't seem to get...
  10. uczmeg

    How do I approach this? (Grouping by time ranges)

    Sorry, managed to post that without finishing. I'm using crystal 8.5. The results would look a little like this: Time qty qty% value value% 8am-9am 8 5 £300 7 9am-10am 11 7 £450 10 etc I'm not sure how to group...
  11. uczmeg

    How do I approach this? (Grouping by time ranges)

    Hi, I need a little help getting started on a report as I'm not sure how to approach it. I have a table of sales, something a bit like this: sale_id sale_datetime sale_total For any given period I'd like to produce a report with info like this in it: Time period, Num of sales, % of total...
  12. uczmeg

    Can Director do this? Multi lingual Autorun CD program

    Hi, I'm looking at Director to solve a problem (although am open to solutions as to any tool/progrmming language to solve this). Do you think it could do the following? I need to provide a program that autoruns when a CD is inserted. This is for registering products and needs to allow the...
  13. uczmeg

    Parsing XML a little help needed please.

    Sorted it myself: Set oOrders = oDom.selectNodes("//os/*") For Each oOrder In oOrders sCust = oOrder.Attributes(0).nodeValue Set oItems = oOrder.selectNodes("*") For Each oItem In oItems sCode = oItem.Attributes(0).nodeValue sQty = Val(oItem.Attributes(1).nodeValue)...
  14. uczmeg

    Parsing XML a little help needed please.

    Hi, I've done very little XML with VB6 and when I have, the file format was somewhat different to the file I now need to process. The file looks like this: <os> <o c="A1D001"> <i c="BOARD001" q="1" /> <i c="BOOKS002" q="2" /> </o> <o c="ABS001"> <i c="CALC001"...
  15. uczmeg

    Counting multiple instances?

    Thanks LB. Not sure option 1 can work, as just passing the category is not enough. I'd need to pass the customer too. Option 2 sounds plausible, although it could mean a hell of a lot of queries if they were running for all customers! I've never used SQL expressions and I'm not sure about the...
  16. uczmeg

    Counting multiple instances?

    Sorry, should add I'm using Crystal 8.5 on to an Access database.
  17. uczmeg

    Counting multiple instances?

    Hi, I have a set of product data. For each customer, each product has a discount and a category. I need to select distinct the catgory and the discounts and order the data in the following way (discount ascending). Like this: category discount cat 1 5% cat 2 6% cat 3...
  18. uczmeg

    Printing - Some advice needed.

    They are plastic cards and they seem happy to waste a lot of ink. That is already in place and nothing to do with me. That isn't really the issue. I more after advice on the best way to print cards (with a picture and barcode on them) from VB. Crystal is no longer in the running as we have...

Part and Inventory Search

Back
Top