Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Displaying a Pop-up message in SSRS 2005 Expand / Collapse
Author
Message
Posted Monday, August 31, 2009 4:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Tuesday, February 16, 2010 4:09 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 2:35 PM
Points: 14, Visits: 57
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
Posted Friday, March 26, 2010 3:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 (26 views, 14.46 KB)
Post #890472
Posted Thursday, April 29, 2010 12:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:30 PM
Points: 131, Visits: 1,280
The problem is when you deploy report to web service is not working.

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

Post #912572
Posted Thursday, April 29, 2010 12:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:30 PM
Points: 131, Visits: 1,280
The problem is when you deploy report to web service is not working.

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

Post #912573
Posted Wednesday, June 30, 2010 1:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 5:42 AM
Points: 32, Visits: 130
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
Posted Tuesday, July 13, 2010 6:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 11:20 AM
Points: 1, Visits: 8
Its working as expected from the IDE. But need to check from report server.
Post #951349
Posted Monday, September 20, 2010 11:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Thursday, March 10, 2011 2:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 28, 2014 9:29 AM
Points: 6, Visits: 178
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
Posted Sunday, March 13, 2011 7:13 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 2:54 PM
Points: 41, Visits: 72
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
Post #1077518
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse