SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Prasanna Jung Malla / Displaying a Pop-up message in SSRS 2005 / Latest Posts

RE: Displaying a Pop-up message in SSRS 2005

huntersimon — Fri, 15 Jul 2011 13:04:09 GMT

Some as others I went through this whole example, got it working in visual studio, only to deploy it to the reportserver where it is needed and it does not work. Does anyone know how to get this working sever side or is this article basically worthless. It would be a good article if it actually worked.

RE: Displaying a Pop-up message in SSRS 2005

Prasanna, MCTS — Sun, 13 Mar 2011 19:13:42 GMT

This was done in SSRS 2005 and I was able to get it working only locally. I didn't realize it was not working once you deploy it. I have not tried this on SSRS 2008 nor in Sharepoint integration.Thanks

RE: Displaying a Pop-up message in SSRS 2005

Mr.wOw — Thu, 10 Mar 2011 02:52:32 GMT

Hi Prasanna,This does not work neither in IDE...nor on report server...nor on sharepoint integrated mode...can you explain how did you achieved it....i have done each and every step you have mentioned...Cheers...Pulkit

RE: Displaying a Pop-up message in SSRS 2005

kpsr_kpsr 63487 — Mon, 20 Sep 2010 23:35:48 GMT

Hi i have problem with text box,right when the message box shows message like"U entered 5,r u sure do u want continue"if i press yes it will display the text box message .right when i press no it should not be render the report,but in my case why it's rendering?Any idea?

RE: Displaying a Pop-up message in SSRS 2005

nraju1982 — Tue, 13 Jul 2010 06:10:46 GMT

Its working as expected from the IDE. But need to check from report server.

RE: Displaying a Pop-up message in SSRS 2005

Jason Thomas — Wed, 30 Jun 2010 01:03:25 GMT

