Reduce Row Spacing In Financial Reports - RS2005

Jan 30, 2007

I am using RS 2K5 to develop financial reports, with plenty of figures that must fit in a page.

I use tables for example. Fonts cannot be set smaller than 8pts.
I have also tried to decrease row height and to disable the "can grow to fit content" option, but of course in this way the text gets cut of in its lower part.

How can I do lines more compact? I need to reduce line spacing and to make the data more dense. Currently it looks very sparse.

Is it a known limitation for RS? Any workaround available? Any online example with dense reports?

Thank you.

View 1 Replies


ADVERTISEMENT

Drill Through Reports In RS2005

Jul 23, 2007

How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).

View 1 Replies View Related

RS2005 Reports To AS2000 Cubes

Jul 13, 2007

Hello,

I am using RS 2005 to design reports.

There's no problem when I connect to an Analysis Services 2005 cube.

But when I try to connect to an AS 2000 cube (Foodmart)...



I have read in this forum that I can use "Microsoft SQL Server Analysis Services" provider (or OLE DB)...



Can someone help me please!!

Thank you

View 2 Replies View Related

Spacing Issue

Mar 12, 2007

This is in ssrs 2000, so I think I'm in the right place.

I have a list and some matrices in the list that are not nearly as wide as my list is (the list needs to be wider than the matrices), and that white space is getting tacked on to the end of my matrices, resulting in an extra page. Maybe I'm just missing something, but how do I eliminate this?

View 1 Replies View Related

Set Spacing In Text Box

May 19, 2008

Hi,

I'm using SSRS 2005 and having problem trying to set spacing for a textbox. What happen was, I have a description that would goes/expand to 3 lines depending on what user selected from the multi-value parameters. When I look-up the help, it has something like so:

To change the spacing between lines of text




In Report Builder design mode, select a text box or cell(s).


On the Format menu, select Font.

The Format dialog box opens with the Font tab selected.


In the Line spacing drop-down list, select a point size.


Click OK.
The problem is, I can't see this Line Spacing option. All I see is Bold, Italic and Underline. Am I missing some patches. Any input is very much appreciated. Thanks.

View 4 Replies View Related

Column Naming/spacing

Apr 19, 2007

Is it possible to have spacing within a column name? Something like"column name." I can do it from EM but won't let me do it in queryanalyzer. Can someone tell me the command to do this in queryanalyzer? Thanks!

View 1 Replies View Related

Spacing Problem In SQL Server

Jul 20, 2005

Consider a scenario, I am a DBA for the Database server where thesize of the hard disk is 100 GB. On that database server, i have theDatabase whose size is 40 GB. Also, i restrict the size of thedatabase file to 95 GB, by specifying the "maximum file size" to"Restrict file growth" option , under the "file properties".I then copied a DAT ( or some other file ) on the same database serverthat is having the size of 45 GB.Now when the Database file size increases, it will give an error notbecause of setting the "Restrict file growth" option to 95 but thereis no space on the Hard Disk.My question to you DBAs is that, how will i know that hard disk isbecoming full ? I want to get noticed when the Server's Hard Disk sizeis at some specified threshold value.Pls help in this regard.

View 1 Replies View Related

Column Spacing Issue

May 30, 2007

Hi,



I'm developing a report at the moment that uses a sub report twice on the same report (legal legislation type of thing, requires information to be displayed twice.). In the first location the one column is heavily spaced to the right (though not designed this way), causing a new blank page to be created when exporting, but at the other location (on the same report, same data), the spacing is normal. What could be causing this?



Thanks,

View 1 Replies View Related

Drill Down Report Spacing Issue

Apr 16, 2007

I have created a drill down report, using text boxes. When the report is not drilled down, all root nodes are collapsed, the spacing is really weird between them. For
example.


+ Node A
+ Node B


<a bunch of white space>


+ NodeC.


I want all the nodes to be one after each other. Thanks for any help you can provide.

