Gilgamesh Solutions. ColdFusion Tags: DynamicPDF DynamicMS

DynamicMS 2.0

Purchase it

Description

NEW: DynamicMSS 1.0 is now available as a web service.

NEW: If you would like to use DynamicMS 2.0 to generate documents that include paragraphs and text, other than tables, or even multiple tables, ask for our customization option. Send us an email to support@gilgamesh-solutions.com with the features you would like to see added to DynamicMS 2.0, and we will build the tag that is right for you.

Using DynamicMS 2.0, you can generate Microsoft Word/Excel/PowerPoint reports to represent your data from a database. All you have to do is send a query name to this tag with formatting options on how you want your data to be laid out, and you will see your generated file in the format you asked for. Then, your file will be embedded into your browser which will give you the opportunity to save the file to your server or just leave it on the browser. You can also now include optional introductory and ending paragraphs formatted using HTML.

The new powers of DynamicMS 2.0 give you the following capabilities:

You can send a query to this tag, and you can choose the headers to display in your generated file. The tag will display your data in a nice format.
You can add an introductory paragraph (before the table), and an ending paragraph (after the table) . Your paragraphs can carry HTML tags for formatting!
You can now add images to your generated documents!
Creating a table in the destination file using a custom border thickness and color.
You can control the formatting of your Date data.
You can control the font size, font type, font color of the headers, and of the data in the table.
You can control cellpadding, cellspacing.
You can choose alternating colors for your alternating table rows.
You can choose a background color for the headers and for the data in your table.
You can control the width of columns in the generated file.
You can format your output in the generated file using bolding, italic, and underlining.
You can align your text horizontally and vertically.
All the above options can be applied to the headers, and actual data separately.

This great flexibility and control from your ColdFusion application add a new power to your generated framework.

Example Usage          Purchase it

<cf_DynamicMS
   Type="Word"
   Query="get"
   Headers="ip: IP Address, referrer:Referring Page, current_page:Current Page, entrydate: Date Created"
   DDateFormat="mm/dd/yyyy"
   DataBgColor="lightblue, white"

   Beginning ="<center><h3>Gilgamesh Solutions, Inc.</h3></center>
      <table width='100%'>
      <tr><td align='left'>
      <a href='http://gilgamesh-solutions.com/'>
        <img src='http://gilgamesh-solutions.com/lion.png' width='100' height='75' border='0'>
      </a>
      </td><td align='right'>
      <a href='http://gilgamesh-solutions.com/'>
        <img src='http://gilgamesh-solutions.com/lion.png' width='100' height='75' border='0'>
      </a>
      </td></tr></table>"

   Ending=" <strong><center>Gilgamesh Solutions Inc. All Rights Reserved 2001-2004</center> </strong>">

The example above will generate a Word document with an introductory paragraph centered H3 format in the top of the page with the text "Gilgamesh Solutions, Inc." Then, a table will follow with two images, one left justified, and the other right justified. Both images will be clickable to point to http://gilgamesh-solutions.com. After that, another table will follow with the following column headers: IP Address, Referring Page, Current Page, Date Created. The first part of each column header will be the actual column header from the database table, while the other part after the ":" will represent the alias to be printed out to the document. Anytime Date field printed out to the document will be formatted using the mask "mm/dd/yyyy" as in DateFormat function. "Query" will be the query carrying all the data after pulling it from the database. An ending paragraph with the text "Gilgamesh Solutions Inc. All Rights Reserved 2001-2004" will be bolded and centered following the table in the generated document. The data will be presented in an alternating lightblue and white rows.

You can view the document here.

Optional Features          Purchase it

Upon request, the following features could be added to DynamicMS 2.0:

1. Multiple tables.
2. Multiple Paragraphs (in between tables).
3. Database querying (instead of sending query directly) with filtering options (using WHERE keyword in SQL)!
4. Others.

Just send us an email to support@gilgamesh-solutions.com, and tell us what your requirements are.

If you would like the same features in DynamicMS 2.0 plus:

1. Query attribute is optional.
2. You want to save the file to the server instead of embedding it in the browser.
3. You want to generate Text and HTML files as well as Word/Excel/PowerPoint files.

Then you want to check out DynamicMSS 1.0

Syntax Usage          Purchase it

<cf_DynamicMS
   Query="your query here"
   Headers="column name list"
   Beginning="an optional beginning paragraph or multiple paragraphs formated using HTML to be displayed before the table"
   Ending="an optional ending paragraph or multiple paragraphs formated using HTML to be displayed after the table"
   DDateFormat="works as DateFormat. Send the date mask to format your Date outputs"
   Type="Excel|Word|Powerpoint"
   ColumnWidth="width of all columns"
   HeaderBold="y|n"
   HeaderItalic="y|n"
   HeaderUnderline="y|n"
   HeaderColor="any valid HTML color by name or hexidecimal (no leading #)"
   HeaderBgColor="any valid HTML color by name or hexidecimal (no leading #)"
   HeaderFontFamily="Any HTML valid font family (Arial, etc.)"
   HeaderSize="header size (not font size, this is equivalent to <font size='+[num]'>"
   HeaderAlign="left|center|right"
   HeaderVAlign="top|center|bottom"
   DataBold="y|n"
   DataItalic="y|n"
   DataUnderline="y|n"
   DataColor="any valid HTML color by name or hexidecimal (no leading #)"
   DataBgColor="any valid HTML color by name or hexidecimal (no leading #). You can apply alternating colors"
   DataFontFamily="Any HTML valid font family (Arial, etc.)"
   DataSize="data size (not font size, this is equivalent to <font size='+[num]'>"
   DataAlign="left|center|right"
   DataVAlign="top|center|bottom"
   Border="[number] thickness of the border around the data"
   BorderColor="border color"
   CellPadding="equivalent to <table cellpadding=' '>"
   CellSpacing="equivalent to <table cellspacing=' '>"

>