possible design flaw with multiple values in the filter

[former_member621937]

Hello,

I really need some help resolving this issue.

We have a report which accepts 4 parameters. The report has 2 sub reports. Based on parameters, we hide the main report and generate sub reports 2 &3. The report uses SQL command to generate reports. Each sub report is linked to main report using fields which are 1:1 mapping. When I try to run the report by passing single value in the filter, it generates fine. But, when I try to pass multiple values in the filter criteria, for e.g invoicenumber in (1,2), the visual studio add-in crashes indicating that it cannot accept multiple filter criteria with the same parameter values. Do I need to change any thing or have a formula inside the sub report to allow multiple filter criteria?

The aim is to generate a single file where the sub reports 1,2  are generated for a invoicenumber 1 followed by sub reports 1, 2 generated for invoicenumber 2 with the main report hidden.

Sorry, let me know if the question is unclear.

Thanks,

Dileep

[former_member621937 · Accepted solution]

Thanks Don for the response. I guess we can try using the range parameters, but we need to change a lot of code to address all types of reports.

On further research, here is a new observation.

If you change the sub reports to on demand, it runs fine. Once you revert back and rerun the report, the report crashes when trying to retrieve second set of records from sub reports. Did anyone see this behaviour.

Thanks,

Dileep

[former_member11696 · Accepted solution]

So again what SDK are you using?

Can you attach your report? I'll test it in my app.

To attach use the Advanced Editor and simply rename the report from myreport.rpt to myreport.txt.

Don

[former_member621937 · Accepted solution]

There is no SDk involved here. I can reproduce the issue using Crystal reports 2013.

Please find the attached report.

TestTemplate.zip.txt.zip

[former_member11696 · Accepted solution]

Hi Dileep,

Thank you for the report. so what mislead me was this:

"the visual studio add in crashes each time when I pass on multiple values in the selection formula filter.."

I assumed you were writing an application or you wrote the Addin. So who wrioe the Addin you are using?

What happens if you refresh the report and not use the addin and enter in multiple values?

And actually the Addin uses the SDK, so whomever wrote it need to debug it.

If it's one of our OEM Products then you should post to that forum, no idea which addin you are using, The default CR Designer does not come with any....

Don

[former_member621937 · Accepted solution]

Hi Don,

Appreciate your response. I hate to say this but the failure also happens in Crystal Designer 2013. Basically, when two filter values are passes, it crashes the designer if it is not on demand sub report.

Thanks,

Dileep

[former_member11696 · Accepted solution]

Hi Dileep,

You need to fix your subreports. I ran it through my code and I get 37 errors in your formula, if the formula are not used then either delete them or fix them:

Formula: @pageNew : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'Pagenumber = pagenumber + {@Page2}'

This field name is not known.

Details: errorKind

Formula Text: Pagenumber = pagenumber + {@Page2}

End of Subreport Formula: Subreport1

Formula: @fake : Used: 0 times'End'

End of Subreport Formula: Subreport1

Formula: @PageReset : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'if (onfirstrecord) then

'

This field name is not known.

Details: errorKind

Formula Text: if (onfirstrecord) then

    Pagenumber + 1

else

    if({t_rpt_InvoiceCostCenterDetail.ModeratorLeft}=previous({t_rpt_InvoiceCostCenterDetail.ModeratorLeft}) and not onfirstrecord)then

        pagenumber +2

else

pagenumber+1

End of Subreport Formula: Subreport1

Formula: @costContinued : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if (Count ({t_rpt_InvoiceCostCenter.CostCenter})>1 and Not(onlastrecord)) then

'

This field name is not known.

Details: errorKind

Formula Text: if (Count ({t_rpt_InvoiceCostCenter.CostCenter})>1 and Not(onlastrecord)) then

    "continued"

else

    " "

End of Subreport Formula: Subreport1

Formula: @trim : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'Replace({?Pm-t_rpt_InvoiceRemit.SortOrder}, "-", "")'

