James McDowell

Why do I always find this stuff when I have a deadline?!!!

Metric wire lengnths do not show in Legacy reports correctly (I don't know about new ones.)

A wire run of 20 meters was showing in the report as 6. The lengths for the wires in the bundle had all sorts of crazy lengths assigned. Converting them to US units required reassigning the head end to get the lengths right. (I thought you guys fixed the metric stuff?)

Images assigned to database products do not show in reports if they were assigned after converting the database from Si4 format.

I don't have time to start learning how to rework the new reports to fit our letterhead.

Anybody have a fix?

RandyB

Originally Posted by James McDowell

Metric wire lengnths do not show in Legacy reports correctly (I don't know about new ones.) A wire run of 20 meters was showing in the report as 6. The lengths for the wires in the bundle had all sorts of crazy lengths assigned. Converting them to US units required reassigning the head end to get the lengths right. (I thought you guys fixed the metric stuff?)

Which report are you having trouble with? I am unable to reproduce this problem with the Line Item report. This is fixed in Service Pack 3 as far as we can tell.

Can you email the .dtl file to me at beta@d-tools.com so I can see what's going on?

Thanks,

Randy

Originally Posted by James McDowell

Images assigned to database products do not show in reports if they were assigned after converting the database from Si4 format.

This one is a bug that we'll have to look at for a future service pack. Reference #3012.

James McDowell

Hi Randy:

It is a reformatted version on the Line item list price report. I have already converted all wire lengths to feet and reworked the wires in the bundles so I don't think that sending it now would do you any good.

It is interesting that though the wire length was set as 20 meters and showed as 6 meters in the report, 20 feet would equate to about 6 meters. Maybe that's a clue. I will try and recreate the problem in a new file.

I did spend a long night figuring out the new report designer software and the scripting language so I was able to get the documents to my client.

Where can I get some more info on functions and parameters that are accessable though the scripting language for the new report designer. I downloaded the "manual" from the third party site, but I would like more info on the "objects" that are available in the reports.

Thanks.

RandyB

Originally Posted by James McDowell

Hi Randy: It is interesting that though the wire length was set as 20 meters and showed as 6 meters in the report, 20 feet would equate to about 6 meters. Maybe that's a clue. I will try and recreate the problem in a new file.

It may be that this project was never converted to SP3 format (which stores data in meters vs. pre-SP3 which was in feet). This conversion should have happened automatically the first time you opened the project in SP3.

In any case, if you are able to reproduce, send me the .dtl and I can take a look.

I have asked Rick C to answer your other question. There is a lot of information in the Reports section of the forum for stuff like this. Fairly soon we will collect all of this in one place to make it easier to find. Until then, Rick can help.

RickC

Originally Posted by James McDowell

Where can I get some more info on functions and parameters that are accessable though the scripting language for the new report designer. I downloaded the "manual" from the third party site, but I would like more info on the "objects" that are available in the reports. Thanks.

James,

Here's a link the the Active Reports API documentation. This lists all the objects and their properties/methods that are available in scripting:

Active Reports API

Available in the script of every report is an object that D-Tools provides called "ReportUtilities". This has a number of helper methods that we use to do a number of things that would otherwise take several lines of script. The documentation for this can be found here:

ReportUtilities API

From a more general perspective, the script is written in VB.NET so you have access to all the base types available through the .NET framework (String, Integer, Double, Boolean, DateTime, Decimal, Single, etc.)

More info on this can be found here:

http://msdn2.microsoft.com/en-us/lib...dk(VS.80).aspx

Don't get overwhelmed. I would focus your attention to:
DataTypes (string, integer, boolean, etc)
Operators (equal to, greater than, etc.)
Statements (If..then..else)
Functions (These are built in functions provided by the framework).

The MS stuff does a good job of explaining the concepts fairly well at this level of their documentation.

This is also a pretty good section for explaining the language concepts:

http://msdn2.microsoft.com/en-us/lib...5d(VS.80).aspx

Hope this places you on the right track.

-R

James McDowell

Hi Guys:

Thanks for the links; that's very helpful.

As far as the project with the metric issues, the project was created in V5 sp3. The reports are just V4.

RandyB

Originally Posted by James McDowell

Metric wire lengnths do not show in Legacy reports correctly (I don't know about new ones.) A wire run of 20 meters was showing in the report as 6. The lengths for the wires in the bundle had all sorts of crazy lengths assigned. Converting them to US units required reassigning the head end to get the lengths right. (I thought you guys fixed the metric stuff?)

James,

Try unzipping and saving the attached DrawingTemplateV50.mdb file. Place it in this directory:

C:\Documents and Settings\All Users\Application Data\D-Tools\SI5\Templates

Note: You should rename the existing DrawingTemplateV50.mdb file before doing this just in case you encounter problems.

This file should have been updated automatically when you upgraded to service pack 3. Not sure why it didn't happen. Is anyone else having this problem?

Best regards,

Randy

James McDowell

Hi Randy:

Thanks for the post, but for whatever reason I can't unzip the file. I am getting errors when I try to open it.

Reed Phillips

Try a different browser... I know it sounds stupid. But give it a try.

__________________
Reed Phillips

RandyB

Try this link. It has instructions as well as a different way to download. I should have thought of this earlier.

http://downloads.d-tools.com/si5/doc...ports_Fix.html

Also, if you still have problems, it is related to a browser issue as Reed mentions. Here is some information about this:

http://support.microsoft.com/kb/308090

- Randy