I want to show the user a message in the SSRS page saying "No records found." when the stored procedure does not return any values. Currently my reports shows the report headers. How do I do it? Please help. Thank you.
View Complete Post
I have a page setup that i would like to add a message when the record was successfully inserted. My button event code is as follows:
dac.insertAccessPointintosql(ddlAP, txtIP, ddlAPType, ddlAPFreq, ddlAPBand, txtLoc, txtUser, txtPass);
This works great and inserts, but would like to provide confirmation without having to send to another page.
Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )
I'm trying to figure out how to display a message box in a ssrs 2008 r2 report. I have custome code that validates a couple of parameters, and I want to display an error message if a user enters an incorrect parameter. I included 'system.windows.forms'
as a reference in my report, and tried to use 'system.windows.forms.messagebox.show(errormsg) but I keep getting an error. I created a hidden parameter that references the custom code.
Any help would be greatly appreciated.
Thanks in advance.
I have a requirment to display the page number on each page with a total number of records per page like this
Page 1 of 2 ---------------------------Total records: 11
Then on the last page I need to display the page number, the page Total and the grand total records fields like this:
Page 2 of 2--------------------------- Total records: 10 ---------------------------Grand Total records: 21
I tried different combinations but got errors like global execution field cannot be used in the report body, a text box could not be used in the report footer etc.
Thanks for your help.
I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.
The web application I am running was downloaded from the net (and has worked on other machines previously). Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp
I am a bit of a novice at this! But I am hoping someone can point me in the right direction!
I get the following error when I try and run the web application through IE:
"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."
(When i click the "click here" button it just goes to the IIS site).
Appreciate any help I can get!
I am using the asp.net membership.
On my site I have a Profile.aspx page.
In the code behind of this page, i get the logged in UserId (Guid) and pass
this to a method in my DAL. GetUserByUserId()
In my database I have a Table called Member which the method gets the data from
and displays details on the page about the user.
What I want to happen is when they have logged in and are diverted to Profile.aspx,
the page URL shows www.MyWebSite/Profile/UsersName
is this possible. In my Member table I have FirstName and LastName columns or do I get the
name from the membership table.
even better would be they go straight to www.MyWebsite/JohnSmith.aspx
thank you for any help
I am wondering if the Microsoft Report Viewer control allows for display changes. Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation. So does anyone know if the control allows for display changes from complete view to paginated viewing. I am using MS VS 2008 with ASP.NET 3.0. Thanks for your response.