By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,282 Members | 1,587 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,282 IT Pros & Developers. It's quick & easy.

Creating Reports from SQL data

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.