Filtering data in CR

[TS]

Hi all,
In my windows form, I need the user to select a client name from a combo box
and click on a button that opens another form having CRViewer showing the
data for that client selected.
I connected to the SQL database where the cbo box gets the clients names
from and I can see the names in cbo box. I created my CR and put the CRViewer
on another windows form. What's next? I need help with the code.
Thanks in advance
--
TS

[Bernie Yaeger]

Hi TS,

There are several ways to do this. Perhaps the most straightforward would
be to pass a parameter to the report and set the report's record selection
criteria to include only the client names who match the parameter.

HTH,

Bernie Yaeger

"TS" <[e-mail]> wrote in message
news:68**********************************@microsof t.com...

Hi all,
In my windows form, I need the user to select a client name from a combo
box
and click on a button that opens another form having CRViewer showing the
data for that client selected.
I connected to the SQL database where the cbo box gets the clients names
from and I can see the names in cbo box. I created my CR and put the
CRViewer
on another windows form. What's next? I need help with the code.
Thanks in advance
--
TS

[TS]

Thanks for your response. Can you tell me how the code for this looks like.
Or do you know of any white papers that can help with that.

"Bernie Yaeger" wrote:

Hi TS,

There are several ways to do this. Perhaps the most straightforward would
be to pass a parameter to the report and set the report's record selection
criteria to include only the client names who match the parameter.

HTH,

Bernie Yaeger

"TS" <[e-mail]> wrote in message
news:68**********************************@microsof t.com...

Hi all,
In my windows form, I need the user to select a client name from a combo
box
and click on a button that opens another form having CRViewer showing the
data for that client selected.
I connected to the SQL database where the cbo box gets the clients names
from and I can see the names in cbo box. I created my CR and put the
CRViewer
on another windows form. What's next? I need help with the code.
Thanks in advance
--
TS

[Bernie Yaeger]

Hi TS,

Here's an example of passing a global variable to the report in order to
filter that report. 'globals' is a module that has global scope and has a
string variable in it called 'gl_selectionstring:

Dim mglobals As New globals
mglobals.gl_selectionstring = "{bnlsum.invnum} >= '" & startnumbox.Text &
Chr(39) & " and {bnlsum.invnum} <= '" & endnumbox.Text & Chr(39)

gl_browseprintvar = "f:\imcapps\bnlinv.rpt"

Dim newmdichild As New reportprinter_viewerparam

newmdichild.Text = "BNL Summary Invoice"

newmdichild.Show()

reportprinter_viewerparam is a form that displays the report. In that form,
here's the code for that report:

CrystalReportViewer1.SelectionFormula = mglobals.gl_selectionstring

CrystalReportViewer1.ReportSource = "f:\imcapps\bnlinv.rpt

HTH,

Bernie Yaeger

"TS" <[e-mail]> wrote in message
news:5D**********************************@microsof t.com...

Thanks for your response. Can you tell me how the code for this looks
like.
Or do you know of any white papers that can help with that.

"Bernie Yaeger" wrote:

Hi TS,

There are several ways to do this. Perhaps the most straightforward
would
be to pass a parameter to the report and set the report's record
selection
criteria to include only the client names who match the parameter.

HTH,

Bernie Yaeger

"TS" <[e-mail]> wrote in message
news:68**********************************@microsof t.com...

> Hi all,
> In my windows form, I need the user to select a client name from a
> combo
> box
> and click on a button that opens another form having CRViewer showing
> the
> data for that client selected.
> I connected to the SQL database where the cbo box gets the clients
> names
> from and I can see the names in cbo box. I created my CR and put the
> CRViewer
> on another windows form. What's next? I need help with the code.
> Thanks in advance
> --
> TS