Creating Reports from SQL data

[Ryan]

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

[Steven Cheng[MSFT]]

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.

[Ryan]

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.

[Steven Cheng[MSFT]]

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.

[aaron.kempf]

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.