I am working on reporting services 2005. I have a problem setting table cell(textbox) borderstyle.Some cells are for 'Amount' summary, so I want to set those cells' top border as 'Solid' and It works, but at the same time, the table's top border is set 'Solid' as well, that is what I don't want. I only want to set the cell' border. So how should I do?
View 1 RepliesAny one used Microsoft Chart Control in SQL Server Reporting Service reports? Specifically the 2005 version?
View 3 RepliesI developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 RepliesI'm hardly an expert in css, so this is a bit frustrating. I have a grid that was filled with a repeater. I want each row to have a 1px border along the bottom to visually separate the rows.
#repeaterTable
{
border-left: 1px solid #A3A3A3;
border-right: 1px solid #A3A3A3;
border-collapse: collapse;
[code]...
I am using the html table in my aspx page.
On a button click i will find a cell using the inputs -row index and cell index . I am setting a black border to the cell as follows
[Code]....
On giving next inputs i want to reset the border of previously selected cell and set border to newly found cell.
i have no way in my hand to reset it.
how to set the space between the textarea and table cell.
it is always have a space at the bottom of the textarea and the bottom border of table cell
how to set using javascript
i have a gridview that directly bind to a dataset.Hence there is no column in code behind for me to control the boarder color and border style.I try my code in RowDataBound, but it does not take effect.
View 3 RepliesI deploy our web in IIS but when i try to use the reporting services
the message pops up:
The request failed with HTTP status 401: Unauthorized.
but when i try to build and debug from visual studio
i can use the reporting services
SQL server 2005
I have created a reports project through SQL Business intelligence studio, There is shared data source in it. The name of the sharedata source is MyReport.rds.I have added two new items to the project (reports folder) with names Survey.rdl and myProjectReport.rdl.
Before deploying it, I have specified three properties ( Throgh the project properties)
1) TargetDataSourceFolder=DataSources
2)TargetReportFolder= reports
3)TargetServerURL=http://localhost/reportserver and deployed it.
When I view it in the browser through
http://localhost/Reports/Pages/Folder.aspx
I get my folder called reports, and when I click on it I can see two reports, it works till this stage.
I want to use the same report in Visual studio 2008 so I have done the following in VS 2008
Visual Studio 2008
1) Added a page
2) Added Reportviewer Control to the page
3) Click Properties of Reportviewer and Choose <server Rreport>
4) Set Report Server URL: http://localhost/reportserver
5) set Report Path= /reports/
It comes up with the following error:
The path of the item '/reports/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
In SSRS 2005 I could select the header row of a table and in the properties window, expand the BorderStyle property and type Solid in the Bottom property and I would get a border at the bottom of the row containing my column headers. In SSRS 2008 I cannot do this. If I select the header row, the BorderColor, BorderStyle and BorderWidth properties do nothing when you expand them. If you try typing into them you get an error: "Property is not valid." So I selected the header textbox for one column and tried adding the bottom border to it, thinking that I might have to set each column individually, but the border does not appear for that column heading.
View 1 RepliesI'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet.
Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code..
I am trying to install just Reporting Services one a different server than the one that hosts the SQL Server 2005 database. Can someone point me to any type of documentation or a step by step instruction that can help. One more thing, none of the two machines is part of a domain.
View 2 RepliesI have a question that probably is the easiest one but can't figure it out, this is the deal; I have a table in reporting services that shows the names of employees and their position in a company, but what I want to do is to make the background gray of the entire row when the position is equal to "supervisor", do I made myself clear.
View 3 RepliesI have been building a report that shows several line graphs where the X axis is TIME.I have put each graph in the group header cell of a table in SSRS.I have tried many things to be able to line up the graphs (get the X axis to line up the same times vertically).I have used the align X-Axis option and it does not seem to work.
View 1 Repliesi have an already existing schema (in a xsd file). now i need to prepare a report, so in the rdlc page i take a table. now how can i set the schema as a dataset to the table?(i'm getting an error -- "the table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets.").
View 1 RepliesI am suffeering from Border style error.
my code is as below:
---------------------------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;[code].....
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
sometimes we need to use the asp image control so we can generate empty alt tags (visual studio 2005 does not render any attributes set
to an empty string). I know how to do this and also how to remove the border style that is automatically added
(http://blog.josh420.com/archives/2007/10/aspnet-image-control-border-width-inline-style.aspx).
We implemented this 6 months ago, however, only today have I discovered that it does not work when images are created dynamically.The first implementation was for asp images that have been set up within an aspx page:
-<asp:image runat="server" id="imgMast1" GenerateEmptyAlternateText="True" alternatetext="" imageurl="" />
The above works-no border style is rendered and the imageurl is populated in code.I have other pages where I'm building up sections dynamically using C# code, such as:-
System.Web.UI.WebControls.Image featureImage = new
System.Web.UI.WebControls.Image();
featureImage.GenerateEmptyAlternateText = true;
featureImage.ImageUrl = imageSrc;
divImage1.Controls.Add(featureImage);
divImageFeature.Controls.Add(divImage1);
When creating controls dynamically like this, the solution describe above does not remove the border style.
i we click a table cell than color is blue and we again click a different cell the first color is remove and second is bule
[Code]....
I want to display values aligned with a header grid. An employee might start from 7:00 a.m. to 9:00 a.m. for their first break. I am trying to display the values 7:00 and 9:00 aligned with the header.
View 1 Repliesi'm using sql server 2008 with advance services the below error is of reporting services.."The permissions granted to user 'sysnameASPNET' are insufficient for performing this operation. (rsAccessDenied)"when i'm trying to host appliction.. the above error is occured..it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host applicationthe above error is displayed.
View 2 RepliesI am new to Sql Server Reporting .How to customize sql server reporting services home page?
Means, how to put some background picture, how to change shapes of Tabs, how to Insert Header Picutre at the top and so on.
I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.
View 2 RepliesI am trying to implement custom sercurity modal in Reporting Services and i am not successfull. I am getting instance count error at below line.
// Loop through the instances of the server class.
ManagementObjectCollection instances = serverClass.GetInstances();
I posted my question in the below forum and could not get answer yet.
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/81b5a886-cca5-4d13-9805-c5b57c8a20e9
The link i used for forms authentication is as follows:-
http://msdn.microsoft.com/en-us/library/aa902691(SQL.80).aspx
What could be going wrong? Why i could able to cross "scope.Connect();" AND "serverClass.Get();" and getting below error
and could not get any instances. I saw a help link of similar problem and given full permission, but could not get instances at all.
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd5d19da-5cf5-45a9-bc77-7849a9565714
Exception Info:-
serverClass.GetInstances() {System.Management.ManagementObjectCollection} System.Management.ManagementObjectCollection
+ Count 'serverClass.GetInstances().Count' threw an exception of type 'System.Runtime.InteropServices.COMException' int
{System.Runtime.InteropServices.COMException}
IsSynchronized false bool
Code:-
const string WmiNamespace =
//@"\localhost
ootMicrosoftSqlServerReportingServicesv8"; // ORIGINAL
@"\localhost
ootMicrosoftSqlServerReportServerv9Admin"; // NEW ONE
//@"\localhost
ootMicrosoftSqlServerReportingServicesv9Admin"; // NOT
WORKING COPY
const string WmiRSClass =
//@"MSReportServerReportManager_ConfigurationSetting"; // ORIGINAL
// @"MSReportManager_ConfigurationSetting";
@"MSReportServer_ConfigurationSetting"; // NEW ONE
string fullWmiClassName = WmiNamespace + ":" + WmiRSClass;
ManagementClass serverClass;
ManagementScope scope;
//scope = new ManagementScope(WmiNamespace, connOptions);
scope = new ManagementScope(WmiNamespace);
// Connect to the Reporting Services namespace.
scope.Connect();
// Create the server class.
serverClass = new ManagementClass(fullWmiClassName);
// Connect to the management object.
try
{
serverClass.Get();
}
catch (Exception ex)
{
throw new Exception("Could not get WMI information. "
+ ex.Message);
}
It seems the Print Icon in Reporting Services is now throwing up a Windows Authentication box. Even when entering my domainusername and password, nothing happens. It just keeps popping up?
Our reporting service URL is a http://IP Address/........
Not sure if that has anything to do with it. We did add the I.P. in the Local Intranet Zones but still nothing works.