Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Multi Value Parameters problems

Author  Topic 

msghaleb
Starting Member

1 Post

Posted - 2015-04-14 : 10:10:19
Dear All,

I have a very strange problem (you can replicate it if you have SSRS)

I have a stored proc which accepts multi value, the report for that generate a multi value parameter text box.

if I entered in this report the following:
a
b
c

The result would be => a, b, c, d and this will be pushed to the PROC and the PROC will split them and return the result which is working perfectly fine.

Now the problem, I've created an ASPX web page (c#) with the following:

<form runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

<rsweb:ReportViewer ID="UsersStatusReport" runat="server" Font-Names="Arial" Font-Size="8pt" ProcessingMode="Remote" WaitMessageFont-Names="Arial" WaitMessageFont-Size="8pt" Height="100%" Width="100%" ShowCredentialPrompts="False" ShowDocumentMapButton="False" ShowParameterPrompts="True" ShowPromptAreaButton="False" ShowWaitControlCancelLink="False" SizeToReportContent="True" AsyncRendering="False" ShowBackButton="True" ShowFindControls="False" ShowPrintButton="False" ShowRefreshButton="False" ShowZoomControl="False" BackColor="#EEEEEE" BorderStyle="None" InternalBorderStyle="None" SplitterBackColor="Transparent" ToolBarItemBorderColor="Transparent" ToolBarItemBorderStyle="NotSet" ToolBarItemBorderWidth="0px" ToolBarItemHoverBackColor="Transparent">
<ServerReport ReportPath="/Users_Reports/MultiSearch" ReportServerUrl="https://servername/Reportserver" />
</rsweb:ReportViewer>

</form>

This doesn't work, as when I enter this:
1
b
c
d

it comes out to the PROC => abcd

Can you help me please on that? I need the output to stay a, b, c, d

Regards and thanks in adv.

MG
   

- Advertisement -