Recent content by ScottGS

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.