This field name is not known.

Details: errorKind

Formula Text: Replace({?Pm-t_rpt_InvoiceRemit.SortOrder}, "-", "")

End of Subreport Formula: Subreport1

Formula: @CostCenter_CostCentre_Detail : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "Cost Centre Detail"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "Cost Centre Detail"

else

"Cost Center Detail"

End of Subreport Formula: Subreport1

Formula: @CostCenterTotal_Total : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "Total"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "Total"

else

"Cost Center Total"

End of Subreport Formula: Subreport1

Formula: @CostCenter_CostCentre : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "cost centre"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications" then "cost centre"

else

"cost center"

End of Subreport Formula: Subreport1

Formula: @ShowPHCC : Used: 2 times'End'

End of Subreport Formula: Subreport1

Formula: @ShowPHCCD : Used: 2 times'End'

End of Subreport Formula: Subreport1

Formula: @InvoiceTitle : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.BusinessUnit} = 'AUS' or

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.BusinessUnit} = 'AUS' or

{?Pm-t_rpt_InvoiceRemit.BusinessUnit} = 'NZL' or

{?Pm-t_rpt_InvoiceRemit.BusinessUnit}= 'SGP'

then

'tax invoice'

else

if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

then

'advice'

else

'invoice'

End of Subreport Formula: Subreport1

Formula: @pageNumber : Used: 2 times'End'

End of Subreport Formula: Subreport1

Formula: @Invoice_Advice_Number : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

then

'advice number'

else

'invoice number'

End of Subreport Formula: Subreport1

Formula: @Invoice_Advice_Date : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

then

'advice date'

else

'invoice date'

End of Subreport Formula: Subreport1

Formula: @GST : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'If {?Pm-t_rpt_InvoiceRemit.Country} = "premconf.com/accountcreation/CountryCode/CANADA" then 'gst no.'

'

This field name is not known.

Details: errorKind

Formula Text: If {?Pm-t_rpt_InvoiceRemit.Country} = "premconf.com/accountcreation/CountryCode/CANADA" then 'gst no.'

else 'tax id'

End of Subreport Formula: Subreport1

Formula: @Amount : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.LockboxDescription} = "About Communications"

then

'charges'

else

'amount due'

End of Subreport Formula: Subreport1

Formula: @CurrentAmount : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {?Pm-t_rpt_InvoiceRemit.ShowBalanceForward} = "1" and  {?Pm-t_rpt_InvoiceRemit.LockboxDescription} <> "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {?Pm-t_rpt_InvoiceRemit.ShowBalanceForward} = "1" and  {?Pm-t_rpt_InvoiceRemit.LockboxDescription} <> "About Communications"

then

    {?Pm-t_rpt_InvoiceRemit.CurrentBalance}

else

   {?Pm-t_rpt_InvoiceRemit.CurrentAmount}

End of Subreport Formula: Subreport1

Formula: @PremiereTaxID2 : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'{?Pm-t_rpt_InvoiceRemit.PremiereTaxID}'

This field name is not known.

Details: errorKind

Formula Text: {?Pm-t_rpt_InvoiceRemit.PremiereTaxID}

End of Subreport Formula: Subreport1

Formula: @fr_shared_variable : Used: 1 times'End'

End of Subreport Formula: Subreport1

Formula: @ShowCCFooter : Used: 2 times'End'

End of Subreport Formula: Subreport1

Subreport Name: StandardInvoice_Detail_En.rpt

Formula: @Continued : Used: 1 times'End'

End of Subreport Formula: Subreport2

Formula: @Address1 : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @City : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @Page2 : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @continued_grHeader : Used: 1 times'End'

End of Subreport Formula: Subreport2

Formula: @continued_grFooter : Used: 2 times'End'

End of Subreport Formula: Subreport2

Formula: @continued_pgFooter : Used: 2 times'End'

End of Subreport Formula: Subreport2

