We help IT Professionals succeed at work.

Subreports in CR 6.0

cova
cova asked
on
Hi:

  I have a report, it has a subreport. My problem is
?How Can I change the sql of this subreport?. I have to filter some records.

I have to use Vb 6, to do this.

Thanks
Comment
Watch Question

Mike McCrackenSenior Consultant
SILVER EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
How are you calling the report now?

CR 8.0 using the OCX control has a subreporttochange property.  You could set that and then change the query or add the filter.

good luck
mlmcc

Suat OzgurWeb / Application Developer
BRONZE EXPERT

Commented:
If you just want to filter it according to same fields in report then just change the selection formula for that sub report.

suat
Suat OzgurWeb / Application Developer
BRONZE EXPERT

Commented:
"same fields" doesnot explain what i want to suggest. Ok, correction; why dont you try using record selection formula for sub report?

suat

Author

Commented:

Author

Commented:

Author

Commented:
How Can I use the property subreportochange?

Author

Commented:
Hi:

I have an Ocx that is my report. This is how I call:

CrystalReport.Filename=path;
Crystalreport.Sql=Query.

But in the file, exist a subreport and I want to change his
sql sentence. I have the property subreporttochange, but how Can i use it?

Set subreport=Crystalreport.subreporttochange, do not work.

Commented:
This question has been open now for months without a resolution and/or an accepted answer and will be submitted to the Cleanup section for closure.

My recommendation:  Delete Question

DRRYAN3

Author

Commented:
Ok, Thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.