Search results for query: *

I develop programs using VB6 and have been using CR8 developer edition for quite some time. I have XI developer but hesitate to install it as there are many reports embedded in many programs I've done for clients using VB6/CR8 and I'm concerned XI will "take over" - meaning I will have to...

Thanks, Reebo- That is perfect. Thanks much, Bob

Hi- I have Order Header/Detail Line type data that I need to print a form for. This is not your usual "print the Header Info, followed by line 1, then line 2, etc." The detail information needs to be printed in a grid - with the quantities filled in the appropriate boxes. There are...

Hi Jim- Thanks - that works. Regards, Bob

Hi Ken- Ouch. Perhaps I should look into creating a User Defined Function. Thanks! Bob

Hi Ken- I am using InStr - right after the Do. There can be as many as 12 equal signs, but usually no more than 4. Thanks BobG

Here's the formula in Crystal 8. The field {OEShipping.CartsUsed} contains a string that keeps track of the number of carts of different configurations. For example, "5=4(4);7=1(3);9=2(0);" would mean 4 carts with 5 shelves, 1 cart with 7 shelves, and 2 cart with 9 shelves. The number...

Hi - I wrote a formula using a Do...While loop in v8, crystal syntax. It works fine. However, the client who wants the report uses Crystal 7, and apparently the only control structure available is an If statement. Is this true? How do you get around this with version 7? Thanks BobG

Hi Goran- Thanks, but that didn't work. I suspect that the number of pages isn't incremented when you select multiple copies. I worked around it by putting all of the report parameters into a sub routine, then called the subroutine three times, with diferent footer text for each copy...

I need a formula to print different text based on which copy of the report is printing. I'm using the RDC with DSR, in VB6. Example: The report prints 3 copies - the first should print "OFFICE" in the footer, the next "ACCOUNTING" and the last, "CUSTOMER". I...

Actually, I do contract work for a Macola dealer in New York. VB front ends, custom reports, etc. I don't have Macola's version of Crystal installed here, since I have the developer version from Crystal Decisions. However, I do have access to their UFLs. Please send me the document you...

Hi Goran- Perfect! Thanks much- BobG

Hi- I have a 15 character string field that usually contains a zero filled number - like "00000000001234". Sometimes, however, the field may contain alpha characters. So, I'd like to suppress the leading zeros, when the field is numeric, and print the whole field when non-numeric...

Oops - The correct code should read: Dim crxSubreportObj As CRAXDRT.SubreportObject Set crxSubreport = Report.OpenSubreport("PullDetailReport.rpt") crxSubreport.Database.Tables(1).SetTableLocation strParameters, "OEORDBLD", " " Regards, Bob G

You are the best! This works perfectly: Report.OpenSubreport "PullDetailReport.rpt" Report.Database.Tables(1).SetTableLocation strParameters, "OEORDBLD", " " Thanks much! Bob G

Hi Ken- >>However, I thought the looping searches were only needed when you don't know the name of the subreport you are trying to set. You know, I didn't actually try to set the table locations by referencing the sub report by name - I'll try that now and get back to you, as that would be a...

Hi Ken- Thanks for the response. I had tried Report.Subreport.Database.Tables(1).... with no luck. I found that you have to drill down through the sections of the report and find each subreport, open each subreport, and set the locations as if each was a report in itself. 'Get the...

Using VB6, CR8 RDC, and Btrieve database files. I set the location of my tables thus: strParameters = gMyDatabaseName & "\oeordhdr.btr" Report.Database.Tables(1).SetTableLocation strParameters, "OEORDHDR_SQL", " " Where gMyDatabaseName has the full...

This must be Treeview Day! I'm using a Treeview in my project, and as each node is clicked, I fire an event showing various pieces of data related to the node in a frame on the form, by using the NodeClick event. The event also fires when a node is dropped onto another parent (as some of the...

Hi David- Thanks for the reply - I'm using CR 8, and don't expect to upgrade to 8.5 soon. I guess I'll have to find a work around. I was trying to capture the ending page number of one report, in order to pass it to another report as a formula. I can count the number of records to be sent to...