Formula: @pageNumber : Used: 2 times'End'

End of Subreport Formula: Subreport2

Formula: @pageReset : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'

'

This field name is not known.

Details: errorKind

Formula Text:

if (onfirstrecord) then

    Pagenumber + 1

else

    if({t_rpt_InvoiceRemit.InvoiceNumber}=previous({t_rpt_InvoiceRemit.InvoiceNumber}) and not onfirstrecord)then

        pagenumber +2

else

    if({t_rpt_InvoiceModerator.ModeratorIDAcc}=previous({t_rpt_InvoiceModerator.ModeratorIDAcc}) and not onfirstrecord)then

        pagenumber +2

else

pagenumber+1

End of Subreport Formula: Subreport2

Formula: @trim : Used: 2 times'End'

Error in formula :

Error in formula  ~:

'Replace({RptInvoiceDetail.InvRemitSortOrder}, "-", "")'

This field name is not known.

Details: errorKind

Formula Text: Replace({RptInvoiceDetail.InvRemitSortOrder}, "-", "")

End of Subreport Formula: Subreport2

Formula: @F-la_Location : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @F-la_confTitle : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'Title'

else

select {RptInvoiceDetail.InvoiceMethod}

    case 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' :

        'moderator'

    case 'metratech.com/accountcreation/InvoiceMethod/Paper by Participant' :

        'conf. title / name / ani'

    case 'metratech.com/accountcreation/InvoiceMethod/Paper by Participant with Moderator Break' :

        'conf. title / name / ani'

    case 'metratech.com/accountcreation/InvoiceMethod/Paper By Participant with Zero-Rated Items' :

        'conf. title / name / ani'

    default:

        'conf. title'

End of Subreport Formula: Subreport2

Formula: @F-la_costCentre : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center'

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center'

then

    'moderator'

else

if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

    'cost centre'

else

    'cost center'

End of Subreport Formula: Subreport2

Formula: @F-la_messageKckinsey : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @F-la_message : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @time : Used: 1 times'End'

End of Subreport Formula: Subreport2

Formula: @InvoiceTitle : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.BusinessUnit} = 'AUS' or

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.BusinessUnit} = 'AUS' or

{RptInvoiceDetail.BusinessUnit} = 'NZL' or

{RptInvoiceDetail.BusinessUnit} = 'SGP'

then

'tax invoice'

else

if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'advice'

else

'invoice'

End of Subreport Formula: Subreport2

Formula: @CurrentAmount : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.ShowBalanceForward} = "1" and  {RptInvoiceDetail.LockBoxDescription} <> "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.ShowBalanceForward} = "1" and  {RptInvoiceDetail.LockBoxDescription} <> "About Communications"

then

    {RptInvoiceDetail.CurrentBalance}

else

    {RptInvoiceDetail.CurrentAmount}

End of Subreport Formula: Subreport2

Formula: @Amount : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'charges'

else

'amount due'

End of Subreport Formula: Subreport2

Formula: @GST : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'If {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA" then 'gst no.'

'

This field name is not known.

Details: errorKind

Formula Text: If {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA" then 'gst no.'

else 'tax id'

End of Subreport Formula: Subreport2

Formula: @PremiereTaxID2 : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'{RptInvoiceDetail.PremiereTaxID}'

This field name is not known.

Details: errorKind

Formula Text: {RptInvoiceDetail.PremiereTaxID}

End of Subreport Formula: Subreport2

Formula: @Rate : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.ServiceType} = "VisionCast Record" then

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.ServiceType} = "VisionCast Record" then

    left({RptInvoiceDetail.Rate}, instr({RptInvoiceDetail.Rate}, "/") -1 )

else

    {RptInvoiceDetail.Rate};

End of Subreport Formula: Subreport2

Formula: @getConfTitle : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'(if ({t_rpt_InvoiceCalls.InvCallsSessionID}<>previous({t_rpt_InvoiceCalls.InvCallsSessionID}) or onfirstrecord) then

