Hi William,
Thanks for the reply! I'm a beginner to VS.NET and Crystal Reports but I'm a
solid VB6 developer and also know SQL query (T-SQL).
If you could provide me step-by-step on how to define Query in "Crystal
Designer", I'd be very appreciate it!
Don
"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:eNT$PqhbEHA.2660@TK2MSFTNGP12.phx.gbl...[color=blue]
> Don:
>
> how familiar are you with crystal? I'm sure there are some samples but I
> don't know of any. I can walk you through it, but it'd help if I knew how
> familiar you are with it and how you want to connect. For isntance, are[/color]
you[color=blue]
> plannig on hitting the db directly or are you using a WS? And if it's on
> the web, what's your authentication type fo SQL Server? Are you using[/color]
Mixed[color=blue]
> mode or are you using Windows and then impersonating? the hardest part is
> going to be setting up the data source w/ security and then deploying it.
> Assuming you can get the datasource to connect, all you need to do is[/color]
start[color=blue]
> the wizard, then drag the tables you are going to use (table in this case
> unless you have other ones for heading info or something else) The wizard
> will walk you through all fo this and it's either the second to last tab[/color]
or[color=blue]
> the third to last tab, it will ask you if you want a chart. It's very
> similar to Excel. You can specify the Query in the Crystal Designer (or[/color]
you[color=blue]
> can use parameters - again it'd help if I knew your familialirity with it
> and how far you've gotten).
>
> I'll see if I can find a demo - I'm sure there's some on
>
www.crystaldecisions.com but if not, just let me know how much you need[/color]
help[color=blue]
> with ie your familiarity and I'll walk you through it.
>
>
>
> --
> W.G. Ryan MVP Windows - Embedded
>
> Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
> Let Microsoft know!
>
https://www.windowsembeddedeval.com/...ity/newsgroups
> "Don Wash" <don@wash.com> wrote in message
> news:uXglopgbEHA.1656@TK2MSFTNGP09.phx.gbl...[color=green]
> > Hi All!
> >
> > I've been searching everywhere for a simple sample of producing a bar[/color]
> graph[color=green]
> > using CrystalReport by specifying SQL Query, and I've found none of it![/color][/color]
I[color=blue][color=green]
> > find so many complex samples with so many features buried in the sample[/color]
> but[color=green]
> > all I want to know is a very simple thing, how to create bar charts with
> > CrystalReport in VS.NET using SQL Query.
> >
> > Could anyone provide me a sample showing how to produce a simple bar[/color][/color]
chart[color=blue][color=green]
> > using SQL Query in CrystalReports?
> >
> > Say I want this SQL Query:
> >
> > SELECT Count(AuthorID) FROM Authors GROUP BY AuthorGenre
> >
> > How do I use CrystalReport in VS.NET to produce a Bar Chart for this[/color]
> query?[color=green]
> > The nature of my application is a Web Application (i.e. ASP.NET).
> >
> > Many Thanks!!!
> >
> > Don
> >
> >[/color]
>
>[/color]
