<div>
Sorry for the B grade but you don't get an A if I have to dig out the answer from a link. &nbsp;There is never the exact scenario.<br />
<br />
Thanks for the reply.<br />
<br />
Jerry
</div>


Sorry for the B grade but you don't get an A if I have to dig out the answer from a link.  There is never the exact scenario.

Thanks for the reply.

Jerry

<div>
Since it is against EE rules to copy and paste from a copyrighted source, pasting the link is the appropriate action.<br />
<br />
mlmcc
</div>


Since it is against EE rules to copy and paste from a copyrighted source, pasting the link is the appropriate action.

mlmcc

<div>
I just asked for information on how to do it. &nbsp;I wouldn't expect you to break EE rules.<br />
<br />
Sorry,<br />
Jerry
</div>


I just asked for information on how to do it.  I wouldn't expect you to break EE rules.

Sorry,
Jerry

<div>
<div class="content wysiwyg-content">
I have a dataset in my C# program. &nbsp;In the dataset there is a customer table adapter with a query called fillbyJournal. &nbsp;I would like to use this query as a datasource for a Crystal report. &nbsp;Currently is has a stored procedure as it datasource but I can't figure out how to keep it from asking for a password when I open it.<br />
<br />
Any help would be appreciated!!!<br />
<br />
Jerry
</div>
</div>


I have a dataset in my C# program.  In the dataset there is a customer table adapter with a query called fillbyJournal.  I would like to use this query as a datasource for a Crystal report.  Currently is has a stored procedure as it datasource but I can't figure out how to keep it from asking for a password when I open it.

Any help would be appreciated!!!

Jerry

Data source for a crystal report

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).