View 1 Replies View Related

How To Determine Which Service Pack Level Your SQL Server Is Running And Column Name Spacing Bug?

Aug 10, 2007

I have visual studio 2005 with XP home. I'm trying to find out which service pack my SQL server is running as I've been told that Service pack 2 has a few bugs.

For example ADO Applications Report a Syntax Error When Column Names Contain Spaces. This appears to be an error i am recieving. I just wanted to confirm that it is a microsoft bug rather then something Im doing wrong.
Microsoft meantions the bug here: http://support.microsoft.com/kb/264687



I've been looking everywhere. I do not have the "query analyzer window" where you can find this out as I have VS 2005. How would I find this out.

Thank you

View 6 Replies View Related

Reporting Services :: Double Line Spacing In Large Textbox In SSRS

Mar 3, 2010

How do I achieve double spacing of lines in a large text box in SSRS?

View 6 Replies View Related

Financial Year

Sep 22, 2006

how can you store a financial year in sql 2005

View 5 Replies View Related

Financial Functions In SQL Server

Apr 10, 2002

Do we have any builtin functions in SQL Server for certain financial calculations. For eg., like the PV, FV functions in VB

If not, how else do we achieve this thru' a SQL Server stored procedure?

Thanks in advance,

Siva

View 1 Replies View Related

Group By Financial Quarter

Dec 4, 2007

I have a transaction file with Company_code,Gl_code,Amount,Transaction_Date

I want to sum the amount based on a Company_Code,Glcode for every financial quarter(01/04/2007-30/06/2007,01/07/2007-30/09/2007 and so on).

Expected Output

Company_Code,Gl_code,Quarter_1,Amount_1,Quarter_2,Amount_2,Quarter_3,Amount_3,Quarter_4,Amount_4

Regards

Nirene

View 6 Replies View Related

Financial Functions For SQL Server

Aug 17, 2006

Hi everybody,

Does anyone have financial functions to be run in SQL Server 2000? For example, future value, interest rate, payments, and so on. Or where can I find them on Internet?

Thanks in advance

Jaime

View 3 Replies View Related

Reporting Financial Ratings

Sep 10, 2007

I'm running into 'CLS-compliance' problems trying to use characters such as "+" and "-" as reporting fields. For example, Standard and Poors ratings have these characters to indicate a notch between main letter rating categories. I have reports that need to display distributions of these various ratings in column charts. However, the X axis labels refuse to print because of these characters!

Any suggestions? This is an awfully common type of labelling in this business!

Thanks

View 1 Replies View Related

Help Please. Select Data Between Financial Year

Feb 28, 2007

How can I select data between a financial year. The financial year begin in july(7) and end in june(6).

Lets say I want all data between the begining of financial year (7) to January (1)

so I would select all data between 7 and 1. (6 months period)

and lets say I want all data between the beginning of financial year(7) to october (10) so I would just select all data between 7 and 10. (3 months period).

Below is data from a customer table.


Customer Name Month
----------------------------------------------------
APPADENE FOREST PRODUCTS7
APPADENE FOREST PRODUCTS8
APPADENE FOREST PRODUCTS9
APPADENE FOREST PRODUCTS10
APPADENE FOREST PRODUCTS11
APPADENE FOREST PRODUCTS2
APPADENE FOREST PRODUCTS3
APPADENE FOREST PRODUCTS4
APPADENE FOREST PRODUCTS5
APPADENE FOREST PRODUCTS6
BLUELEAF CORPORATION PTY LTD3
BLUELEAF CORPORATION PTY LTD4
BLUELEAF CORPORATION PTY LTD5
WESPINE INDUSTRIES PTY LTD5
WESPINE INDUSTRIES PTY LTD6
WESPINE INDUSTRIES PTY LTD3
WESPINE INDUSTRIES PTY LTD4
WESPINE INDUSTRIES PTY LTD5
WESPINE INDUSTRIES PTY LTD6
BLUELEAF CORPORATION PTY LTD6
WESPINE INDUSTRIES PTY LTD8
WESPINE INDUSTRIES PTY LTD9
WESPINE INDUSTRIES PTY LTD11
WESPINE INDUSTRIES PTY LTD12
NANNUP TIMBER PROCESSING PTY LTD3
WESPINE INDUSTRIES PTY LTD1
NANNUP TIMBER PROCESSING PTY LTD4
NANNUP TIMBER PROCESSING PTY LTD5
NANNUP TIMBER PROCESSING PTY LTD6
WESPINE INDUSTRIES PTY LTD3

