Hi,
I have my report setup do that a Stored Procedure is added to the On_Open attribute of a report. Everything works find and there are three parameters:
I have hardcoded three values in for simplicity although the problem occurs when I try to add more than one value to a parameter. I understand they dont support arrays and so im at a loss to know what to do.
Any help appreciated
Phil
I have my report setup do that a Stored Procedure is added to the On_Open attribute of a report. Everything works find and there are three parameters:
strRecordSource = "Exec sp_ClientQuery 'UK', 'CF', 'UNITED KINGDOM'"
Me.RecordSource = strRecordSource
I have hardcoded three values in for simplicity although the problem occurs when I try to add more than one value to a parameter. I understand they dont support arrays and so im at a loss to know what to do.
Any help appreciated
Phil