Creating Reports from SQL data

14 Aug 2006 2:46 PM

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

15 Aug 2006 3:13 AM

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.

15 Aug 2006 4:18 PM

Ryan

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

Show quoteHide quote

"Steven Cheng[MSFT]" <stch***@online.microsoft.com> wrote in message
news:lwGqNjBwGHA.1992@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.
>
>
>
>
>
>

16 Aug 2006 1:36 AM

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.