View 2 Replies View Related

Reporting Suspicious Financial Transactions

Jul 20, 2005

I want to monitor any suspicious financial transaction which takeplace in a bank through electronic transfer.There are three tables Customers, Account and transaction_type.How can I write a SQl to report the following:Detect an outbound Electronic transfer that is unusually high,compared to a set threshold.For each customer, generate alerts if any outbound Electronic Transferexceeds threshold.Detect Electronic Transfer that are high, compared to a set threshold.For each customer, generate alerts if any set of last 5 outboundElectronic Transfers exceeds the set threshold.Detect Electronic Transfer that are high, compared to historicalbehavior of the customer.For each customer, generate alerts if any set of last 5 ElectronicTransfer (the average of all sets of 5 outbound Electronic Transfer +2standard deviation points)

View 6 Replies View Related

Expert DBA Needed For A Large Financial Company!

Sep 10, 2004

I know, it's a job posting site, but our company is urgently looking for an expert senior level sql server DBA who can be rated as 9.5 out of 10 in sql server dba activities who are hard to find! Top hourly pay on a long contract in East Coast! so anyone interested? please rush resume to MessageDBfan@yahoo.com

View 1 Replies View Related

SQL Server 2012 :: Spreading Value Across Financial Year

Feb 28, 2015

I have a table which can be downloaded from the link below. The table contains property Market Rent and period the new rent is applicable. I need to generate a report with parameter ( year and month) so when the user inputs year and month the associated market rent amount for that month is listed.

For example if the 1st market rent update was done in June 2014 ( $300) and the 2nd in Dec 2014 $(350), the property market rent from June to Nov should be $300 and from Dec 2014 till the next rent update $350. So if user inputs year 2014 and month August, the amount is $300 and if the user enters the year 2015 and month March amount is $350

[URL] ....

Below is the table with sample data

DECLARE @table TABLE ( PropCode INT ,PropStartDate DATE ,PropEndDate char(10) ,PropRentStartDate DATE ,PropRentEndDate DATE ,MarketRent INT)
INSERT INTO @table (PropCode,PropStartDate, PropEndDate,PropRentStartDate,PropRentEndDate, MarketRent) VALUES
(2718, '2013-01-30', 'NULL', '2012-11-29', '2013-07-21', 289.20) ,(2718, '2013-01-30', 'NULL', '2013-07-22', '2013-11-24', 289.20) ,(2718, '2013-01-30', 'NULL', '2013-11-25', '2014-06-14', 289.20) ,(2718, '2013-01-30', 'NULL', '2014-06-15', '2014-11-30', 299.18) ,(2718, '2013-01-30', 'NULL', '2014-12-01', '2015-01-02', 299.18) ,(2718, '2013-01-30', 'NULL', '2015-01-03', '2050-01-01', 310.00) ,(3901, '2014-05-27', 'NULL', '2014-06-09', '2014-11-30', 400.00) ,(3901, '2014-05-27', 'NULL', '2014-12-01', '2050-01-01', 400.00) ,(3960, '2014-10-31', 'NULL', '2014-11-05', '2016-11-05', 470.00)

Select * from @table

View 3 Replies View Related

Calculate Contract Days In Financial Year

Feb 4, 2015

