Displaying a Pop-up message in SSRS 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prasanna Jung Malla... » Displaying a Pop-up message in SSRS 2005

31 posts, Page 3 of 4

«««1 2 3 4 »»

Displaying a Pop-up message in SSRS 2005

Rate Topic

Display Mode

Topic Options

Author

Message

FVC

Posted Monday, August 31, 2009 4:25 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 30, 2010 1:29 AM
Points: 46, Visits: 66

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 ...

Post #779781

TEwing

Posted Tuesday, February 16, 2010 4:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:08 AM
Points: 5, Visits: 53

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.

Post #866579

Shiva Thomas

Posted Friday, March 26, 2010 3:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 19, 2010 1:39 AM
Points: 1, Visits: 16

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:

IF (@intNumber > 55 OR @intNumber < 15)
	RAISERROR('Error: Your number must be smaller than 55 and bigger than 15', 16, 0);

Syntax:

RAISERROR (@ErrorMessage, -- Message text.
               @ErrorSeverity, -- Severity of >=16 stop the script and the Report execution.
               @ErrorState -- State.
               );

Post Attachments

ScreenShot_2010-03-26_001.png (25 views, 14.46 KB)

Post #890472

smansky

Posted Thursday, April 29, 2010 12:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:20 AM
Points: 131, Visits: 1,190

The problem is when you deploy report to web service is not working.

Error during processing of ‘parameter’ report parameter. (rsReportParameterProcessingError)

Crying

Post #912572

smansky

Posted Thursday, April 29, 2010 12:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:20 AM
Points: 131, Visits: 1,190

The problem is when you deploy report to web service is not working.

Error during processing of ‘parameter’ report parameter. (rsReportParameterProcessingError)

Crying

Post #912573

Jason Thomas

Posted Wednesday, June 30, 2010 1:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:05 PM
Points: 32, Visits: 122

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
My Blog

Post #945237

nraju1982

Posted Tuesday, July 13, 2010 6:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 13, 2010 6:01 AM
Points: 1, Visits: 1

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

Post #951349

kpsr_kpsr 63487

Posted Monday, September 20, 2010 11:35 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 18, 2012 12:27 AM
Points: 83, Visits: 473

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?

Post #989948

Mr.wOw

Posted Thursday, March 10, 2011 2:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 3:07 AM
Points: 6, Visits: 171

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

Post #1076078

Prasanna, MCTS

Posted Sunday, March 13, 2011 7:13 PM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, March 13, 2011 7:12 PM
Points: 40, Visits: 61

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

§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

always Happy, always Prasanna Smile

Post #1077518

« Prev Topic | Next Topic »

31 posts, Page 3 of 4

«««1 2 3 4 »»

Permissions