Search results for query: *

Perfect. Thank you!

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

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

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.

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

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.

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

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

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!

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

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

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

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

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

...With oDom If .Load(sXML) Then If Not oDom.documentElement Is Nothing Then Set oOrders = oDom.selectNodes("//os/*") For Each oOrder In oOrders 'get customer code 'loop through items getting code/qty...

Thanks, sorted that now.

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

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

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

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