<div>
<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25314" rel="ugc">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25314</a>
</div>


<div>
Please explain your selection of that comment as the answer.<br />
<br />
I followed the link and I don't see an answer at that site or any of the linked sites.<br />
<br />
mlmcc
</div>


<div>
I checked with the Network Administrator. &nbsp;We came up with an alternative solution.<br />
<br />
Thanks<br />
<br />
Glen
</div>


<div>
What was the alternative solution? &nbsp;Did it include changing permissions to SPs?<br />
<br />
mlmcc
</div>


<div>
I copied the SP's with a name that would put them at the top of the list.<br />
<br />
My network administrator has limited knowledge regarding SQL Server.
</div>


<div>
Sorry I have left this open so long.<br />
<br />
I do not remember the exact nature of the question. &nbsp;I no longer work for the client.<br />
<br />
Thank you for your efforts.<br />
<br />
The questions can be deleted
</div>


<div>
<div class="content wysiwyg-content">
I am attempting to connect to a SQL 2008 R2 database with over 300 stored procedures in its DBO to my Crystal Reports.<br />
<br />
When I create a connection to the 'db' I only get a portion of the SP's listed.<br />
<br />
Does Crystal have a limit on the # of SP's it will connect to? &nbsp;How can I get my Crystal Reports to read in the desired SP's?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


I am attempting to connect to a SQL 2008 R2 database with over 300 stored procedures in its DBO to my Crystal Reports.

When I create a connection to the 'db' I only get a portion of the SP's listed.

Does Crystal have a limit on the # of SP's it will connect to?  How can I get my Crystal Reports to read in the desired SP's?

Thanks

Glen

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25314

Please explain your selection of that comment as the answer.

I followed the link and I don&#39;t see an answer at that site or any of the linked sites.

mlmcc

I checked with the Network Administrator.  We came up with an alternative solution.

Thanks

Glen

What was the alternative solution?  Did it include changing permissions to SPs?

mlmcc

I copied the SP&#39;s with a name that would put them at the top of the list.

My network administrator has limited knowledge regarding SQL Server.

Sorry I have left this open so long.

I do not remember the exact nature of the question.  I no longer work for the client.

Thank you for your efforts.

The questions can be deleted

Is there a limit on the # of Sotred Procedures that Crystal Reports can connect to

I am attempting to connect to a SQL 2008 R2 database with over 300 stored procedures in its DBO to my Crystal Reports.

When I create a connection to the &#39;db&#39; I only get a portion of the SP&#39;s listed.

Does Crystal have a limit on the # of SP&#39;s it will connect to?  How can I get my Crystal Reports to read in the desired SP&#39;s?

Thanks

Glen

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Productivity software is application software dedicated to producing information, such as documents, presentations, worksheets, databases, charts, graphs, digital paintings, electronic music and digital video. Most common programs and suites such as Microsoft Office and LibreOffice have their own topics. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software, but they can include communications software, personal information managers, groupware and log analysis software.