Ranjana,
 
I have Reporting Server without CUIS. Where can I find some sample Crystal Reports templates to create reports? Are they online somewhere or on the Reporting Server?
 
Also, what tools does one need to view the Informix DB tables (if I don't want to use Dbaccess)? Do I need the Informix Client SDK from the IBM web site? Does this include the Informix tools referred to in the Reporting Guide?
 
Thanks, Janine
<!--[if gte mso 9]><xml>
<w:WordDocument>
<wiew>Normal</wiew>
<w:Zoom>0</w:Zoom>
<wunctuationKerning />
<walidateAgainstSchemas />
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables />
<w:SnapToGridInCell />
<w:WrapTextWithPunct />
<w:UseAsianBreakRules />
<wontGrowAutofit />
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><!--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><!-->
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language0400;
mso-fareast-language0400;
mso-bidi-language0400;}
</style>
<!-->

Forgot one more critical detail, you have to tell the VXML servers what to report on.  By default only CVP Subdialog Starts and CVP subdialog returns are reported.  If you use regular Subdialog Starts and returns you won't see anything.  You have to tell the VXML servers in CVP OAMP what else you want to report on.  Go into CVP OAMP, select the VXML Server, configure, and enable reporting, number of days, etc.  There is a place for Inclusion mask, I wanted everything to start so I entered *.*.*.* but you can put all kinds of stuff in the mask, refer to the CVP reporting guide for examples.

 
dbaccess is shipped with the Informix engine and can be found at %INFORMIXDIR%\bin.  That should be in your path, just open a command window and type "dbaccess".  Dbaccess dates back to the "green-screen" days, it has a character based interface.  However, there is no additional setup required - it connects directly.  Documentation for dbaccess can be found at http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.dba.doc/dba.htm
 
Any tool which can talk to an ODBC driver will allow you to access the database, the previous suggestion about downloading the IBM SDK kit was valid.  A popular choice around here is Squirrel ( http://squirrel-sql.sourceforge.net/ ).  An effective tool although it is not totally familiar with Informix syntax and can occasionally complain about it.
 
Regards,
Jack Parker