'

This field name is not known.

Details: errorKind

Formula Text: (if ({t_rpt_InvoiceCalls.InvCallsSessionID}<>previous({t_rpt_InvoiceCalls.InvCallsSessionID}) or onfirstrecord) then

    {t_rpt_InvoiceGroupDetail.ConferenceName} + ' '

    else '') +

if ISNULL({t_rpt_InvoiceCallDetails.ParticipantInfo})

    THEN ''

    ELSE

        {t_rpt_InvoiceCallDetails.ParticipantInfo}

End of Subreport Formula: Subreport2

Formula: @GroupLabel : Used: 0 times'End'

End of Subreport Formula: Subreport2

Formula: @FirstDescriptor : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center'

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center'

then

    {RptInvoiceDetail.ModName}

else

    {RptInvoiceDetail.CostCenter}

End of Subreport Formula: Subreport2

Formula: @SecondDescriptor : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

    {RptInvoiceDetail.ModName}

else (

    if isnull({RptInvoiceDetail.ParticipantInfo}) then

        {RptInvoiceDetail.ConferenceName}

    else (

        if isnull({RptInvoiceDetail.ConferenceName}) or

            Previous({RptInvoiceDetail.ParentSessionID}) = {RptInvoiceDetail.ParentSessionID} then

           {RptInvoiceDetail.ParticipantInfo}

        else

            {RptInvoiceDetail.ConferenceName} + " " + {RptInvoiceDetail.ParticipantInfo}

    )

)

End of Subreport Formula: Subreport2

Formula: @InvoiceMethod : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

    'conf. title'

else if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center' then

    'cost center'

else

    'moderator'

End of Subreport Formula: Subreport2

Formula: @InvoiceMethodTotal : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Conference Title' then

    'conf. title total'

else if {RptInvoiceDetail.InvoiceMethod} = 'metratech.com/accountcreation/InvoiceMethod/Paper by Cost Center' then

    'cost center total'

else

    'total moderator charges'

End of Subreport Formula: Subreport2

Formula: @FederalTax : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'(if {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA"

'

This field name is not known.

Details: errorKind

Formula Text: (if {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA"

    then "gst total"

else

    "Total USF/Other")

End of Subreport Formula: Subreport2

Formula: @StateTax : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'(if {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA"

'

This field name is not known.

Details: errorKind

Formula Text: (if {RptInvoiceDetail.InvRemitEnumCountry} = "premconf.com/accountcreation/CountryCode/CANADA"

    then "pst/hst total"

else

    "total state tax/other")

End of Subreport Formula: Subreport2

Formula: @SortOrder : Used: 0 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.InvRemitSortOrder} = 'Undefined' then ''

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.InvRemitSortOrder} = 'Undefined' then ''

else {RptInvoiceDetail.InvRemitSortOrder}

End of Subreport Formula: Subreport2

Formula: @Invoice_Advice_Number : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'advice number'

else

'invoice number'

End of Subreport Formula: Subreport2

Formula: @Invoice_Advice_Date : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'advice date'

else

'invoice date'

End of Subreport Formula: Subreport2

Formula: @ConfNo_Id : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'id'

else

'conf. no'

End of Subreport Formula: Subreport2

Formula: @ConferenceDetail_ModeratorDetail : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'Moderator Detail'

else

'Conference Detail'

End of Subreport Formula: Subreport2

Formula: @ConfDate_Date : Used: 1 times'End'

Error in formula :

Error in formula  ~:

'if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

'

This field name is not known.

Details: errorKind

Formula Text: if {RptInvoiceDetail.LockBoxDescription} = "About Communications"

then

'date'

else

'conf. date'

End of Subreport Formula: Subreport2

Formula: @ShowPHDetail : Used: 2 times'End'

End of Subreport Formula: Subreport2

Formula: @fr_shared_variable : Used: 2 times'End'

End of Subreport Formula: Subreport2

