I have a report and a subreport that uses the same query. The query has a start and end date parameter.

I'm trying to map the value of the main report parameter value to the subreport parameter value.

When I try to map it, I get an error.

I'm using Version 8

I have a report and a subreport that uses the same query. The query has a start and end date parameter.

I'm trying to map the value of the main report parameter value to the subreport parameter value.

When I try to map it, I get an error.

I'm using Version 8

Here is the Query

SELECT *,$P(pFrom) as dFrom,$P(pTo) as dTo  from "user"."VSales_Stats_Rpt" where quote_date BETWEEN  $P(pFrom) and $P(pTo)

I have a report and a subreport that uses the same query. The query has a start and end date parameter.

The subreport works but without the mapping it uses the default parameter values.

I'm trying to map the value of the main report parameter value to the subreport parameter value.

When I try to map it, I get an error.

I'm using Version 8

Here is the Query

SELECT *,$P(pFrom) as dFrom,$P(pTo) as dTo  from "user"."VSales_Stats_Rpt" where quote_date BETWEEN  $P(pFrom) and $P(pTo)

Hello Trevor,

And in the Map Parameters dialog you should write dFrom, not pFrom:
pFrom = dFrom

It is for version 8. In the latest versions parameters set for the main report automatically set for the subreport query (if not defined by the map of parameters)

I have tried putting dFrom instead, but I get the same error.

Yes, this error is on the Map Parameters dialog Test tab, so there is an issue in parameters substitution on this tab.
But when you make a preview of this report - there is another error about inconsistent parameters (VARCHAR in FROM section and DATE in BETWEEN section).

To fix it, it is necessary to CAST parameters so they will be of the same type, for example:

SELECT *, CAST ( $P(pFrom) AS DATE ) as dFrom, CAST ( $P(pTo) AS DATE ) as dTo  from "user"."VSales_Stats_Rpt" where quote_date BETWEEN  $P(pFrom) and $P(pTo)

That worked perfect.

Thanks