Details is not filtering with the parameters passed but the sub report is filtered with the same paramers

[Former Member]

Hi I have a report that have a grouping based on client Name and  the details shows the transaction details filtered between startdate and enddate parameter.

I have a subreport in clientName Group Header which takes the same date parameters to show some summary data based on the client.

The details should list the transaction details for the date period selected.

I have a record selection formula as follows:

{Customers.CustomerID} = {?customerID} and  {TransactionLogs.CreatedDt} in {?startdate} to {?enddate}

'Set report parameters

        Dim cDiscreteValue1 As New ParameterDiscreteValue()

        cDiscreteValue1.Value = startdate

        cr.ParameterFields("startdate").CurrentValues.Clear()

        cr.ParameterFields("startdate").DefaultValues.Clear()

        cr.ParameterFields("startdate").CurrentValues.Add(cDiscreteValue1)

        cDiscreteValue1.Value = enddate

        cr.ParameterFields("enddate").CurrentValues.Clear()

        cr.ParameterFields("enddate").DefaultValues.Clear()

        cr.ParameterFields("enddate").CurrentValues.Add(cDiscreteValue1)

        cDiscreteValue1.Value = companyid

        cr.ParameterFields("customerID").CurrentValues.Clear()

        cr.ParameterFields("customerID").DefaultValues.Clear()

        cr.ParameterFields("customerID").CurrentValues.Add(cDiscreteValue1)

But the details section is showing all the transactions without the records filtered.

Any suggestions??

[former_member183750 · Accepted solution]

Hi Manoj

Does the report work in the CR designer?

What version of the CR designer are you using?
What version assemblies are you using?

If you let the report prompt for the parameters at runtime (e.g.; comment out the param code), and fill out the param values manually, does the report work?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

Hi Ludek,

The report is working fine in CR designer.

Version: 13.0.2000.0 in Visual Studio 2012.

Even the values in the prompts during runtime is not filtering the data but it is working fine in CR Designer.

[former_member183750 · Accepted solution]

Hi Manoj         

Do make sure you are using SP 12:

What version of the CR designer are you using?Also, the general flow of the app should be:

Load report

logon to the database

set the parameters

set the selection formula

view

Can you confirm that this is the flow of your app?

- Ludek

[Former Member · Accepted solution]

I am downloading the latest versions now and about the work flow.

Load report

logon to the database

set the selection formula

set the parameters

view.... is my workflow in the app.

I will interchange the selection formula and parameters and see if this will fix the issue and will update you in my next reply.

Thank you for your help.