Multiple table report

[Jefftopia]

I have a report which I am designing which needs to be driven off of multiple tables. Each of these tables contains an identifier ("WU_id&quot.

First I want to limit the data in the tables to one specific "WU_id". To be more specific, the user will be accessing the report from Visual Basic 6. When the user is in a particular form pertaining to a single WU_id and they make the selection to view the report, I would like Crystal Reports to show me a report specific to that WU_id.

Anyone, anyone....Any advice/recommendations appreciated.

 

[synapsevampire]

Create a parameter in the CR report for ("WU_id&quot.

Insert->Field Object->Parameters

Make sure it's the same type.

Set the parm prior to displaying the report.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jefftopia]

I have created the parameter as you suggested. After doing so, I went into preview the report and it prompted me for a WU_id. I supplied a number from one of the records in my table.

Problem--the report still showed data from other records also.

After this problem is overcome I don't suppose you know how to set the parameter in visual basic prior to displaying the report. This is the method I am using to view the report from Visual Basic:

Private Sub mnuView2_Click()

'Run Report.
Screen.MousePointer = vbHourglass
frmRptView.Show
frmRptView.CRViewer1.ReportSource = rptWriteUp
frmRptView.CRViewer1.ViewReport
Screen.MousePointer = vbDefault

End Sub

frmRptView is simply a form I am using to view all of my CR reports.

thx-I think I am on the right path.

 

[Jefftopia]

UNRESOLVED--

I have attempted to add a parameter to the report. I have followed the CR help menu to a tee but my detail sections are still showing for all records.

Help Appreciated.

 

[dgillz]

Creating a parameter is only the first step. you also need to tie the parameter into your record selection formula in order to restrict the records that appear on your report.

Report->Edit Selection Formula->Record. Then enter the formula. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[synapsevampire]

As dgillz suggests, you must reference it in the report selection criteria as in:

{MyTable.WUID} = {?MyWUIDParm}

Now setting the parm from VB will limit the rows accordingly.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jefftopia]

thanks to you both. i am new to the whole crystal reporting scene.

all i need now is to figure out how to set the parameter from visual basic.

Muchos Gracias!