Buttons
Feb 20, 2007Hi.
Is there a way to insert a command button or flash button on to a report?
im using SSRS 2005 with VS 2005
Thanks...
ADVERTISEMENT
Simple Navigation Buttons.....
Jan 24, 2007 Hi all,
I'm trying to design a website with my old MS Access Application as a template, because my users know that style. I use textboxes to display data from the MSSQL 2005 database, one record and 20 fields per page ....and i would like to navigate through the records with 4 buttons: first, last, next and prior, placed on the page.I tried a lot of things, and my last attemt was a Stored Procedure with a Cursor to do the trickbut.... it did not work
It's very easy to do this in MS Access.
Can anyone tell me a simple way to do this ?
Scripting Dynamic Buttons
Apr 29, 2008Ok, I have tried everything to make this work, including a very extensive search on the web to no avail.
What I am trying to do, is through a web page a created, auto pull 3 tables out of a SQL view and display the data real time. This part works, and I am further able to create dynamic hyperlinks based on the data pull.
Where the problem arises is in creating a submit button that will run an application. The code to do this is dependent on the running SQL query loop. Here is what I have.
_______________________________________________________________
<html>
<head>
<title>Computer / MAC Address Pull</title>
<meta name="Microsoft Theme" content="none">
<meta name="Microsoft Border" content="none">
</head>
<body>
<P>
<H2 ALIGN= CENTER>Computer / MAC Address Pull</H2>
</P>
<TABLE WIDTH= '90%' BORDER='0'ALIGN= CENTER>
<TR><TD WIDTH= '10%'Align=center><B>Computer Name</TD>
<TD WIDTH= '8%'Align=center><B>IP Address</TD>
<TD WIDTH= '10%'Align=center><B>Mac Address</TD>
<TD width= '8%'Align=center><b>Power On</TD>
<TD width= '8%'Align=center><b>Count</TD>
</TABLE>
<%
dim rs
dim int
int = 1
dim input
dataSent = Request.Form("t1")
cString = "Provider=SQLOLEDB;User Id=****;password=****;Initial Catalog=dareporting;Data Source=****;"
set rs = CreateObject("ADODB.Recordset")
rs.open "select computer, address, mac from view_mac_address" ,cString
rs.MoveFirst
Response.Write "<input type=textbox id=sqlsearch>"
Response.Write "<input type=button value=submit id=submit>"
function WOL()
Dim Input
input = rs("mac")
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "C:mc-wol.exe " & input
end function
Response.Write "<TABLE WIDTH= '90%' BORDER='1'ALIGN= CENTER cellspacing=0 cellpadding=0 mso-border-alt:solid navy >"
Do while NOT rs.EOF
dim mac1
Set WshShell = WScript.CreateObject("WScript.Shell")
'mac1="WshShell.Run 'C:mc-wol.exe ' &rs('mac')"
mac2="WshShell.Run 'C:mc-wol.exe ' &rs('mac')"
Response.Write "<TR><TD WIDTH= '10%'Align=center><a href='https://"&rs("address")&":2000'>" & rs("computer") & "</TD>"
Response.Write "<TD WIDTH= '8%'Align=center>" & rs("address") & "</TD>"
Response.Write "<TD WIDTH= '10%'Align=center>" & rs("mac") & "</TD>"
'Response.Write "<TD WIDTH= '8%'Align=center><input type=button value='start' onclick='WOL()'></TD>"
Response.Write "<TD WIDTH= '8%'Align=center><input type=button value='start' onclick="&mac2&"></TD>"
Response.Write "<TD WIDTH= '8%'Align=center>" & int & "</TD>"
int = int + 1
rs.MoveNext
Loop
Response.Write "</TABLE>"
%>
<p></p>
</body>
</html>
___________________________________________________________
Essentially what this does, is display with headers, a listing of my domains computer names, IP addresses, MAC Addresses, and a Start button. Since this is tied to my SQL database you wont be able to view the output, but what I want to do is, in the loop, have the Start button grab the running mac addresses and place it into the following code:
__________________________________________________________
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "C:mc-wol.exe " &rs("mac")
__________________________________________________________
This will allow me to (I hope), on click, open a command prompt, run the code with the respective mac address, and start the computer.
Where the problem lies, is that I can not figure out how to encapsulate the mac address inside that code while in the loop... any ideas would be greatly appreciated! If you have any questions, please let me know.
SQL Query Paging With Buttons
May 31, 2006hello, I have this project that I can't find it.
let's say we have more than 100 000 rows in a table called table 1, so if we do: SELECT * FROM TABLE1
the result will be dispalying all the rows with a large scrollbar.
But there's a new TSQL in SQL 2005 "ROW_COUNT" which will help to do the paging. so I have found the procedure but all I need now is to display NEXT and PREVIOUS button in the results in order to switch between the pages. So please any help, Thank you
Navigation Buttons Dimmed
Apr 11, 2007Anyone know why my navigation buttons on my reports is always dimmed so that I can only see the very first page of every report? I even spent some time with a Microsoft SQL Server engineer trying to figure this one out and he wasn't able to figure out why?
I tried to attach a picture but I guess pictures aren't allowed. The first page, previous page, next page and last page buttons displayed as arrows on the top left of the reports are always dimmed on every report even though they have multiple pages.
Has this happened to anyone and how did you get it fixed?
Thanks
What Are The Algorithms Used In The Different Feature Buttons In The DM Add-IN For Excel?
Jun 19, 2007 I was just wondering on what algorithms was used in the different feature buttons in the Excel Add-In? For example, forecast, what algorithm was used in order for it to create the forcasting?
Populating Radio Buttons - Access Vs. MSSQL
Dec 10, 2007Have recently migrated an Access database to MSSQL.
The following code worked in Access but fails in MSSQL
<input <%If (CStr(Recordset1.Fields.Item("Disclose").Value) = CStr("TRUE")) Then Response.Write("CHECKED") : Response.Write("")%> type="radio" name="Disclose" value="1">
<input <%If (CStr((Recordset1.Fields.Item("Disclose").Value)) = CStr("FALSE")) Then Response.Write("CHECKED") : Response.Write("")%> name="Disclose" type="radio" value="0" >
In Query Analyzer, when I run SELECT Disclose from TABLE, it returns the number 1.
On an ASP page, when I run Response.Write(Recordset1.Fields.Item("Disclose").Value) it returns TRUE.
Have tried changing the = CStr("TRUE") portion to = 1 but it fails to work either way.
Any ideas?
Adding Custom Buttons To The Parameters Toolbox?
May 3, 2007Hi,
I am interested in adding custom buttons to the parameters toolbox (under "View Report"). I'm trying to provde a way for users viewing the report to go "Back" or up a level (in the drill through reports). Does anyone have any information on this topic, or know if it's even possible?
Thanks in advance,
-Brandon
Next And Previous Buttons Working With Unbound Data?
Apr 3, 2008Hello.
I am trying to implement Next and Previous buttons on a web page that uses CE as the database, and having some trouble getting the logic figured out. The data is unbound and I'm not returning it all at once, so paging through it an item at a time isn't possible. Because of the high volume, I was thinking I could pass in the record ID each time I need to retrieve a record and every time the user hits the next or previous button, I'll just requery for the record I need. Does that sound reasonable?
In my main page, I'm using the ViewState to store the record ID that I need to acquire. This part works--it gives me the highest ID number (so that I get the most recent record):
if (!IsPostBack) {
// Start out with the most recent record in the selected category. GetHighestConfessionID() will return
// the ID of the most recent confession.
ViewState ["ConfessionID"] = mySearch.GetHighestConfessionID (int.Parse(ViewState["Category"].ToString()));
}
Here's where the trouble comes in--I need to go to the next record in the database when the user hits Next, but I don't know how to do that. My big idea was to issue this command in the Next button:
ViewState ["ConfessionID"] = GetNextConfessionID (ViewState ["ConfessionID"]);
But I'm not quite sure how to increment/decrement my ConfessionID, since it's not guaranteed to be sequential (a record could have been deleted).
If the user hits Next, for example, I need to query for the next record ID, but I'm not sure how to do that since they're not necessarily sequential.
Is there a simple solution? I feel like I'm making a mountain out of a molehill.
Thanks in advance for any ideas.
Administrator Cannot See Administration Toolbar, Buttons And Shortcuts On Report Manager
Dec 23, 2006Hy everybody.
I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.
Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.
There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.
There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.
I really hope you guys can help me with this.
Thanks in advance.
JC
How To Create Radio Buttons For Parameters In Reporting Services 2005
Nov 15, 2007
Hello,
I am creating a report that the user will pick a value from about 6 items. The project manager would like these values to be represented as radio buttons on the ReportViewer control. I am unable to determine how do create these 6 radio buttons.
Here is a simple example to demonstrate what I need. Lets say the report returns the total number of fruit in a stores inventory. The choices are: Apple, Banannas, Oranges, Grapes, Cherries, Water Mellon.
I have a variable @Fruit that I would like populated by the user and I want them to select which piece of fruit they want to see by selecting a radio button. Is there a way to do this using Reporting Services 2005 Report Designer?
Thanks,
Flea#
How To Not Auto Generate A Report, How To Use A Null Checkbox On A Param With Available Values, How To Add Back/forward Buttons?
Apr 3, 2008Hey all,
1) I have a report with many parameters that I want users to be able to pick from. Allow them to pick 1, many or all to build their report dynamically. I'm all set on the TSQL side, but on the Reporting Services side I have to allow each parameter to be null with a default of NULL. In by doing this, the report will auto run, which I do not want to happen. The only resolution I've found thus far was by adding a parameter that does nothing, with a NULL default value. Yet It sticks out like a sore thumb on the report and I want to get rid of it. If I check in "Hidden" in the parameter options, my report errors out stating that the parameter requires a value.
2) Is it possible to have a parameter that has available values from a dataset have a NULL checkbox like those of parameters that do not have available values?
3) Is it possible to add back/forward buttons inside of a report instead of just at the report header by default?
Thanks!
Sort Buttons Grayed Out In &"Data In Table&"
Aug 17, 2006Hi -
This is a newbie question. For some reason when I view the contents of tables I have created on my SQL Server (version 7) database, the sort buttons in the "Data in Table" window are grayed out.
Do I need more permissions? How do I fix this?
Thanks.