Need help with report writing

[The Mad Ape]

Hello

I am using VB.Net 2005 CF and SQL Compact 2005 on my desktop. I have
sdf databases and I need to generate reports from them. I spent all
weekend trying to find software, tutorials, anything that would help
me generate paper reports from this type of database. I can not find
anything.

I would appreciate links to tutorials and good 3rd party tools because
everything I find is out of date or simply does not apply.

If anyone has an example to post that would be nice too. None of my
data is bound to any form. They are all created programatically and I
am constantly opening and closing different ones from within the same
application.

You help is appreciated.

Regards

The Mad Ape
www.tatumba.com

 

[Ginny Caughey [MVP]]

Mad Ape,

Perhaps this article describing how to use datasets with SQL Server
Reporting Services:
http://www.devx.com/dbzone/Article/31336

And here's information about using Crystal Reports with ADO.Net datasets:
http://support.businessobjects.com/...papers/rtm_reportingoffadonetdatasets.pdf.asp

Of coure both of these solutions would be desktop-based and not
device-based. For on-device reports, I just generate reports
programmatically and print it to a serial or bluetooth printer. Typically
these reports are pretty simple: they use SQL syntax to select the data,
then walk through it with a DataReader printing it as it's read.

 

[The Mad Ape]

Mad Ape,

Perhaps this article describing how to use datasets with SQL Server
Reporting Services:http://www.devx.com/dbzone/Article/31336

And here's information about using Crystal Reports with ADO.Net datasets:http://support.businessobjects.com/communitycs/technicalpapers/rtm_re...

Of coure both of these solutions would be desktop-based and not
device-based. For on-device reports, I just generate reports
programmatically and print it to a serial or bluetooth printer. Typically
these reports are pretty simple: they use SQL syntax to select the data,
then walk through it with a DataReader printing it as it's read.

Hi again Ginny

Thanks for the links. I will explore them this evening. I am only
going to need reporting services on the desktop.

Again, as always, your help is appreciated.

Thanks

The Mad Ape
www.tatumba.com

 

[William Vaughn]

The ReportViewer control (which does not need Reporting Services) can do the
job quite nicely. See http://www.developer.com/db/article.php/3716691
I also wrote a long chapter about this control in my 7th edition.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________