Need help with report writing

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
Mon Jan 28 15:47:31 CST 2008

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_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.

--
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"The Mad Ape" <chiefape@gmail.com> wrote in message
news:d2921e26-8ed9-45cd-ad74-78d23d35c990@e25g2000prg.googlegroups.com...
> 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

The
Mon Jan 28 16:15:46 CST 2008

On Jan 28, 5:47 pm, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> 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.
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>

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



> "The Mad Ape" <chief...@gmail.com> wrote in messagenews:d2921e26-8ed9-45cd-ad74-78d23d35c990@e25g2000prg.googlegroups.com...
>
> > 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

William
Tue Jan 29 11:51:23 CST 2008

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)
____________________________________________________________________________________________
"The Mad Ape" <chiefape@gmail.com> wrote in message
news:d2921e26-8ed9-45cd-ad74-78d23d35c990@e25g2000prg.googlegroups.com...
> 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