I have a table with 3 fields: Contract_No, Start_Date, End_Date. I need to calculate how many of the days between the Start and End dates fall within each financial year (FY) beginning 1st April and ending 31st March.

So for example if the Contract Start_Date is 26/01/2012 and the End_Date is 20/05/2012 or is null then the number of days for 2012 FY is 49 (counting from 01/04/2012 to 20/05/2012).

If the End_Date is null for the same contract, then the number of days for 2012 FY would be 365.

Since the contract period from Start_Date to End_Date might span more than one or even several FY I need to be able to show this in columns seperately for each FY. What is the best way of achieving this?

View 6 Replies View Related

Aggregating Financial Data To 1 Minute Intervals

Aug 19, 2006

I'm trying to create a query to return Open, Close, Max and Min Price for each 1 minute interval. Source data has two fields - Price, and Datestamp at 5 second intervals.

I can calculate the Max and Min (below) and set the datestamp to the middle of the interval, but get stuck on how to also return the Open and Close price for each interval.

SELECT MAX(price) AS MaxPrice, MIN(price) AS MinPrice,
DATEADD(ss, 30, DATEADD(n,DATEDIFF n, '1/1/2006', DateStamp),'1/1/2006')) AS DateStamp
FROM MasterData
GROUP BY DATEDIFF(n, '1/1/2006',DateStamp)

Any ideas?

thanks in advance.

View 1 Replies View Related

Design Question Relating To A Financial Application

May 20, 2008

EDIT: Please skip over this and go to the 2nd post. After writing this, I realized it may be too complicated to comprehend, so I tried to simplify with another example which is found in the 2nd post. Or if you want you can read this one and try to understand it.


I would like to go over a design we came up with to handle a certain reporting requirement from an OLAP cube to see if this is a good approach. Also, I would like to hear about other designs that we can consider.

Here is the condensed version of the requirement.

We are measuring the performance of a bunch of portfolios. So among other dimensions, we have a portfolio dimension that holds the list of portfolios we are tracking. In a typical portfolio analysis, an analyst almost always looks at a portfolio's measures along side a benchmark portfolio's measures. A benchmark is another portfolio against which a selected portfolio is compared. So, for a given portfolio, there is a determined benchmark portfolio.

For example, an analyst might want to look at a measure called Annual_Yield for a portfolio called Portfolio_A. There will be an attribute on the member Portfolio_A that tells us what its benchark portfolio is. That attribute will basically be another member from the portfolio dimension. So, as a function of what an analyst chooses as the first portfolio (the subject portfolio), the cube should be smart enought to know what to select as the second portfolio (the benchmark portfolio).

To implement this, I am proposing the following structure for the table that will create the portfolio dimension.

PortfolioID, PortfolioName, Attr1, Attr2, ..., AttrN, BenchMarkID
1, Portfolio_A, blah, blah, ...., blah, 3
2, Porfolio_B, blah, blah, ...., blah, 3
3, Portfolio_C, blah, blah, ...., blah, null
4, Portfolio_D, blah, blah, ...., blah, 3
5, Portfolio_E, blah, blah, ...., blah, 6
6, Portfolio_F, blah, blah, ...., blah, null

So, the above data says that Portfolios A, B, and D uses Portfolio C as their benchmarks. And Portfolio E uses Portfolio F as its benchmark. Lastly, if a portfolio is used as a benchmark for other portfolios, then its BenchmarkID is null, meaning it doesn't get compared to anything, thus Portfolios C and F have null BenchmarkIDs. With this data, I would create a hierarchy in the portfolio dimension that has two levels. At the top level, there will be a portfolio and if that portfolio has a benchmark, then it will drill down to it.

With a portfolio dimension designed as such, I envision a fact table that looks like the following.

PortfolioID, SomeOtherDimIDs,....., Annual_Yield
1, , blah, ,....., 10%
2, , blah, ,....., 7%
3, , blah, ,....., 0%
4, , blah, ,....., 15%
5, , blah, ,....., 20%
6, , blah, ,....., 9%

