Published Links - Recommended Reading

Wednesday, January 16, 2008

Creating HTML Help files using HTML Help

Overview

The post is based on the HTML Help version download here.

One way to spruce up hyperlinks in reports, in addition to using the opendocument object, is to link to a help file.

Creating help files with HTML Help is a tedious task, after the html content is written and plotted out, but the process of building a fully functioning help file is mostly automated. A few repetitions to gain familiarity with the interface will yield results both on your local as well as networked and internet folders.


The first iterations should rely on the wizard to create files. Read the intro pages in the help files. You need to bring in completed (or fairly complete) content in the form of .htm files before starting. This way, The boxes on the contents tab will populate correctly and navigational integrity can be maintained. Begin in small increments, first local, then on the network. The chum will use these shared files when published, so

access should be granted to the folder accordingly.


The compile is very specific for HTML Help when run on the network. You want to cycle through to a new help project, and let the wizard create all new files:

  • Project file

Select Existing html files in subfolder below main
Note: Make sure navigational integrity is programmed into .htm files before bringing them into the project

  • Contents file

Let the wizard create it, and leave 'automatically create' box unticked. Have the file name filled in.

  • Index file

This can be left out for the first iterations, to save time toward getting the first compilation. Fill in the file name, leaving 'Include Keywords' box unticked.

Be sure to maintain navigational integrity. The easiest way is to use two content .htm files in order to gain familiarity and obtain successful compiles.

Friday, December 28, 2007

Creating Templates In Crystal Reports With Guidelines

Crystal Reports - Using Boxes, Gridlines, Text and Wingdings.

Updated December 28, 2007

Preparatory

Configuration; _Report _Options Gridlines - .025
Create a text box .25 x .25. Type in the number '8' and format it using WingDing3.
This will emphasize the guidelines placement.
Note that guidelines, size and position, the object's size and position, and snap-to-gridline all work in concert to place the object fairly precisely. Guidelines can be double clicked, text objects can be aligned by utilizing the cross-braces (or whatever you might call the orange lines that reach to all margins.)

Overview

Create a formatting section in a report. Because it will be suppressed (or deleted after the report is finalized), it will not display. Use the 'shortcut menu - Size and Position' to set a series of 5 or 10 boxes at .25" intervals (mileage may vary) and then insert a series of text-boxes each with its left side docked to a gridline.
The text-boxes should be shorter and narrower than the boxes. Also note that boxes can be used to bound sections of data, while borders of text will bound one row value.

Environment

Having set the gridlines at .025, note that guidelines will snap more consistently.

Right click a report footer section and choose 'Insert Section Below' leave this footer Section unsuppressed for now.

Use this section to place the text-boxes, boxes, wingdings, and text that will assist with placement of guidelines.


Setting Guidelines

1. Create a box.
This will transition twice. At first, a thin .1 pt border will bound the box. You will want to remove the border when aligning the boxes. Set the border back to .1 pt before placing the text-boxes in the next step.

2. Place the text boxes (see 'Preparatory') on top of the box, with the same left alignment.

3. Set the guidelines using the left side of the text boxes.

4. Lock the size and position of the boxes when they are reasonably straight. Note that this locks them relative to the guidelines. Guidelines can be used to move these boxes more accurately after they have been placed.

4. Copy the series by painting from left top to lower right.

5. Select and Copy. Click on a place that is visibly in alignment with one of the guidelines.


Finalization


Return the environment to where it was prior to starting.
Suppress the report footer section added in the first step.

Wednesday, December 26, 2007

Thursday, October 11, 2007

Tuesday, October 9, 2007

Similarities between TeraData and SQL Server

There are actually similarities between SQL Server and TeraData beyond the ANSI SQL overlap. When moving from SQL Server to Teradata, from a Development standpoint, there is similar functionality.

In general terms these functions are:

Sunday, October 7, 2007

There is an excellent blog on the topic of Web 2.0, http://feeds.feedburner.com/Web20Blog