Search results for query: *

Greetings, I'm looking for a reference which defines the internal file structure of an RPT file for CR8.5. I am building reports for an ERP package and I'd like to do a little surgery before distribution. Specifically I'd like to zero out the version number and editing time data. This will...

Hi, I am very new to VID (I first used it last week) and I am trying to move some projects from one developer's machines to my own. He has IIS running on his, and I installed it on mine. I've copied the project folders to my machine, but VID insists on running them off of his server. We...

I'm not sure if this will help, but verify the database in the master and sub reports. I've found that most of the crashes I see in Crystal occur if I make changes to the schema and don't verify the database. It doesn't give and error, it just crashes (versions 7 and 8). Scott

Ken, Yes, I can generate the recordset to pass to Crystal. The problem is representing a tree structure in the report. Indeed, the tree is already stored in a database so that part is taken care of. Scott

Hi, I will be building a report using the Automation Server to be run from within VB. I will need to report the contents of a tree, such as a directory structure. The tree can have any number of levels, and any number of children per node. I am looking for ideas on how to approach this in...

I think strongm's solution is a tad more elegant though... Scott

Sunaj, If you want negative numbers to have a negative order of magnitude, use this code: Public Function OrderOfMagnitude(x As Double) As Double If x = 0 Then OrderOfMagnitude = 0 ElseIf x < 0 Then OrderOfMagnitude = -10 ^ Int(Log(-x) / Log(10)) Else...

Ron, Curiously, I replaced &quot;\\localhost&quot; with my own machine name, and got the same number. Then I tried another machine on the net and got the same. Then I realized the number was slightly larger than my actual disk. I am not sure why any machine returns the size of my local. Scott

Hi, I wrote a VB Script program which pulls information from three tables in a Paradox database, does some massaging and then writes records to a Visual FoxPro database. Its purpose is to transfer some order information from a program called Cyrious POS to Vista by Epicor. I've included a...

Eugene, I am fairly new to this automation stuff, but I'm using the Automation Server Active-X control. It makes it pretty easy to take a report designed by the report designer program and load/view it within a VB program. You can set or override most of the report settings, including the...

Suppressing the section should hide everything in it. I'm not sure why it wouldn't. You could try conditionally suppressing the subreport itself. By &quot;empty boxes,&quot; are you referring to the border of the subreport? Have you manually suppressed the section? If it won't disappear...

Mike, It sounds like the line is placed within the group footer. Move it into the report footer above the total formula. Assuming I understand your layout, that should fix it. Scott

Hadi, First let Crystal create it by setting a record selection formula as Smitty described. Then look at the SQL using the method I listed. Then use that as a template to set the SQL string from VB. An alternative to setting the SQL string is to set the record selection formula from VB...

VBProgrammerJ, Did any of us actually answer your question? Many good points have been made regarding structure, but I'm not sure that any (including my first post) actually answered the question you asked? Scott

I found a workaround. Since I am calling the report from VB, I just looked up the file modified date and passed it in as a string formula. I would still like to find a way to access the total editing time and number of saves though.

Jack, You could create a formula which massages the value into a sortable form, then sort on the formula. You would need to parse the string to split it into the alpha and number parts, then recombine them with sufficient leading zeros or spaces to accomodate the largest number you will...

dsangel, One other idea... If you want to avoid adding references (which suggests that you are currently shelling to a compiled report) then you might consider using your VB program to do the record selection to arrive at a smaller dataset. The report would then look at that. As for the...

If I am reading the question right, I think VBProgrammerJ doesn't want to stop the loop in the middle, just skip that iteration. Use this structure: do while <loop condition> if not <skip condition> then ' Processing here. end if loop This will loop until <loop condition> is...

Tapan, I don't know of a way to globally change the datasource across multiple .rpt files. You might want to set them all to a particular ODBC data source though. Then you need only redefine the physical path in the ODBC data source, and all the reports will follow. Scott

To all, It may be less finicky to pass a formula definition instead of a parameter. I create formulas with default values in the report, then if the default is not appropriate, I have VB replace the formula with one that returns the value I need to pass. Scott