Reportviewer DateParameters- Javascript Object Required? Asp.net Content Page?
Oct 23, 2007
I've got a report that works great from vs.net, however when I deploy and attempt to run from reportviewer over asp.net, the date parameters do not take. they reset to default and don't impact that report. Also the calendar icon, produces a javascript error "OBJECT REQUIRED" on the below line.
function GetObjectPosition(obj)
{
var totalTop = 0;
var totalLeft = 0;
while (obj != document.body)
{
// Add up the position
totalTop += obj.offsetTop;
totalLeft += obj.offsetLeft; //ERROR HAPPENING HERE.
// Prepare for next iteration
obj = obj.offsetParent;
My reportviewer is inside a content page. My client is ie 7.0
thanks for any help or information.
View 1 Replies
ADVERTISEMENT
Feb 14, 2008
I have a report with a fixed header that works properly when the query returns results (or fixedheader = false). However, when the result set is empty, I get tenacious client-side "object required" errors. Obviously I can either turn the fixedheaders off or disable debugging in IE, but is there a Microsoft fix for this problem?
View 1 Replies
View Related
Jul 12, 2007
Hi everybody,
I need to get the value of the ShowParametersPrompt property of the ReportViewer control.
This Reporting Services control is used in an asp.net 2.0 page.
With javascript I want to change the height of some elements of the page and this accordign to the height of the report viewer.
Can anybody help me to get the value of some properties of this control?
thanks in advance!!
best regards
Filip De Backer
View 4 Replies
View Related
Oct 22, 2007
Hi, I've got this ssrs 2005 report that works great passing a few
security related parameters from asp.net codebehind. However, there
are two date related parameters that won't be coming from my web form,
but rather from the report form itself. When I test the report's date
parameters from visual studio it work fine, but when I attempt the
same report from a reportviewer no matter what input I place on the
report's date fields or even if I select the date picker, the report
simply resets to default and reloads. And actually the date picker
from the reportviewer does not not even pop up.
Here's my aspx code:
<%@ Page Language="VB" AutoEventWireup="false"
Inherits="_ReportViewer" MasterPageFile="~/Main/MasterPage.master"
CodeFile="~/Reports/CashSales.aspx.vb" Title="Cash Sales" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms,
Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Content1"
runat="Server">
<rsweb:ReportViewer BackColor="Transparent" ZoomMode="PageWidth"
Width="100%" ProcessingMode="Remote" ID="ReportViewer1"
runat="server">
<ServerReport ReportPath="/Retailer/CashSales"
ReportServerUrl="http://myserver/reportserver" />
</rsweb:ReportViewer>
</asp:Content>
Note: I'm only passing the parameters that are not coming from the
reportviewer form.
the code behind:
Imports system.web.security.membership
Imports system.web.security.Roles
Imports Microsoft.Reporting.Webforms
Partial Class _ReportViewer
Inherits System.Web.UI.Page
Private Users As New Retailer.Core()
Protected Overrides Sub OnLoad(ByVal e As EventArgs)
Dim Roles() As String =
GetRolesForUser(Page.User.Identity.Name.ToString)
Dim cred As New Retailer.ReportServerCredentials("myuser",
"mypassword", "mydomain")
ReportViewer1.ServerReport.ReportServerCredentials = cred
Dim param As New ReportParameter("r_user",
Page.User.Identity.Name.ToString)
Dim param2 As New ReportParameter("r_role", Roles(0))
Dim p() As ReportParameter = {param, param2}
ReportViewer1.ServerReport.SetParameters(p)
ReportViewer1.ServerReport.Refresh()
End Sub
End Class
on my reportviewer form, at the top I have parameters for startdate
and end date, they are not set to internal or hidden.
If I select the calendar icon, i get a javascript error
Line: 606
Object Required
When I attempt to debug I get a Just-In-time failed : Unspecified
error. Check the documentation index for 'Just-in-time debugging,
errors' for more information. So pretty much I can't see the error or javascript in question.
If i enter anything in the date fields, it disregards them setting them to the defaults.
Again, if i run the report from my vs.net client (not using reportviewer), i can select the calendar and enter dates and it respects them.
Any chance I need to patch sql server or reporting services? maybe ie. I'm on IE 7.0.5730.11
Could my problem be that selecting items on the report itself fails to send my credential information from my codebehind?
Thanks for any help or information!
View 26 Replies
View Related
Mar 4, 2008
I am new to ASP.NET. At present i am developing a web application in which i need to insert data in database(MS SQL 2005) from a form which uses only HTML controls. I need to use HTML controls so posting of form to the server is not done and hence i need to generate HTML controls using javascript. So the data in the form must be stored in the database. How this data can be inserted in the database is the problem and i think that javascript might be the solution for it.
Sagar
View 3 Replies
View Related
Dec 20, 2007
hi ,
i am using sql server reporting services 2005.
When ever report is blank it gives me javascript error. In IE on bottom left it shows js error icon. Details of error are
Line: 13
Char: 692
error: Object Required
Code: 0
kindly guide me ...
thanks
Vishruti
View 6 Replies
View Related
Apr 2, 2008
I want to create the most effective way (google) to have content displayed on a web page.
Currently, we are updating to SQL and populating to web via calling SQL statements hardcoded to page. I want to know if this is ok to do, or should we be reading from a static XML file that is updated?
I think the XML is the way to go being that i may have answered my own question, but i was curious to what the experts on asp.net had to say.
Thanks,Nick
View 9 Replies
View Related
Oct 16, 2006
The following objects are placed on the Report body of the Report pane of SQL Server 2005 Reporting Services :
<textbox: expression1>
<textbox: expression2>
<table:table1 with at least 30 columns and 30 expressions>
<textbox: string1> - considered as the Title in the Footer section of the report
<texbox:string2> <textbox:expression3>
<textbox:string3> <textbox:expression4>
<textbox:string4> <textbox:expression5>
<textbox:expression6>
I can't find any explanation why is it string1 and string 2 of the footer section of my report displayed separately from the expression3 which is aligned on it and the rest of the object on the second page.
The expected design is that all Footer items should be displayed together of whether it is placed on the first page or on the last page.
As a workaround of this, I converted string 1 into an expression (Added = and enclosed the string with double quote).. As a result, all of the items in the Footer section are now placed together on the last page of the report.
I also remember one of the issue I encountered before where the Footer items where placed together on the first page and still have space at the bottom of the page, but then expression 6 is forced to display (alone) on the last page of my report.
I can't find any discussion related to this, I wish somebody could give me an idea why RS behaved like this.
Thanks in advance
View 1 Replies
View Related
Jan 12, 2007
Hi,
in one of our team projects users whom are members of the reporting services €œcontent manager€? role are not able to get onto the €œsql server€™s reporting services€? properties page of their team project. Instead of that page they receive the following error message:
The permissions granted to user '<UserName>' are insufficient for performing this operation. (rsAccessDenied)
With four eyes we double checked that the users really have the content manager role, we also tried all kinds of role combinations with no success.
The interesting thing is that as soon as they €˜only€™ in the Browser role they have access to that particular page €“ but as expected are unable to administer their team projects reporting services.
The reporting services forum doesn€™t really offer any answers to this problem, neither did goolge nor this forum.
Could anyone explain this behavior to me?
Pls let me know if you need additional information on this.
Thanks,
Tom
View 4 Replies
View Related
Jan 17, 2008
I am using a ReportViewer Control inside of a Windows Form and ran into an issue with the page navigation failing to update upon refresh (the report itself does refresh - the page navigation does not). If the initial report has one page and the subsequent refresh produces five pages, the page navigation window only shows one page. If you manually type in page two or three, nothing happens.
Here is a code snippet:
private void adpTaxServicesForm_Load(object sender, EventArgs e)
{
this.reportViewer.RefreshReport();
}
private void button1_Click(object sender, EventArgs e)
{
this.reportViewer.SuspendLayout();
this.reportViewer1.RefreshReport();
this.reportViewer.ResumeLayout();
}
Any help would be greatly appreciated...
Thanks,
-Fernando
View 1 Replies
View Related
Jul 13, 2007
I created a report with a parameter. The parameter was created using a dataset in the report designer. This works fine. I deployed the report (webhost4life) and the report runs fine in the report manager. I am able to select my casenumber click on the default view report button and it works.
Problem: I embedd the report into an aspx page frmReports1.aspx. I call this page from another page (form). the frmReports.aspx page comes up and displays the default drop down list box with the casenumbers (fine). I select the casenumber and click on the view report button and NOTHING. I here the postbacks taking place but all that happens is the default value appears in the drop down list box and the toolbar shows. I checked permissions and everything is fine. I searched the forum and thought i found the solution with the inLine HTML and Async (still nothing) I can only think that something is not going right with the parameter. Here is my html, and code behind code. any help would be greatly apprcieated.
Zachary
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="frmReports1.aspx.vb" Inherits="frmReports1" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<style>html,body,form {height:100%}</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="rvTest" runat="server" Width="600px" ProcessingMode="Remote" AsyncRendering="false" Height="75%" >
<ServerReport
DisplayName="Billable Hours"
ReportPath="/sddmtech/SnowandIce/rptHoursWorked"
ReportServerUrl="http://sqlreport01.mysite4now.com/Reportserver" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
aspx code behind
Imports System.Net
Imports System.Security.Principal
Imports Microsoft.Reporting.WebForms
Partial Class frmReports1
Inherits System.Web.UI.Page
Protected Sub rvTest_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles rvTest.Init
End Sub
<Serializable()> _
Public NotInheritable Class MyReportServerCredentials
Implements IReportServerCredentials
Public ReadOnly Property ImpersonationUser() As WindowsIdentity _
Implements IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property
Public ReadOnly Property NetworkCredentials() As ICredentials _
Implements IReportServerCredentials.NetworkCredentials
Get
' Put your login and password here this works fine
Dim userName As String = ""
Dim password As String = ""
Dim domain As String = ""
Return New NetworkCredential(userName, password, domain)
'********************************************************************************
End Get
End Property
Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
End Function
End Class
Public Function GetFormsCredentials(ByRef authCookie As Cookie, _
ByRef userName As String, _
ByRef password As String, _
ByRef authority As String) _
As Boolean
authCookie = Nothing
userName = Nothing
password = Nothing
authority = Nothing
'Not using form credentials
Return False
End Function
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load
'ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
'rvTest.ServerReport.Refresh()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
rvTest.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
End Sub
End Class
View 6 Replies
View Related
Mar 25, 2008
I am needing to export some files in landscape when I select the PDF option in the dropdown on the ReportViewer.aspx page. How do I do this?
View 1 Replies
View Related
Sep 15, 2006
I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the error: "Page navigation is out of range".
The application has session state turned off.
The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
How can I fix this problem?
View 15 Replies
View Related
Oct 19, 2007
Hi All...
Can anyone please help with embedding a chart into an aspx page ?? I have been busy with that for some time now, and still cant figure it out...
Thanks...
View 1 Replies
View Related
Jan 17, 2008
Is it posible to display the reporting services home page in the ReportViewer control?
I can display any of the published reports by setting the path e.g.,
serverReport.ReportPath = "/My Folder/My Report"
Is there a way of using the same command to show the home page?
I have tried a combination of "", "/" and "/Home" but none of them seem to work.
View 7 Replies
View Related
Aug 14, 2007
Hi
I had a problem accessing our report manager via the web front...
We deleted the virtual directories in IIS and then recreated them... this required us to make a change in the rsWebApplication.config file to include the URL in the ReportServerUrl tag before we could access the site again.
Now we have access to the site but when we attempt to view a report that we deployed to it - the report fails to render and returns a rsReportNotReady error, even though the report doesnt use a snapshot.
Furthermore, the strange thing is that the filters for the report don't display in their own collapsable bar as they used to before... they just display on the white part of the page. Neither does the reportviewer toolbar display properly. It appears as labels and textboxes going down the page and not in a toolbar as you might expect...
any help is appreciated... we suspect that it is some kind of configuration issue, but we have no clue where to begin...
View 1 Replies
View Related
Oct 30, 2015
How to creating a Table Of Content with page number in ( SSRS )SQL Server Reporting Services or when exported to pdf report.
FYI, Page number should be there in TOC.
Third party component is not accepted.
Dynamic Document Map will not work, as it cant get the page number.
I understand that there is no buildin feature which support this, but there should be some work around in SSRS or when export to PDF.
View 2 Replies
View Related
Sep 20, 2007
I have a VS2005 aspx page using the ReportViewer to view a SSRS 2005 Report, all running locally on a Vista Business laptop.
I have an error because the stored procedure that it executes does not have the rights to Drop or Create Tables.
I can Preview it fine in VS2005 and I can go to ReportManager and run it OK.
This all worked fine on my XP laptop, so I am guessing that it is the Account used by IIS(7) to get to the ReportServer.
Does anyone have any clues on this?
Does it use NT AUTHORITYIUSR or NT AUTHORITYNETWORK SERVICE, etc.
Thanks in advance
GC
Here's the message and the Tables do exist
An error has occurred during report processing.
Query execution failed for data set 'BranchHeadCountExistStartFinishTotalDS'.
Cannot drop the table 'ExistingStaff', because it does not exist or you do not have permission. Cannot drop the table 'Starters', because it does not exist or you do not have permission. Cannot drop the table 'Finishers', because it does not exist or you do not have permission. Cannot drop the table 'TotalFinish', because it does not exist or you do not have permission. Cannot drop the table 'StartFinish', because it does not exist or you do not have permission. The specified schema name "dbo" either does not exist or you do not have permission to use it.
View 1 Replies
View Related
May 15, 2006
I have the following error when I try to execute a DTS package.
All the package is doing, is a bit of WScript to map a drive (need it for other packages), so:
[code]
Function Main()
Dim WshNetwork
Set WshNetwork = WScript.CreateObject("WScript.Network")
WshNetwork.RemoveNetworkDrive "S:"
WshNetwork.MapNetworkDrive "S:", "\myserverfolder1folder2folder3folder4"
Main = DTSTaskExecResult_Success
End Function
[/code]
If I copy it out to a .vbs file and execute it logged in as the SQL Agent profile, it works. Execute the package under a job, or just execute it, it fails with the above error.
Any ideas?
View 4 Replies
View Related
Nov 21, 2007
Hi all,
I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql:
exec sp_attach_db @dbname = N'ssmsExpressDB',
@filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf',
@filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF'
GO
I got the following error message:
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express.
Thanks in advance,
Scott Chang
====================================================================================
I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise.
=======================================================
View 6 Replies
View Related
Aug 10, 2006
Hi,
I have designed a report in sql server reporting services using SQL Server Bussiness Intelligence Studio tool. I have applied sorting feature for a column. Sorting facility is working fine when there is one or more records.
Its giving "object required" Java Script error When there is no record. Kindly help me how to fix this issue.
Regards
Sagayaraj R
View 7 Replies
View Related
Nov 9, 2015
I want to grant CREATE, ALTER, VIEW permission to user but not DML permission?
So user can create Object but can't drop and delete it or user cant insert , update,delete from table.
I have Given db_datareader,db_denydatawriter, and granted create, select, alter permission.
But user is able to drop.
View 3 Replies
View Related
May 20, 2015
We have the customer requirement to display the footer of a SSRS Report fixed at the absolute bottom of a DIN A4 format page. The footer contains information like company address and stuff.
I searched quite a while on this topic and only found workarounds for SQL Server 2005 with Custom Code in the SSRS Report to calculate the size of the body content and then insert some empty lines to get the space needed to push the footer to the bottom of the page. But this won't work in SQL Server 2012. And I wasn't able to figure out how to achieve this yet.
View 2 Replies
View Related
Sep 26, 2014
Our Information Assurance (IA) office wants us to add a warning message popup box to our SQL 2012 SSRS server.The purpose is to force users to acknowledge the warning box popup before they get into to the SSRS main page.The message box would contain text stating Privacy Act information and or DoD monitoring consent...
View 1 Replies
View Related
Mar 8, 2005
Hi Folks,
Getting the following error after a DBCC CHECKDB
Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Trying to located the object that the allocation has gone to pot over.
Any quick way to resolve a datbase object using a page ID?
Thank In Advance
View 2 Replies
View Related
Sep 17, 2014
I got an error that says to run DBCC CHECKTABLE, but I can't find what table it is. It gives the db id and page Id. I ran DBCC PAGE but I could not figure out what object is using that page. I posted the error and dbcc page results below. Also, Slot 74 is not missing. I could not find m_objId or AllocUnitId in any system tables . Also, I got the same error for this db several other times. When I ran dbcc checkdb I did not get any errors. This is a SQL 2012 db created by SharePoint.
Why is m_nextPage and m_prevPage = (0:0) ?
Does the m_type=3 change how a page is linked?
I found Type 3 – text mix page. A text page that holds small chunks of LOB values plus internal parts of text tree. These can be shared between LOB values in the same partition of an index or heap.
Error2 from log--
Message
The Database ID 7, Page (1:14002), slot 74 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
Message
Error: 7105, Severity: 22, State: 6.
[Code] ....
View 2 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Jul 5, 2002
I am new, but am good at javascript.Can one use SQL in javescript, that is, to create good html forms whose buttons are linked to SQL datebases?
View 1 Replies
View Related
Jan 4, 2007
Hello everyone,
I am trying to implement two list boxes such that contents of one depends on selection in the other w/o reloading the page. I am using SqlDataSource object to retrieve data from SQL DB. When I am trying to write javascript for listbox population I run into an issue of not knowing which properties I have access to for SqlDataSource object. I need to know how many rows of information is there in the object and how to access that data. Can anyone advise on how would I do that, or direct me to a website that has a list of avalable properties?
Thank you!
View 3 Replies
View Related
Jan 12, 2008
Hello all
I need to fill javascript array from database on page load
I need your advice , any tutorial please ..
thank you
View 3 Replies
View Related
Mar 12, 2008
hi,
i have created a database where information on the web page is pulled out from the database. however i need to add javascript functionality to it. does anyone have any suggestions as to how i can achieve this and what is the best way to do it, eg, use dataview, gridview. if anyone thinks it would be easier for me to post up some of my code then i will upon request.
thanks for any help given, it is much needed
View 6 Replies
View Related
Oct 19, 2001
I would like to know if someone has any idea on how to make a "<select></select>" tag hidden. for a textbox it's simply:
<input type="hidden" id="textCustom2" name="textCustom2" value>.
Is there such a thing for options? a javascript perharps?
thanks.
View 1 Replies
View Related
Oct 23, 2007
Hi, I am trying to link to a page outside of reporting services from a report. I am using SQL Server 2005 Reporting Services [Standard Edition]. The hyperlink works if it is a straight URL, however, nothing happens if I modify it to use Javascript so I can open the link in a new window. I have found many posts on the web from others indicating it should be really easy, but I can not get the link to recognize ANY Javascript (also tried a basic alert with no luck).
The Javascript I am using is well formatted. I can place it into a test page and it runs fine. I can also RC and View Source on my report, grab the entire link, put it in a test page and it works fine. It just doesn't work from the report - ?
Any ideas?
Thanks in advance,
Francine
View 3 Replies
View Related