Hi everyone,
I am a new user to Crystal reports so I would appreciate any suggestions anyone could throw my way.!!! IThis is an older version of Crystal; sorry, I don't have the version as of this post.
I have a record selection formula correctly running in the main report, selecting specific data from an SQL database, based on a date range the user has entered.
This main record selection formula chooses salespeople that have sales > 0 and gets account numbers.
I am passing that account number and the start/end date as parameters into the subreport (once per detail line)
The account number and the start/end dates are used in the query of the DB2 database.
My problem is that I need to tie what the subreport returns back somehow to the main report detail line so I ONLY get detail lines in the main report that meet the specific criteria of the subreport. In other words, I don't want to show a saleperson on the detail line of the report UNLESS they have sales that fall within the specified date range for that specific account number.
I am thinking that I may need to SUPPRESS printing of the detail line in the main report based on what the subreport returns, but I don't quite know how to accomplish this....
Ideas? suggestions? Thanks so much!!
I am a new user to Crystal reports so I would appreciate any suggestions anyone could throw my way.!!! IThis is an older version of Crystal; sorry, I don't have the version as of this post.
I have a record selection formula correctly running in the main report, selecting specific data from an SQL database, based on a date range the user has entered.
This main record selection formula chooses salespeople that have sales > 0 and gets account numbers.
I am passing that account number and the start/end date as parameters into the subreport (once per detail line)
The account number and the start/end dates are used in the query of the DB2 database.
My problem is that I need to tie what the subreport returns back somehow to the main report detail line so I ONLY get detail lines in the main report that meet the specific criteria of the subreport. In other words, I don't want to show a saleperson on the detail line of the report UNLESS they have sales that fall within the specified date range for that specific account number.
I am thinking that I may need to SUPPRESS printing of the detail line in the main report based on what the subreport returns, but I don't quite know how to accomplish this....
Ideas? suggestions? Thanks so much!!