473,387 Members | 1,353 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Creating Reports from SQL data

I'm trying to create a report (similar to access) in VB 2005. It appears
that Crystal Reports is the recommended method. I created a Crystal Report,
set up the data connection (using the Wizard -selected from an existing
project datasource which, by the way, works fine on my Datagrids). The
report preview, however, outputs absolute junk. The FirstName field
populates with colors (Green, Silver, Fuchsia, etc), the LastName field
populates with days of the week (Tuesday, Saturday, etc.), the Unit field
populates with datatypes (Time, Boolean, Date, etc).. you get the idea.
Absolutely useless data and I don't know where it's coming from. What am I
doing wrong???

Thanks,
Ryan
Aug 14 '06 #1
4 2914
Hello Ryan,

I'm not quite familar with Crystal Report components. Here is a web article
introducing using Crystal.NET for Visual studio 2005, you may have a look
to see whether it helps. Also, as for the Crystal Report specific issue, we
would recommend you contact crystal related support community or center:

http://support.microsoft.com/kb/317789/

BTW, have you made the final decision on using crystal report as the report
displaying approach? In VS 2005/.NET 2.0, there has provided a new
ReportViewer managed control(for both winform and ASP.NET ). We can
create client report(like reports in SQL Server reporting service)
completely in Visual Studio 2005 and connect to various backend datasources
(include SQL SERVER, xml ..... ). You can also have a look at the
following MSDN reference about ReportViewer and client reports if you have
interests:
#ReportViewer Web Server and Windows Forms Controls
http://msdn2.microsoft.com/en-us/library/ms251771.aspx

#ReportViewer Control in Visual Studio 2005
http://www.gotreportviewer.com/
Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.


Aug 15 '06 #2
Thanks for the advice. I'll have to look into Report Viewer, been having a
hard time with Crystal Reports.

"Steven Cheng[MSFT]" <st*****@online.microsoft.comwrote in message
news:lw**************@TK2MSFTNGXA01.phx.gbl...
Hello Ryan,

I'm not quite familar with Crystal Report components. Here is a web
article
introducing using Crystal.NET for Visual studio 2005, you may have a look
to see whether it helps. Also, as for the Crystal Report specific issue,
we
would recommend you contact crystal related support community or center:

http://support.microsoft.com/kb/317789/

BTW, have you made the final decision on using crystal report as the
report
displaying approach? In VS 2005/.NET 2.0, there has provided a new
ReportViewer managed control(for both winform and ASP.NET ). We can
create client report(like reports in SQL Server reporting service)
completely in Visual Studio 2005 and connect to various backend
datasources
(include SQL SERVER, xml ..... ). You can also have a look at the
following MSDN reference about ReportViewer and client reports if you have
interests:
#ReportViewer Web Server and Windows Forms Controls
http://msdn2.microsoft.com/en-us/library/ms251771.aspx

#ReportViewer Control in Visual Studio 2005
http://www.gotreportviewer.com/
Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no
rights.


Aug 15 '06 #3
Thanks for the reply Ryan,

If you meet any difficulties or have questions about client report
designing, you can also post in some SQL server reporting service specific
newsgroups like:

microsoft.public.sqlserver.reportingsvcs

since reportviewer client report's designing is quite similar to reportting
service server report designing.

Please feel free to let me know if there is any other information you
wonder.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Aug 16 '06 #4
you should use Access Data Projects for reporting; Reporting Services
isn't ready for primetime.
And Crystal?

What a waste of time... I mean-- do we REALLY need to be sold on a new
middle ware component? Do we REALLY have to speak with a Business
Objects salesperson?

-Aaron
Steven Cheng[MSFT] wrote:
Thanks for the reply Ryan,

If you meet any difficulties or have questions about client report
designing, you can also post in some SQL server reporting service specific
newsgroups like:

microsoft.public.sqlserver.reportingsvcs

since reportviewer client report's designing is quite similar to reportting
service server report designing.

Please feel free to let me know if there is any other information you
wonder.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
Aug 17 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: longtim | last post by:
I have been having endless difficulty creating reports/queries that set any relevent parameters from controls in forms. I am creating an application under access 2003 but will target access...
5
by: Mike | last post by:
I am writing a .NET application in C# that uses Crystal Reports. I want the crystal reports to grab information from a database no matter where the database is located. To do this, I want to...
2
by: Joe_Black | last post by:
Hi all, I want to create an MDI app that allows reporting on XML data files downloaded from the equipment that we manufacture, this MDI app will have several default reports but due to the...
3
by: Przemo | last post by:
Hi, I have an ASP.NET 2.0 application. I need to generate some documents (reports) like invoices, orders, etc. Users need them to preview and print. Which of methods is the best for doing it:...
2
by: Dennis D. | last post by:
Hello: Creating Windows Forms Applications with VB.net: What are my options for creating properly formatted printable business reports using 2005 Express Edition? Particularly, would like to...
3
by: Tyranno.Lex | last post by:
I am using Visual Studio .NET 2003 and have successfully deployed a commercial web application written in C# and ASP.NET. I am now wanting to add reporting using Crystal Reports and am having a...
3
by: erick-flores | last post by:
Hello all I am creating an Expense Report. There are to types of expenses: Company expenses and Reimb Expeneses. The company expenses is under "Expense Details Co" table and Reimb Expenses is...
3
by: Andy Baker | last post by:
I have a utility that captures a signature on a handheld device and stores it as as string containing a series of points. I want to recreate this signature as a bmp file using VB.NET code. To do...
4
by: sklett | last post by:
I've developed an ERP application that we use internally and works quite well. I receiving more and more requests from users to print various transactions, order forms, search results, etc. I...
3
by: Paulo | last post by:
Hi, how can I create web reports? I need to create grouping, subtotals, totals, etc... Must I use gridview? Generating <tableand <tris the best solution? Using asp.net C# 2.0 Thanks
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.