Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a parameter to a sub report

Status
Not open for further replies.

MikeRussell

Programmer
Apr 22, 2001
16
AU
I have a variable in my main report @enddate, which stores a date value, this is currently in the Page Header. My main report is based on many tables, but the main one is STMTRPT.

I have created a parameter format in my subreport Pm-@enddate. The subreport is based on a single table CFLOWS.

The main report/sub report link is STMTRPT.DEAL_NO -> CFLOWS.DEAL_NO and @enddate ->Pm-@enddate

When I run the report from within Crystal it works fine, but when I run it from within a VB application(which uses Crystal report as output) then I am promted to 'Eneter Parameter Values' for 'Parameter Fields:' End_Date(sub113T)

Any idea why this is hapeneing?
 
Nuke Pm-@enddate.

Set the record selection to:

@enddate ->{subreporttable.datefield}

BTW, you don't have a variable called @enddate, you have a formula.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top