Formula: @ShowFooter : Used: 2 times'End'

End of Subreport Formula: Subreport2

[former_member621937 · Accepted solution]

Thanks Don. I did remove all the things and made a bare minimum skeleton of the report. Interestingly, the attached report StandardInvoice_NoGroupsNoFormulasNoSuprFormulasDPO.rpt fails too.

Thanks again for your time.

StandardInvoice_NoGroupsNoFormulasNoSuprFormulasDPO.zip.txt.zip

[former_member11696 · Accepted solution]

OK I think the problem is you also need to update these values for the parameter.

Here's my code to get them, you should be able to set them True:

if (paramfield.Type != CrystalDecisions.ReportAppServer.DataDefModel.CrFieldValueTypeEnum.crFieldValueTypeBooleanField)

{

    if (currValCount == 0)

        btnReportObjects.AppendText("\n Allow Custom Values: True\n"); // Always true if no current values specified

    else

        btnReportObjects.AppendText(" Allow Multiple Values: " + paramfield.AllowCustomCurrentValues.ToString() + "\n");

    btnReportObjects.AppendText(" Allow Multiple Values: " + paramfield.AllowMultiValue.ToString() + "\n");

    btnReportObjects.AppendText(" Allow Discrete Values: " + paramfield.AllowCustomCurrentValues.ToString() + "\n");

    btnReportObjects.AppendText(" Allow Null Values: " + paramfield.AllowNullValue.ToString());

}

See if that works for you

Don

[former_member621937 · Accepted solution]

Hey Don,

Just figured out the issue. The issue is with page orientation in one of the group of the subreport is different to other groups in sub report. If i changed everything to landscape, it worked. I will raise a ticket to crystal support to fix the tool /client to show exact error

Thanks  much!!!

Dileep

[former_member621937]

Thanks guys for the inputs. I think I made it complex by explaining unnecessary stuff . I will try to make it clear.

The main report has 4 parameters. These are just boolean values that are used to hide the reports dynamically. The main report is mapped to a table which accepts a filter condition that is being sent via selection formula. So, if I right click the main report and click on show sql, it says select * from invoice where productid = '123' where 123 is set by the filter condition. Basically, the code we have sends this data. Now, the two sub reports are nothing but two other tables which are linked to main report by the productid field . For example product id from main report exists both in sub report tables and are linked to main report.  So, when I try to preview report, the 4 parameters are not used as filter criteria. But, the filter is used by the main report table which in turn populates the data in the sub reports since they are joined by a parameter field from the main report. Now, instead of sending one product id, the intention is to send multiple product ids . e.g the main report query will look like select * from invoice where productid = 123 or productid = 234. What I expect to happen is that the output will be generated for one product id followed by another productid. Instead , the visual studio add in crashes each time when I pass on multiple values in the selection formula filter. So, I believe it was not able to handle multiple filters.

Thanks for helping this newbie.

Dileep

[former_member11696]

What SDK are you using?

I suspect you need to change your logic, you can create Range parameters which allow CR to prompt for those values or will allow you to set those values.

Bottom line is if you can do this in CR Designer then should be able to in code using the exact same work flow. But since the values are set in the Command Parameter you need to update the SQL to accept range values also.

Don

[former_member205840]

Hi Dileep,

There are few things to check :

Is your main report / sub report parameter accepts multi value ?

You said the report source is SQL, how you are handling in this parameter in where clause

How you are entering multi value in the parameter (Eg. 1,2,3..) values side by side with a delimiter or one below the other ?

Can you right click on sub report and save as a separate report and try to run with multi value.  If that pops out an error try to look at SQL.

Also while defining parameters at Add Command (SQL ) you will see an option / check box 'Allow Multi Values' have to checked this option ?

Thanks,

Sastry

[abhilash_kumar]

Hi Dileep,

Are the prompts setup to accept 'multiple values' or do you type them in as a comma separated string?

-Abhilash