Service Pack

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - how to enable a user account I found the the status of guest account in model database is abnormal,but i don't know how to make it active. any suggestions thanks Tag: Service Pack
  - 2
    - Why can't I use columns based on case down in my where clause I am writing a fairly simple sql, and I would like to write something like Code Snippet select firstname as firstname, case when firstname = 'Peter' then 'yes' else 'no' end as whatever from MyTable where whatever = 'yes' And this should then select out the rows where column number 2 is 'yes'. It doesn't work, and I have to copy the firstname = 'Peter' into the where clause. But why Tag: Service Pack
  - 3
    - The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. (System.Data) There is no option to download and install Jet drivers for XP Service Pack 2. I supposedly have the latest version already. Looking in my C:\Windows\system32 folder, I do not have the MSJET40.DLL or the MSWSTR10.DLL files. I cannot register or unregister the msjetoledb40.dll file. I get an error 'LoadLibrary("c:\windows\system32\msjetoledb40.dll") failed - The specified module could not be found.' How can I uninstall/reinstall or repair the Jet drivers Tag: Service Pack
  - 4
    - Service accounts, local admin, and sysadmin question! whether it resolved or not ...pse post your solution if its not already mentioned in the previous posts... .... so that it will be helpful for others... Madhu Tag: Service Pack
  - 5
    - Incorrect Totals So, if a product can have multiple prices depending on the catalog you have to know the catalog used in the purchase. In that case, does MG1 also have a direct relationship with the Catalog dimension Alternatively, can this be resolved in the DSV Could you create a named calculation in the DSV that multiplies the units by price to give you a transaction total The total seems to be additive. This might be an easier solutoin for you. Bryan Tag: Service Pack
  - 6
    - Error: Subreport could not be shown. The aforementioned portal does not give me the facility to log a bug. I sign-in, navigate to the list of available connections, select SQL Server, peform a search for the error, but there is no " Submit Feedback " button at the bottom of the Search Results as described in the instructions. Tag: Service Pack
  - 7
    - Converting XML Datetime to SQL Datetime The docs are misleading here. If you look carefully at the table above the quote, style 127 only work with Zulu timezone ("Z"). The workaround here is to use XQuery simple type construction. declare @t1 xml set @t1 = '<abc>2007-01-31T13:47:27.25+05:00</abc>' select @t1 . value ( 'xs:dateTime(/abc[1])' , 'datetime' ) -galex Tag: Service Pack
  - 8
    - how to get YYYYMMDD formate It doesn't work when I use convert(char(2),'9',112). I still get '9' not '09'. How to use this function Thanks Tag: Service Pack
  - 9
    - Comparison of SQL Server Reporting Services to Access Reports, Crystal Reports, Cognos or other options Hello SQL Server Experts, Data Analysts, and Report Writers et al: re: Reporting Options with SQL Server I wanted to propose an offshoot to the pryor thread: Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part of SQL Server , especially as to extracting data from SQL Server into a report format I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product Thank you to all, and I hope this is a beneficial discussion to others. Hal1490 Hal9000 Tag: Service Pack
  - 10
    - Changing the default database files path fails Waleed, You need to add the data and log files before you can assign the filename properties. Try the code here (I've adjusted your code): try { ServerConnection connection = new ServerConnection("localhost"); Server server = new Server(connection); if (!server.Databases.Contains("SMO_TEST")) { Database database = new Database(server, "SMO_TEST"); FileGroup fileGroup = new FileGroup(database, "PRIMARY"); database.FileGroups.Add(fileGroup); DataFile dataFile = new DataFile(fileGroup, "SMO_TEST_Data"); fileGroup.Files.Add(dataFile); dataFile.FileName = "D:\\SMO_TEST_Data.mdf"; LogFile logFile = new LogFile(database, "SMO_TEST_Log"); database.LogFiles.Add(logFile); logFile.FileName = "D:\\SMO_TEST_Log.ldf"; database.Create(); } } catch (FailedOperationException ex) { Console.WriteLine(ex.Message); } Tag: Service Pack
  - 11
    - SSRS in Sharepoint, WrapperReportRenderingException/JobCanceledException for large Matrix (OLAP) reports It appears that you could be running into an ASP.Net timeout before the SharePoint method SPRequestInternalClass.OpenWebInternal is able to complete its operation. Does increasing the ASP.Net executionTimeout attribute of the httpRuntime element make any difference thanx, Prash Tag: Service Pack
  - 12
    - AMO:Can any one knows hoe to rename a role and permissions to that role Hi All, I am working on AMO and vb.net.Here with this I am managing Analysis Server 2005 with AMO. My problem is , am able to create a role with role members . but when i try to rename a existing role i couldnt see any direct methods available with AMO.So what i did is first i created a role with normal procedure and then after , i am planning to drop the existing one. here when i did this i am getting some errors while dropping the role like meta data permissions are not able to drop. so could any one come across this kind of situation please help me. your help is valuable to the go further. Regards, vishweshwar.P Tag: Service Pack
  - 13
    - RDA - multi table error for tracking Yes, of course you could use SubmitSQL, it can be used for any SQL statement that does not return rows (INSERT, EXEC sproc, UPDATE etc.) Tag: Service Pack
  - 14
    - What is the easy way to do this?. I want this to happen on existing data. Not while inserting time. I want to trigger this, when enddt cross the server time status should change from live to expired. This should happen automatic. How can i do . Do i need to use trigger for that . enddt status 8/22/2005 7:00:00 PM expired 9/22/2005 8:30:00 PM expired 10/30/2005 7:30:00 PM live 11/22/2005 9:30:00 PM live Tag: Service Pack
  - 15
    - Add SQL database - "login failed for user" error Hi I've installed 'SQL Server Express 2005 SP2'. When I select 'SQL database' from 'Add new item ' (either in Visual C# or Visual Web Developer express) I get the following errror: "Login failed for user'. My OS is Vista. I've tried reinstalling SQL Server express, but I still get the same error. Any ideas on how to fix this Thanks Jon Tag: Service Pack
  - 16
    - MULTIPLE COLUMNS using and GROUP BY You can sort by postal_code (using OVER clause).. "SELECT DISTINCT City_Name, Province_ID,Max([City_PostCode]) Over (Partition By City_name,Province_ID) as [City_PostCode] FROM Cities WHERE City_Name IN ( SELECT City_Name FROM Cities WHERE City_PostCode >= " + startcode + " AND City_PostCode <= " + endcode AND City_Name != '" + exclude + "' ) ORDER BY [City_PostCode] ASC "; Tag: Service Pack