So, going back to the original report which was looking at Annual_Yield by Portfolio_A, I would do an MDX statement such as

With Set [PortfolioAndBenchmark] As
DESCEDANTS(Portfolio_A)

Select
[Annual_Yield], [PortfolioAndBenchmark] On Columns,
Whatever Other Dimension On Rows
From
[Cube]

Does this make sense? The only concern I have is that I don't want the measures to aggregate along the portfolio hierarchy.





View 1 Replies View Related

Users In RS2005

Feb 11, 2007

How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005.

View 1 Replies View Related

Help With RS2005 And Internet

May 5, 2008

Hi all,

I really need help with this issue.

I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.

I'm stomped...

The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports

The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports

How can I configure my server to stay on my secure address?

Thanks
Aiwa

View 4 Replies View Related

RS2005 And SQL2000

Aug 11, 2006

Hi,

As per my reading, using RS2005 with backend database as SQL 2000 is
possible.

Can anyone tell me whether RS2005 connect to SQL 2000 database on same same
machine. i.e. in short can RS2005 reside with SQL 2000?

Which edition of RS 2005 support backend as SQL2000?

TIA,
Tanmaya

View 3 Replies View Related

SQL Server 2012 :: Date Table For Financial Year

Dec 23, 2014

I need to create a table which holds date information for our financial year.

I have all the dates between now and 2045 and the start of the week and the end of the week. What I also have is the first sunday of the previous week in the spreadsheet too.

Please see below attachment

What I need to autofill once I import these three dates into a database is the week and the month.

The difficulty surrounding the month is that, we start a new month on the FIRST Sunday of the month.

So dates 07/04/14 to 04/05/2014 would be month 1.

Month 2 would begin on 05/05/2014 as it is the day after the first Sunday of the month, and so on....Month 5 would start on the 04/08/14.

Need to script something that would automatically calculate the week and month for me on the basis on above, if I have the start date, end date and 1st sunday already in a table?

View 9 Replies View Related

Using MDXScope Statement In RS2005

Apr 13, 2007

Has anyone used the MDX Scope Statement in a RS2005 Reporting Services

Report?



I am not sure if the scope / end scope statement will work in a RS report script.



Thanks,



View 4 Replies View Related

Flow Layout In Rs2005

Jan 10, 2007

I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.

a quick example

A full address would look like this..

customer name
address line 1
address line 2
town
county
post code

if address line 2 isnt given, I get:

customer name
address line 1

town
county
post code

but I want:

customer name
address line 1
town
county
post code

Can anyone help?

Many thanks,

Paul

View 4 Replies View Related

Trend Lines In RS2005

Jan 24, 2007

Are trend lines supported in RS2005, and if so how do you produce them?

Thanks,

Peter Cwik

Trizetto

View 11 Replies View Related

RS2005 Setup Blues

Jul 10, 2007

I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:ReportingServices2005MSSQL.1Reporting ServicesLogFilesReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)




Please advise.

The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>



Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.



What am I missing here ..?

View 6 Replies View Related

Deploy Problem; RS2005

Feb 9, 2007


I am not able to deploy report to report server, I have this error:
The permissions granted to user <IUSR_MashineName> are insufficient for performing this operation.

View 2 Replies View Related

RS2005 On Vista. Could It Be Any More Difficult?

Jan 8, 2007

Well, I finally got RS2005 installed on Vista, only problem is, now it won't run.  I've installed SP2 (Ctp) and still no joy.  It just errors when attempting to access the web service.

Here's the error:

w3wp!library!5!01/08/2007-20:36:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
   at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
   at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest()
   at Microsoft.ReportingServices.WebServer.Global.get_Service()
   at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
   at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)

 

Any clues anyone?  I'm all out.

 

Cheers,

Paul

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved