How do I use a SQL query as my report datasource instead of just picking the tables in the database expert?

A colleague of mine has been creating our reports for our application and so far he's been just selecting the tables and setting up the relationships using the database expert (I think).  We need to change this so that we can filter the data so we're only reporting on a single account instead of every record in the database.

What do I need to change to accomplish this? Can it be done in the report or will I need to create a data source of some kind in the application and pass it into the report somehow?
We're new to Crystal Reports so this may be a simple answer. Thanks!
0
kenp2600
9/29/2004 3:36:35 AM
asp.net.crystal-reports 7043 articles. 0 followers. Follow

2 Replies
927 Views

Similar Articles

[PageSpeed] 35
Get it on Google Play
Get it on Apple App Store

You can pass parameters into the report such as the key to the line that you want and you use this to filter the report. There is articles on www.aspalliance.com/crystal on how to do this, but I suggest you buy the book at www.crystalreportsbook.com as it provides detailed walkthroughs.

Ryan
0
RyanSmith
9/29/2004 5:44:58 AM
What you probably want to do is use an ADO.NET dataset, and "push" the data to your report.  We have soem good articles at Crystal Alliance (http://aspalliance.com/crystal).  The one that got me started was from Business Objects:

Reporting Off ADO.NET Datasets
http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf
Ryan's right--get the book from www.crystalreportsbook.com (also available through Amazon--click through to my blog for a link, I can't remember the URL).
If my post is your answer, please mark it as the answer. It will bring good karma.

Crystal Alliance
My Blog
Florist Blogs
0
rjdudley
9/29/2004 12:59:22 PM
Reply:

Similar Artilces:

Converting Crystal Reports 9 report to Crystal Reports .NET report
I have a web page that is supposed to display a crystal report.  The report is fully written and functional in crystal 9 (non-.Net)  .  Is there a way to convert my .rpt so that I can just include it in the new web site? why you don't try to compile project with .net and include your report. then if crystal report is power tool will suggests you with conversation tool    My blog is here.Please remember to 'Mark as Answer' if this post answered your question! Wow it really was that easy!  I just added the old crystal report into my .NET proj...

retrieving crystal report graph images instead of using crystal report viewer
is it possible to retrieve the crystal report graph images without using the crystal report viewer.  ...

crystal reports .net -> crystal reports .net 2003
recently converted a project from .net to .net 2003. The 2 crystal reports I had in the project do not load when executing the application. The project itself within 2003 will allow me to multiplat the crystal reports, however when it comes to execution time I get the error: Invalid Data Source. If this isn't the right forum please point me to the right one as this is really the only website I know of with a large reader base. >to multiplat the crystal reports To what the crystal reports? Do you have the same database connections established and verified in your 2003 s...

"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.  Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni    You will need to use the SQL Server ...

View report from the crystal report server using .NET
Hi,I am first time dealing with crystal report and I having problem with it. I need to use asp.net to link to the crystal report server and view the report, but don't know how? Is there a way to do that? or is there any better way to using .net and view report from the crystal report server?Thanks....

use crystal report or reporting service in SQL 2005?
I used Crystal report .NET for a couple of years but do not really like it. Now, reporting service is available in SQL 2005. Someone can give me suggestion: use crystal report or reporting service in SQL 2005? Or use another product from third party?...

Bind crystal reports / sql reports to ADO.NET
Hi,  I'm a beginner trying to find out if it's possible to directly connect an sql report/crystal report to an ADO.NET data set?   It all depends on what version of Visual studio you are using. Here are the steps for VS2005 In VS2005 you need to do the following: 1) Right click on your solution and select add, New Item. 2) Add a dataset and create your queries in the dataset. Make sure you save this dataset or it will not show up later. 3) Add your reportviewer 4) Right click on your solution and select add new Item Again and then add a crystal report 5) In the cr...

Creating Reports using Crystal Reports for Visual Studio .NET
Hi i am trying to create a crystal report using C# coding but instead of creating a web application under new project i decided to choose create an asp.net website with C#. The problem is i get:- The report you requested requires further information. --------------------------------------------------------------------------------XP\SQLEXPRESS  Server name:    Database name:    User name:    Password:    All data is present except my password when i enter it, it works fine and the report works too with no problems. How do i ...

.NET 2.0 Reporting Module using SQL Server Reporting Services
Hello Everyone,I have created a generic module using ASP.NET 2.0, MS SQL Server 2005 and SQL Server 2005 Reporting Services. This module is intended to provide a generic user interface for selecting and generating reports. You can configure its respective table for your fixed or flexible parameters for each report. It also supports end user access level security for each report and report group which is generally required for any basic reporting module.You can view reports in two different styles:-- Drop down--Tree View And You can view your report in 3 supported formats.  This is an in...

how to make printable reports without Crystal reports and SQL Reporting service
Hi guys I need printable reports in a web app , these reports must be colorful and well  formatted  ( header and footer ,lines around the page&…)  the problem is because of the hosting situation unfortunately  I cannot use neither of Crystal reports  and SQL Reporting service  also  we cannot use extra components  -that costs money for us- like PDF Creators .  I've thought of two possible solutions. 1st   I can do that in an HTML format   2nd  it is possible to  produce Images .  Creating Image is extreme...

How to use ADO.NET as datasource in standard report expert
I'm learning how to use ADO.NET as datasource for Crystal Reports. I'm using VS.net professional against SQL2000. Under Data tab in standard report expert, I see ADO.NET(XML) and wonder what to do from here to push data from a stored procedure. Please provide instructions or links. Thanks.Please mark the post(s) that have helped you as "Answer" This article will help: http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdfIf my post is your answer, please mark it as the answer. It will bring good karma.Crystal AllianceM...

How to create Report Letter with multiple pages in C# and Crystal Report.Net using VS2008
Hi experts, I’d like to have some helps from you guys. I need to create an app with C# and Crystal Report.Net using VS 2008 for a Landscape & Nursery company.  The company will send out coupon letters to some customers who purchased something from the company within past 12 months. Users will get customers’ info from database using zip code. I have a drop-down control to populate all the eligible zip codes. The following 8 data fields will be retrieved from database; FirstName, LastName, Address1, Address2, City, State, ZipCode, and PreviousPurchased. I have a pre-defined Crystal R...

How do I deploy an application using crystal reports/install crystal reports?
First of all: C# .NET framework 1.1, IIS 6.0, XP SP1, Windows forms - not ASP.NET but I don't see how it would make a differenceMy Situation: I am tasked with adding to an application the ability to generate a crystal report.  It currently has nothing to do with them.The application runs on an XP system with .NET 1.1 installed but lord only knows how it was installed on there (the guy that set it up is long gone and from past experience with his work I think he was just guessing anyways) In an attempt to see if crystal reports was installed, I wrote a quick test forms appl...

how to create crystal report using VB.NET with the database of ACCESS
hi..! i want to create crystal report of my project.em using access database...!   but i have no idea how to create reports using VB.NET with the access db  i create the report but it shows only one record  hi ......You can do it PUSH method of creating crystal reports...!!!!! In push method Typed Dataset is used as the data sourcefor crystal report...!!!Steps for creating the report could be.....1. add a typed dataset to your solution.2.go to server explorer.3.connect your access file to your server explorer. 4.Change data base.. 5.attach access file..!!6.test ...

Web resources about - How do I use a SQL query as my report datasource instead of just picking the tables in the database expert? - asp.net.crystal-reports

Datasource - Wikipedia, the free encyclopedia
A DataSource object has properties that can be modified when necessary. For example, if the data source is moved to a different server, the property ...

Inverness Graham Acquires DataSource
Inverness Graham , a lower middle market private equity firm headquartered in suburban Philadelphia, has acquired DataSource , a print supply ...

SmartGlance for iPad for iPad on the iTunes App Store
Read reviews, get customer ratings, see screenshots, and learn more about SmartGlance for iPad on the App Store. Download SmartGlance for iPad ...

Chaitanya Pandit (@chaitanyapandit) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Data source - Wikipedia, the free encyclopedia
... Data source A data source is any of the following types of sources for (mostly) digitized data: a database in the Java software platform, datasource ...

2ndQuadrant - PostgreSQL expertise from specialists with a source code level understanding of RDBMS ...
PostgreSQL expertise from specialists with a source code level understanding of RDBMS PostgreSQL Planets Gabriele’s PlanetPostgreSQL Gianni’s ...

Tagged entries for CLOUD COMPUTING
Alan Williamson's output as a Java Champion, Blog-City Architect, BlueDragon Creator, Author, Speaker and Internet Guru

Private equity deals
... of biometric identity management systems, applications and services. www.crossmatch.com Inverness Graham Investment has acquired DataSource ...

C# C Sharp and Tutorials on C# Friends.com
Learn the c# langauge to build web applications using our online tutorials with live demos. Participate in our forums and learn from others. ...

JavaScript UI Library, Ajax Components & HTML5 Framework - DHTMLX
DHTMLX offers a rich JavaScript library, UI components & HTML5 mobile framework. Build impressive web apps for both desktop and mobile devices. ...

Resources last updated: 12/3/2015 8:52:32 AM