This method described by Prasanna will not work when you are deploying the reports to the web, and anyways, since the custom code gets executed at the server side, this is of no practical use as the message box will never pop-up when accessed from the client.Cheers,Jason[url=http://road-blogs.blogspot.com]My Blog[/url]

RE: Displaying a Pop-up message in SSRS 2005

smansky — Thu, 29 Apr 2010 00:46:22 GMT

The problem is when you deploy report to web service is not working.Error during processing of ‘parameter’ report parameter. (rsReportParameterProcessingError) :crying::crying::crying::crying:

RE: Displaying a Pop-up message in SSRS 2005

smansky — Thu, 29 Apr 2010 00:46:20 GMT

The problem is when you deploy report to web service is not working.Error during processing of ‘parameter’ report parameter. (rsReportParameterProcessingError) :crying::crying::crying::crying:

RE: Displaying a Pop-up message in SSRS 2005

Shiva Thomas — Fri, 26 Mar 2010 03:09:33 GMT

I found that a better alternative is to do the validation on the SQL side. It's very easy to use a sql RAISERROR function to display some meaningful feedback to the user, and you can stop the report execution! Example:[code="sql"]IF (@intNumber > 55 OR @intNumber < 15) RAISERROR('Error: Your number must be smaller than 55 and bigger than 15', 16, 0);[/code]Syntax:[code="sql"]RAISERROR (@ErrorMessage, -- Message text. @ErrorSeverity, -- Severity of >=16 stop the script and the Report execution. @ErrorState -- State. );[/code]

RE: Displaying a Pop-up message in SSRS 2005

TEwing — Tue, 16 Feb 2010 16:09:09 GMT

I've had pretty much the same experience as everyone else here.Great idea. I got it working in my Visual Studio environment and then when I sent it to the reportserver there was no way to get it working.Which is too bad really, this would be such a valuable feature for parameter validation w/out having to build a custom aspx page.

RE: Displaying a Pop-up message in SSRS 2005

FVC — Mon, 31 Aug 2009 04:25:47 GMT

I also have it working when running in MS Visual Studio, but once deployed on the reportserver, it failes on the messagebox. I would like to know how to bypass that ...

RE: Displaying a Pop-up message in SSRS 2005

bkarle — Thu, 27 Aug 2009 09:01:26 GMT

Happy to report that I found a decent workaround to the "msgBox" problem I reported earlier. Basically, just take out the MsgBox from your function code and let the user select parameters as they want. On clicking "View Report", your validation function will turn ON or OFF the boolean parameter and it will dictate whether your entire report shows up or a customized error message shows up. I my proof of concept, I made all parts of the function parameterized so that even the message can be customized. I will post it here later.Prasanna, your example here and the word document helped a lot. Thanks a lot for your contribution.

RE: Displaying a Pop-up message in SSRS 2005

bkarle — Wed, 26 Aug 2009 15:59:47 GMT

I have not tried to do exactly what you have suggested, but soemthing similar based on another post [url=http://www.sqlservercentral.com/Forums/Topic537763-145-1.aspx]here[/url] - but ran into a problem that MsgBox is not a valid function outside of the Visual Studion IDE. In fact, for my test project, the MsgBox option was showing up wonderfully in the "preview" mode, but stopped displaying it in the "Debug" mode. Needless to say, deploying it to the Reporting Server also did not help - it apprears that the VB Code for MsgBox is simply Not Supported on SSRS Servers. Read [url=http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1948a099-50dd-4630-bb58-43dc97bb5020/]this[/url]May be I am wrong, in which case, I would be very happy to find out how you got your solution to work on the SSRS Server. Bhushan

RE: Displaying a Pop-up message in SSRS 2005

testdev.ram — Thu, 02 Jul 2009 10:59:17 GMT

Hey prasanna, looks like you are too good in SSRS .why don't you show some more scenarios just like this.I think you are working right

RE: Displaying a Pop-up message in SSRS 2005

kramu — Thu, 14 May 2009 12:49:26 GMT

Problem description: I am using the function to embedd within the report .This function is called the user presses the view report button.It works in the report designer (in preview),but it doesn't work on the server after i deployed it to the server,why does it give me the message that is Error during processing of '@ParameterName' report parameter.(rsReportParameterProcessingError).I am using Mgbox to display some alert statements in the Custome code.. embedded into the.. reportdo I need to do anything with custom assemblies?

RE: Displaying a Pop-up message in SSRS 2005

rucker — Thu, 07 May 2009 10:09:09 GMT

Great article Prasanna - There's a few typos that are probably resopnsible for the errors folks are seeing on this thread:When setting the visibility of the controls:=Not(Parameter!IsValidNum.Value) should be =Not(Parameter[b]s[/b]!IsValidNum.Value) - note the missing 's'=Parameter!IsValidNum.Value should be =Parameter[b]s[/b]!IsValidNum.Value - note the missing 's'

RE: Displaying a Pop-up message in SSRS 2005

jorgen-556430 — Tue, 28 Apr 2009 09:08:07 GMT

Sorry here comes an attachement of the RDL instead../Jörgen

RE: Displaying a Pop-up message in SSRS 2005

jorgen-556430 — Tue, 28 Apr 2009 09:03:03 GMT

Hi and thanks for an interesting and promising article,However I'm having the same problem as many other of your readers. I've made a very simple report which is just supposed to show a messagebox and then show the report. I always get this message: Error during processing of ‘YesNoBox’ report parameter. (rsReportParameterProcessingError) when running it from Report Server.But when running it from BIDS it works OK. Is it Internet Explorer that blocks something? I attached the RDL-file I'm using.Best regardsJorgen HasselgrenHNO3 Business Intelligence Sweden 2.5cm 2.5cm 21cm Integer =Code.testing(1) true Report_Parameter_5 true true 21cm 0.25cm true 1cm 3cm 1.75cm textbox1 2.53968cm true 0.63492cm TEXT 10.75cm 8427111c-07de-4d15-94cf-59f8095dd539 2.5cm Function Testing(TestInt As Integer) As IntegerMsgBox("MsgBox",4,"Title")Return 1End Function 22.75cm 29.7cm en-US 2.5cm 29.7cm

RE: Displaying a Pop-up message in SSRS 2005

Prasanna, MCTS — Sun, 26 Apr 2009 09:35:50 GMT

It is not possible to stop the call to db after you run the report. The possible work around could be, in you dataset you can check the value of this parameter and execute stored procedures only if the parameter returns true, else you can execute simple select to return some static value. this will prevent your call to db and hidden function can present the report as if the report never executed.Hope this helps !!For those of you it did not work, can you may be give more information as to what you are trying to do, are you copying the code exactly, or making any changes? I am suprised because I tested everything before I included in the note.- Prasanna

RE: Displaying a Pop-up message in SSRS 2005

prasant.nanda — Sat, 25 Apr 2009 04:41:04 GMT

Hi Prasanna,Thanks for the post. It is not working as desired way. I expect the report to stop running when the user clicks on cancle button. Specificaly I want the call to db should not happen when the user hits cancle button.Using the hidden function we can be smart enough to hide data from user, but internally the db call should also be seized. Until the user selects the expected parameter, the report should not process (the call to db should nt happen).

RE: Displaying a Pop-up message in SSRS 2005

prasant.nanda — Sat, 25 Apr 2009 04:39:15 GMT

RE: Displaying a Pop-up message in SSRS 2005

prasant.nanda — Sat, 25 Apr 2009 04:37:41 GMT

Hi Prassanna,Thanks for the post. It is not working as desired way. I expect the report to stop running when the user clicks on cancle button. Specificaly I want the call to db should not happen when the user hits cancle button.Using the hidden function we can be smart enough to hide data from user, but internally the db call should also be seized. Until the user selects the expected parameter, the report should not process (the call to db should nt happen).

RE: Displaying a Pop-up message in SSRS 2005

qiyuef — Fri, 24 Apr 2009 16:30:58 GMT

This sample doesn't work.The MsgBox function cause report process failedAn error occurred during local processing IsValidNum

RE: Displaying a Pop-up message in SSRS 2005

Prasanna, MCTS — Thu, 23 Apr 2009 21:54:07 GMT

sorry guys if it did not work for you. I will have to get back to you guys at a later date after I get a chance to look at it. But the screen shots are from actually running the report, so I know it works.But glad to see at least one person who could make use of this trick.Peter.Groman,As I mentioned in the article, SSRS 2005 really has lots of limitation but it is not that there are no workarounds. You cannot actually halt the report processing, because this validation occurs after you run the report. So here is what you can do...When user clicks No or Cancel, the give code returns a boolean "False". So based on this value, you can display a message in the report body, inside a textbox or label, asking users to enter the parameters again or whatever message you want.You will actually be altering the visible/Hidden property of your entire table or matrix or whatever controls you have in your report to hide when that parameter value is false and in that case you will show your textbox or label with message and hide this message when True.This should solve your problem. Let me know if this was not clear.- Prasanna:-)

RE: Displaying a Pop-up message in SSRS 2005

Peter.Groman — Thu, 23 Apr 2009 15:35:29 GMT

Interesting article. I thought I could put it to some good use. I tried to apply this to a report where I need to check that two sets fo date parameters are in "synch" with each other. The code works, and the pop-up appears, but clicking NO (or in this case cancel) I need it to halt the report & go back to the initial parameters screen. I figgure that I need to ad some code between lines 14 and 15 that will halt the report. How do I do that?Here is my code:1 Function CheckParams () as Boolean2 Dim prompt as String 3 Dim usrResponse As MsgBoxResult 4 prompt = ""5 usrResponse = MsgBoxResult.No6 If ((Report.Parameters!FromDate.Value <= Report.Parameters!CDEFromDate.Value) or (Report.Parameters!ToDate.Value <= Report.Parameters!CDEToDate.Value)) Then7 prompt = "You entered date ranges that are out of synch. Are you sure you want to continue?"8 End If9 10 If prompt <> "" Then11 usrResponse = MsgBox(prompt,4,"Parameter out of scope" )12 If usrResponse = MsgBoxResult.Yes Then13 Return TRUE14 Else 15 Return FALSE16 End If17 Else18 Return TRUE19 End If20 End Function

RE: Displaying a Pop-up message in SSRS 2005

Jirka — Thu, 23 Apr 2009 15:11:18 GMT

Unfortunately, I still can't find a resolution of the problem. Step by step debbuging shows me that the issue is related to the MsgBox function. I tried to add a refence to assembly Microsoft.VisualBasic (Microsoft.VisualBasic.dll), but it doesn't help. J.

RE: Displaying a Pop-up message in SSRS 2005

SanjayAttray — Thu, 23 Apr 2009 09:43:04 GMT

Just tried but failed. Throws some invalid error - rsReportParameterProcessingError. Don't know what the heck is that.'m not a .Net developer.

RE: Displaying a Pop-up message in SSRS 2005

Samir-404002 — Thu, 23 Apr 2009 05:09:49 GMT

I tried to achieve this some days ago. The problem here is when you are at the VS IDE the VB.NET code works fine. When the report is running on the Report Server it can't understand the VB.NET code as it runs in the Reporting Service environment. I wish there could be a way to embed some Javascript code into a report (as the report runs in the web environment) to achieve this. But I don't think it is possible at present.

RE: Displaying a Pop-up message in SSRS 2005

Jirka — Thu, 23 Apr 2009 04:36:07 GMT

Hi,I am not able to get it to work on my ReportServer. It reports "Error during processing of ‘IsvalidNumber’ report parameter. (rsReportParameterProcessingError)" error. Any idea?Thanks, Jirka

RE: Displaying a Pop-up message in SSRS 2005

Samir-404002 — Thu, 23 Apr 2009 02:45:29 GMT

Does the pop-up message (not the text box) works when the report is deployed on the Reporting Server?

Displaying a Pop-up message in SSRS 2005

Prasanna, MCTS — Wed, 22 Apr 2009 20:35:48 GMT

Comments posted to this topic are about the item [B]Displaying a Pop-up message in SSRS 2005[/B]