tags:

views:

890

answers:

2
Q: 

Crystal Reports doesn't show any data

So I'm using this SQL Server with my application and I decided to display crystal reports to the user. I'm not at all experienced with crystal reports, but this project gives me a good opportunity to learn.

Now, my data sources are already setup and i've been using them with for the past several months with this project. However, when I create a report using Crystal Report's wizard and I include data, I get no data output. I get the labels, but no actual data from the database. When I go to report's preview I see an example and it looks right, however no data is displayed.

I also tried creating a graph, but that didn't even show up.

+2  A: 

Are you linking tables? In my experience 99% of the time when I get no data with Crystal it's been because of a funky link. Also check what part of the report (Header, details, etc.) the object is in.

 2009-05-12 15:17:16
What do you mean? There's a foreign key between two of the tables I'm trying to display, but even when I'm only displaying one table, nothing is shown.
Malfist  2009-05-12 15:19:38
BTW, you can edit your question, even if you can't add a comment
Malfist  2009-05-12 15:23:08
Check the links in Crystal Reports datasource (not SQL server)
Brian Ensink  2009-05-12 15:30:58
There's one valid link which is a left join on a foreign key
Malfist  2009-05-12 15:33:24
Ah, got it working, had to add every table instead of just the two tables.
Malfist  2009-05-12 16:17:26
A: 

I sometimes hit trouble because I need a left join when the default is an inner join.

paulmorriss  2009-05-14 16:26:43

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?