rpt.recordselec tionformula and subrpt.recordse lectionformula

[Helen]

VB .NET 2002
Crystal Reports 9

Hello:
OK, I'm getting closer with this. Can someone please help with this last piece?

Main report oracle 7 db
Subreport totally unrelated historical Access .mdb

I need to take the user's input in a text box and pass the result (wildcard) to the record selection formula prior to refreshing the crystal report.

When I set the report source to the main report, I get all the results from the main report, but the subreport isn't being read correctly.

When I set the report source to the subreport, I get results in the subreport, I only get results in the subreport.

Makes sense, right?

But I NEED results in both whenever they exist.

How do I have the report source look at both reports? Or whatever I need to do to get results from both?

I'd really appreciate your feedback!
In Public Class:

Dim rpt As New CBOPARTSDESCFOR MULA2()
Dim subrpt As New ReportDocument( )
Here's the code in my display click button:

Dim mySubReport As CrystalDecision s.CrystalReport s.Engine.Report Document
Dim mySubReportObje ct As CrystalDecision s.CrystalReport s.Engine.Subrep ortObject
Dim MyReportObject As CrystalDecision s.CrystalReport s.Engine.Report Object

CrystalReportVi ewer1.ReportSou rce = rpt

Dim RecordSelection Formula As String
Dim reportName As String

CrystalReportVi ewer1.Selection Formula = RecordSelection Formula

CrystalReportVi ewer1.RefreshRe port()

If I change the report source = subrpt or reportdocument, I get results in the subreport.

What's the missing piece, please?

Thanks so much!

Helen

[Helen]

Now, we're getting somewhere, I'm getting results in the subreport with this code, but for some reason it's bypassing the selection formula for the main report. Does anyone know what's wrong here, please?
==========
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles btnDisplay.Clic k

Dim SelectFormula As String()
Dim reportName As String

subrpt = CBOPARTSDESCFOR MULAReport.Open Subreport("item desc")

CBOPARTSDESCFOR MULAReport.Reco rdSelectionForm ula = SelectFormula(" LowerCase({LINE _ITEM.CLIN_DESC }) LIKE '" & txtDesc().Text. ToLower & "' or LowerCase({LINE _ITEM.CLIN_EXT_ DESC}) LIKE '" & txtDesc().Text. ToLower & "' or LowerCase({PROC _OBJECT_1.DOC_T ITLE}) LIKE '" & txtDesc().Text. ToLower & "'")

CrystalReportVi ewer1.RefreshRe port()
End Sub

Tks,
-H

"Helen" wrote:

VB .NET 2002
Crystal Reports 9

Hello:
OK, I'm getting closer with this. Can someone please help with this last piece?

Main report oracle 7 db
Subreport totally unrelated historical Access .mdb

I need to take the user's input in a text box and pass the result (wildcard) to the record selection formula prior to refreshing the crystal report.

When I set the report source to the main report, I get all the results from the main report, but the subreport isn't being read correctly.

When I set the report source to the subreport, I get results in the subreport, I only get results in the subreport.

Makes sense, right?

But I NEED results in both whenever they exist.

How do I have the report source look at both reports? Or whatever I need to do to get results from both?

I'd really appreciate your feedback!
In Public Class:

Dim rpt As New CBOPARTSDESCFOR MULA2()
Dim subrpt As New ReportDocument( )
Here's the code in my display click button:

Dim mySubReport As CrystalDecision s.CrystalReport s.Engine.Report Document
Dim mySubReportObje ct As CrystalDecision s.CrystalReport s.Engine.Subrep ortObject
Dim MyReportObject As CrystalDecision s.CrystalReport s.Engine.Report Object

CrystalReportVi ewer1.ReportSou rce = rpt

Dim RecordSelection Formula As String
Dim reportName As String

CrystalReportVi ewer1.Selection Formula = RecordSelection Formula

CrystalReportVi ewer1.RefreshRe port()

If I change the report source = subrpt or reportdocument, I get results in the subreport.

What's the missing piece, please?

Thanks so much!

Helen

[Helen]

Well, here's the answer. Just need to add the following prior to refreshreport:

CrystalReportVi ewer1.ReportSou rce = CBOPARTSDESCFOR MULAReport

Had it misplaced in the pub class.

So, this one's done.
"Helen" wrote:

Now, we're getting somewhere, I'm getting results in the subreport with this code, but for some reason it's bypassing the selection formula for the main report. Does anyone know what's wrong here, please?
==========
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles btnDisplay.Clic k

Dim SelectFormula As String()
Dim reportName As String

subrpt = CBOPARTSDESCFOR MULAReport.Open Subreport("item desc")

CBOPARTSDESCFOR MULAReport.Reco rdSelectionForm ula = SelectFormula(" LowerCase({LINE _ITEM.CLIN_DESC }) LIKE '" & txtDesc().Text. ToLower & "' or LowerCase({LINE _ITEM.CLIN_EXT_ DESC}) LIKE '" & txtDesc().Text. ToLower & "' or LowerCase({PROC _OBJECT_1.DOC_T ITLE}) LIKE '" & txtDesc().Text. ToLower & "'")

CrystalReportVi ewer1.RefreshRe port()
End Sub

Tks,
-H

"Helen" wrote:

VB .NET 2002
Crystal Reports 9

Hello:
OK, I'm getting closer with this. Can someone please help with this last piece?

Main report oracle 7 db
Subreport totally unrelated historical Access .mdb

I need to take the user's input in a text box and pass the result (wildcard) to the record selection formula prior to refreshing the crystal report.

When I set the report source to the main report, I get all the results from the main report, but the subreport isn't being read correctly.

When I set the report source to the subreport, I get results in the subreport, I only get results in the subreport.

Makes sense, right?

But I NEED results in both whenever they exist.

How do I have the report source look at both reports? Or whatever I need to do to get results from both?

I'd really appreciate your feedback!
In Public Class:

Dim rpt As New CBOPARTSDESCFOR MULA2()
Dim subrpt As New ReportDocument( )
Here's the code in my display click button:

Dim mySubReport As CrystalDecision s.CrystalReport s.Engine.Report Document
Dim mySubReportObje ct As CrystalDecision s.CrystalReport s.Engine.Subrep ortObject
Dim MyReportObject As CrystalDecision s.CrystalReport s.Engine.Report Object

CrystalReportVi ewer1.ReportSou rce = rpt

Dim RecordSelection Formula As String
Dim reportName As String

CrystalReportVi ewer1.Selection Formula = RecordSelection Formula

CrystalReportVi ewer1.RefreshRe port()

If I change the report source = subrpt or reportdocument, I get results in the subreport.

What's the missing piece, please?

Thanks so much!

Helen