- Next
  - 1
    - copying a DB from one server to another Hi I have a PC with MSDE2000 and need to copy the data to another PC running SQL2005. I have registered the MSDE server on my SQL2005 PC and can see the tables etc. Can this be done automatically, say every day Is there a way of mirroring the DB Cheers Eugene Tag: Service Pack
  - 2
    - Default message for data unavailability Hi BobP, Thanks for suggestion. I tried to search for NoRows property related to table and matrix but I couldnt manage to do it. Also I modified the XML related to my report and added NoRows tag as a child tag in Report tag. However its not working. Do you have any idea regarding this Mahesh Kulkarni Tag: Service Pack
  - 3
    - Schema use in SQL2005 Both are specified in the same schema which is the default schema for the user that is invoking the stored procedure. Notwithstanding good practise or otherwise (we didn't develop the SP, rather are porting an existing DB from 2000-> 2005, the behaviour in this case is different between the two versions. The only explanation I can gather from this is that when executing the EXEC statement within a stored procedure, SQL server is changing the context and losing the reference to the default schema. Confirmation of this would be nice. Tag: Service Pack
  - 4
    - SQL Server 2005 Standard will not install MSSQL default instance I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC. I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!. The folder in question is missing. C:\Program Files\Microsoft SQL Server\MSSQL\ The following folders do exist: C:\Program Files\Microsoft SQL Server\MSSQL.1 C:\Program Files\Microsoft SQL Server\MSSQL.2 I initially suspected this problem was cause by a previous MSDE 2000 installation. I uninstalled SQL Server 2005 & MSDE 2000. I re-installed SQL Server 2005. Same problem. I executed http://support.microsoft.com/default.aspx/kb/320873 to make sure all registries are removed and manually deleted C:\Program Files\Microsoft SQL Server\’s content Re-installed SQL Server 2005. Same problem. I do not know what do in order to get SQL Server 2005 up & running. All help is greatly appreciated. Frank Tag: Service Pack
  - 5
    - Limited Remote Login db access So I read over the link provided... I have completed the first part and added it to the server. I can access the database on my desktop machine, when I login from the laptop however (using the same windows login) I can't access to database...do I need to also add something to make it accessible remotely I don't really understand what " configure AdventureWorks to work with Web server controls " means.. Rob Tag: Service Pack
  - 6
    - Dynamically display/hide the parameter input 1. One way is to control this by writting a html page instead of report manager home page within which you will have a link to each of the report. Depending on who the user is you will change the path of the link (with or without parameters), meaning you will default all the parameters and pass them within the hidden link, but this wont work if you have more that 1 parameter and would want to hide only the user id parameter 2. Another option is to control this within the report. As your userid parameter list is being populated by a stored procedure, you will make the stored procedure accept a input parameter which is the userId of the person that is trying to run the report. Depending on who the user is the SP will return only the required users list. Meaning 1. if XXX is passed and if XXX is RVP then it will return only the sales persons of XXX's region. 2. If YYY is passed and if YYY is sales person then it will return back only YYY 3. If CORP is passed and if CORP is a corporate user then the procedure will return all sales person's names Hope this is clear and helps!!! Tag: Service Pack
  - 7
    - Shredding XML to Relational Data: Query Processor Out of Resources Hi there, I have an irritating problem which I just cant seem to solve. I am trying to retrieve the relational dataset from an xml column using the nodes method provided by SQL Server 2005. This shredding to relational data is done by one stored procedure which is triggered when the xml document is retrieved by a soap service. The stored procedure first inserts the xmldocument into an xml column after which its start shredding the data to relational data. The error I receive is: Msg 8623, Level 16, State 1, Line 139 The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. Below is a short code snippet of the stored procedure. This snippit only represents one sction. In total the stored procedure contains three more sections like the one displayed here. PRINT 'STAP2A: Update Home Data' UPDATE tb_Import_WoningGegevensRelationeel SET cv_aanwezig = q . cv_aanwezig , stadsverwarming = q . stadsverwarming , cv_combi = q . cv_combi , warmtemeter = q . warmtemeter , oppberging = q . oppberging , verhuurdatum = q . verhuurdatum , garage_carport = q . garage_carport , bouwjaar = q . bouwjaar , lift_aanwezig = q . lift_aanwezig , codebuitenruimte = q . codebuitenruimte , marktkenmerk = q . marktkenmerk , gebruik = q . gebruik FROM ( SELECT VHE . C . value ( '(./vhe)[1]' , 'nvarchar(max)' ) As VheNummerUitgebreid , cv_aanwezig . C . value ( '(.)[1]' , 'nvarchar(max)' ) cv_aanwezig , stadsverwarming . C . value ( '(.)[1]' , 'nvarchar(max)' ) stadsverwarming , cv_combi . C . value ( '(.)[1]' , 'nvarchar(max)' ) cv_combi , warmtemeter . C . value ( '(.)[1]' , 'nvarchar(max)' ) warmtemeter , oppberging . C . value ( '(.)[1]' , 'nvarchar(max)' ) oppberging , verhuurdatum . C . value ( '(.)[1]' , 'nvarchar(max)' ) verhuurdatum , garage_carport . C . value ( '(.)[1]' , 'nvarchar(max)' ) garage_carport , bouwjaar . C . value ( '(.)[1]' , 'nvarchar(max)' ) bouwjaar , lift_aanwezig . C . value ( '(.)[1]' , 'nvarchar(max)' ) lift_aanwezig , codebuitenruimte . C . value ( '(.)[1]' , 'nvarchar(max)' ) codebuitenruimte , marktkenmerk . C . value ( '(.)[1]' , 'nvarchar(max)' ) marktkenmerk , gebruik . C . value ( '(.)[1]' , 'nvarchar(max)' ) gebruik FROM @vheupdate . nodes ( '//row' ) VHE ( C ) OUTER APPLY VHE . C . nodes ( './cv_aanwezig' ) cv_aanwezig ( C ) OUTER APPLY VHE . C . nodes ( './stadsverwarming' ) stadsverwarming ( C ) OUTER APPLY VHE . C . nodes ( './cv_combi' ) cv_combi ( C ) OUTER APPLY VHE . C . nodes ( './warmtemeter' ) warmtemeter ( C ) OUTER APPLY VHE . C . nodes ( './oppberging' ) oppberging ( C ) OUTER APPLY VHE . C . nodes ( './verhuurdatum' ) verhuurdatum ( C ) OUTER APPLY VHE . C . nodes ( './garage_carport' ) garage_carport ( C ) OUTER APPLY VHE . C . nodes ( './bouwjaar' ) bouwjaar ( C ) OUTER APPLY VHE . C . nodes ( './lift_aanwezig' ) lift_aanwezig ( C ) OUTER APPLY VHE . C . nodes ( './codebuitenruimte' ) codebuitenruimte ( C ) OUTER APPLY VHE . C . nodes ( './marktkenmerk' ) marktkenmerk ( C ) OUTER APPLY VHE . C . nodes ( './gebruik' ) gebruik ( C ) ) q WHERE vhe = q . VheNummerUitgebreid AND WoningXML_id = @WoningXML_id When I execute each section individually there is no problem. But when all four sections are run sequentially, by executing the stored procedure, SQL Server 2005 just says no Tag: Service Pack
  - 8
    - How do I stop replicating deletes without a Snaphot? I can switch off replication deletes be running the following: EXEC sp_changearticle @publication = 'PUBNAME' , @article = 'ARTICLE1' , @property = 'del_cmd' , @value = 'NONE' I believe I can the effectively then remove the delete stored procedure from the replicated database. And all this wroks no problem. However, when I come to add a new article, "Article2" to my publication it also snapshots and reinitialised the "Article1". How can I prevent the snapshot agent from re-initialising "Article1". Thanks. Tag: Service Pack
  - 9
    - Sql Express Vista trouble #2 Hi Alex, A User Instance is a completely separate instance of SQL Server from the parent instance. When you specify User Instance=False, you are connecting to the parent instance. Visual Studio uses User Instanse to allow users who are not Administrators on their computers to be able to use a SQL database as part of a Windows Forms application without requring the developer to do extra work to set up permissions within SQL Server for the user. User Instances also allow you to deploy your database file as part of your applicaton rather than having to manually deploy the database. You application will likely not be deployable and your end-users will likely not be able to use the database if you set User Instance=False. My guess as to the cause of your problem is that you have more than one instance of SQL Server installed on your computer. The easiest way to check this is to open the SQL Configuraton Manager, select 'SQL Server 2005 Services' and look to see how many times you see 'SQL Server (instance name)' listed. If there is more than one, you are probably querying the feature in a different instance than the one being used by VS. Let us know what you find and if there is more than one I'll help you sort out which one VS is using and how to make sure that instance is the one you're actually configuring. Mike Tag: Service Pack
  - 10
    - Deploying reports/TargetServerURL - beginner question I am trying to figure out Reporting Services and to to deploy results -- and really don't know what I'm doing. I'm going through some books and it looks like our TargetServerURL would either be http://SERVER NAME/reports or http://SERVER NAME/reports erver. Either one will give me a prompt for user & pswd. When I enter my network user & password, I get this message: "You are not authorized to view this page" (It's set up for Windows authentication.) Any suggestions Tag: Service Pack
  - 11
    - LastNonempty return null when filter time hierarchy Dear Deepak, I tried to use Adventure Works Sample Cube. In this cube, I create a new Time hierarchy which contains two levels, Calendar year and Month Name. Besides, I set the aggregateFunction of "Internet Order Quantity" from Internet Sales group to "LastNonEmpty". Then I deploy it and browse it in the BIStudio. I drag and drop the time hierarchy I created and Internet Order Quantity to the measure part. Everthing works fines. Howerver, if I set the filter to only shows "May, 2003 and June, 2003" the null problem still can't solve. At the Year level, it will show "CY 2003" and the value of Internet Order Quantity is "10". If I click the "+" sign, it shows nothing in the month level. Could you help me with this problem Best Regardly Tom Tag: Service Pack
  - 12
    - I have been told to run the following SQL script against the database just right click the db in the object explorer window and choose new query and paste the query in window in the right side........and press F5 button or execute button to execute.......thanx Tag: Service Pack
  - 13
    - How do I supress duplicate data Cannot find this anywhere while creating a report. Is this an option thanks. Tag: Service Pack
  - 14
    - Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server The MS whitepaper “Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service” shows two methods. Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database Option 2: Create the repository by creating a SQL Server 2005 database It would appear to me that you’ve selected option one since you are using the share method. I’ve been trying to use option two. Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful. Tag: Service Pack
  - 15
    - Passing multi value parameters to CreateSubscription Hi everyone. I was sitting on top of the answer. The last code I show does work! I had to pass each value of a multivalue param as an element of the ReportParams array; my problem was that I was sending and empty element as the last one in the array (my fault ) I feel silly for having this post still open. Now I can CreateSubscription on multivalue params. Tag: Service Pack
  - 16
    - Data Flow Task - Conditions to add value for a field. MA2005 wrote: Hi Phil: The [column] in the condition could be a SQL statement right No! If you want to get a value from an external source then you will need a source adapter or (more likely for this scenario) a Lookup component. -Jamie Tag: Service Pack

Techquest

How would one determine the SP for Reporting Services. Is it different from the SP of SQL Server itselves. This is for 2005

Re: Service Pack

Jarret

There might be an easier way to do this, but here's one way to do it.

In SQL Server Management Studio's object explorer, connect to your Database Engine and Reporting Services instances. The Database Engine connection will show the version next to the name. Or, you could connect a query window to your database engine and run 'select @@version'.

Right click on the Reporting Services instance in object explorer and go to properties. In the bottom left of the Server Properties window, click the link 'View connection properties'. The version number is listed in the product version.

Hope this helps.

Jarret

Re: Service Pack

Techquest

Does this mean the we can have instances where the SP levels are different for SQL Server and Reporting services I thought when a SP is applied on a server it is applied to all the services

Re: Service Pack

Jarret

Yes, that is correct. When installing the service pack, you can choose what all services it gets applied to. At least, that's how it was with SQL Server 2005 Service Pack 1.

Jarret

Re: Service Pack

Geert Verhoeven

It is still the same for the new service packs. You install a service pack on an instance not on the entire pc.

Greetz,

Geert

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog