C# Crystal Reports Question

How do you use a stored procedure as the datasource for a report in Crystal
Reports .NET for C#?

Nov 15 '05 #1

1275

Hi Ed,

You should see a list of SP in the datasource dialog of the database
expert, here is a fragment from
http://www.crystalreportsbook.com/Chapter14.asp

To select the data source from the Database Expert dialog, click on the
proper category node to expand it. This automatically pops up a dialog box
asking you for information about the data source. The dialog changes to
match what is needed for each data source. This information could be
anything from a simple file path to a database server name and the
appropriate logon credentials. After you enter the information the dialog
box closes and the data source name is shown in the Database Expert and?
listed under its category. Under the data source name is the list of
available tables, views and stored procedures.[1] Click on the plus sign
next to each one to expand the list.

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Ed Crowley" <cu******@pacbe ll.net> wrote in message
news:Or******** ******@TK2MSFTN GP11.phx.gbl...

How do you use a stored procedure as the datasource for a report in Crystal Reports .NET for C#?

Nov 15 '05 #2

Ed Crowley

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us > wrote
in message news:Od******** ******@TK2MSFTN GP12.phx.gbl...

Hi Ed,

You should see a list of SP in the datasource dialog of the database
expert, here is a fragment from
http://www.crystalreportsbook.com/Chapter14.asp

To select the data source from the Database Expert dialog, click on the
proper category node to expand it. This automatically pops up a dialog box
asking you for information about the data source. The dialog changes to
match what is needed for each data source. This information could be
anything from a simple file path to a database server name and the
appropriate logon credentials. After you enter the information the dialog
box closes and the data source name is shown in the Database Expert and?
listed under its category. Under the data source name is the list of
available tables, views and stored procedures.[1] Click on the plus sign
next to each one to expand the list.

Cheers. That checkbox should be checked by default IMO!

Nov 15 '05 #3

Similar topics

5995

Using Crystal Reports 8.5 with .Net

by: rAGHU | last post by:

Hi, In my ASP.NET web application project we need to design crystal reports with Crystal Reports version 8.5 enterpraise edition(Please Note:It is not the Crystal Reports that comes with VisualStudio.NET). Also the Crsyatl Report software 8.5 version will not be installed in the IIS web server which is hosting my ASP.NET web application. It will be installed in a different server which has .net and IIS 5.0.

.NET Framework

19187

Crystal Report unbound fields

by: Stephan | last post by:

Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal Report at runtime? Example: private void button1_Click(object sender,

.NET Framework

6572

Crystal Report Viewer Issue

by: Ashish Shridharan | last post by:

Hi All, I'm not very sure if this is the forum for my question but i was hoping someone could direct me to the right place (or answer my question). I am using the .NET crystal report viewer to display reports (crystal reports) in HTML in my web application. My client's requirements are that the reports need to be viewable on Netscape, Mozilla and IE. However, in Netscape

.NET Framework

3355

Crystal Reports BUG

by: Phil | last post by:

There's a Crystal Reports hot fix for a particular but that I am experiencing in .NET -- DIV's get screwed up when you embed a Crystal Report in a web page. The bug is ADAPT00170558, the patch is 35395142. There's absolutely no documentation on a work-around, and the patch from CR is for version 9 only, not for .NET. Anyone know how to fix this aweful problem? Phil

.NET Framework

17554

RUN Crystal Reports in MS ACCESS

by: Joriz | last post by:

Obviously im new with ms access..so my basic question is how do i run crystal reports in my ADP. I also pass parameters to cyrstal reports. Please help! thanks in advance

Microsoft Access / VBA

2205

Opinion needed: Crystal Reports vs. anything else vs. One's own implementation

by: LP | last post by:

Hi, I will be taking on a new project developing a web-based "reporting system". The first requirement I got from BI group is "we just want to look at the data". Basically, there is a huge database, and they want certain people to be able to drill down to the data they want, perhaps a few graphs here and there, and then extract selected data to an Excel file or a flat file for further analysis. As of now there are a handful of parameters...

C# / C Sharp

3882

Crystal Reports Cascading parameters don't get preserved between postbacks

by: LP | last post by:

I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set ReuseParameterValuesOnRefresh="True" in a viewer, but it still doesn't work. Did anyone run into this problem. What's the solution? Please help. Thank you

ASP.NET

8453

crystal reports unreleased connections

by: Peter Proost | last post by:

Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're using crystal reports 9 and vb.net and we're using the crystalrepotViewer to show our reports. But every time we open a report the connection to or sql server remains, so if I open 5 forms with the report viewer I've got 5 sleeping connections in...

Visual Basic .NET

2404

VS .net 2005 Crystal Reports can run on Crystal Reports XI?

by: Jay | last post by:

I am getting mixed messages from the asp.net website hosting providers - some say they do not support Crystal Reports due to a $25,000 per cpu licensing fee, others say all I need to do is install Crystal Reports XI (about $500) on a dedicated server and it will run fine. Will Reports developed with the embeded Crystal Reports in VS 2005 run in a Crystal Reports XI environment? -- Thanks

.NET Framework

2200

Crystal Reports and custom objects question

by: =?Utf-8?B?VGVycnk=?= | last post by:

I am brand new to using Crystal Reports and am trying to generate a report based on a custom object - in another project. I have a layered design, with all my business objects in a seperate project. I created a new project as part of the solution, added a reference to the project containing my business objects, created a datasource that points to one of the objects and then tried to create CR based on the object. The data tab (in the CR...

Visual Basic .NET

9680

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9528

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10455

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10173

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10006

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9052

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7547

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5573

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2925

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General