How Do I Hide Internet Explorer Menu and Tool Bar

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Query takes more time from user interface or in a network I execute a pretty big sql query which joins multiple tables and I reviewed indexes on all these tables. I am happy with the result when I run the query using SSMS in the server locally i.e., where my SQL Server database is installed. It takes 4 seconds to get around 17000 records. If I run the same query in a network or from my desktop using SSMS i.e., i connect to the above mentioned SQL Server using SSMS, it takes more than 60 seconds. Not sure how to solve this. If someone could help me, it will be of great help. Thanks. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 2
    - Packege success, despite task failure Hello, When I run my package, a task will fail, however, the package will claim that it was successful. Why is this, and how can I trigger a failed package when one task fails Thanks in advance. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 3
    - Can i host a SQL2005 EE DB on SQL2000 engine ? Hi, I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support. My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives. Thanks. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 4
    - Incorrect processing order for views I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchronization processes the view scripts in the wrong order regardless of the processing order 4) An 'invalid object name' error results as the new view has not arrived at the subscriber when alteration of the first view is attempted The number suffixes on the script filenames in the snapshot folder do, however,appear to be numbered correctly so as to process in the correct order Note that I have tried using the default processing order and have also set the processing order explicitly using sp_changemergearticle - but the problem still occurs I have tried to recreate this problem on a small database with a minimum of articles, but attempts at repro have failed to date with a simple configuration - ie the processing order applied is correct Is there an known problem in this area Any suggestions would be much appreciated aero1 Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 5
    - Unable to read local eventlog (the parameter is incorrect) In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date: 03.11.2005 Time: 17:14:47 User: N/A Computer: RESYSHADOW Description: Unable to read local eventlog (reason: The parameter is incorrect) Does anyone know what could be causing this. I have tried it on Windows XP SP2 with local Admin account and on Windows Server 2003 with Domain Administrator Account and the SQL2005 Server is RTM with the same results. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 6
    - Database Blobs & Performance Hi geniuses, I have a core database question in MS Access and SQL Server. Assume the following table in MS Access or SQL Server: Employees table: EmpID, Name, Hiredate, Photo; and the following query: "SELECT EmpID, Name, Hiredate FROM Employees;" The question is, "does the blob object ( Photo) affect the performance of the query even when not included in the select statement " I mean, will I gain some additional performance when separating the blob fields to another table Thanks for the answer. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 7
    - How to extract domain name from an email address?? Hi do you know incase a script which extracts domain names from an email address like foreg. we have xyz@dmc.com or abce@dmc-int.com should give dmc and dmc-int Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 8
    - problem connecting Remote Analysis service 2005 from vb.net 2005 hi mates, following code works fine in the server machine where sql server exists. but this doen't run at client machine. it throws error as " A connection cannot be made. Ensure that the server is running. " help to solve this problem thanks Code Snippet Dim msSvr As New Server Dim db As New Database Try If Not msSvr Is System.DBNull.Value Then msSvr.Disconnect() End If 'both connections r not working msSvr.Connect( "Provider=MSOLAP.9; datasource=http://server/olap/msmdpump.dll;Initial Catalog=testolap;user id=sa;password=sa;" ) msSvr.Connect( "Provider=SQLNCLI.1;Data Source=esERVER;user id=sa;password=sa;" ) If Not db Is System.DBNull.Value Then db.Dispose() End If db = msSvr.Databases.Find( "testdb" ) db.Process(ProcessType.ProcessFull) db.Refresh( True ) Catch ex As Exception Console.WriteLine(ex.Message) Finally db.Dispose() msSvr.Disconnect( True ) End Try Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 9
    - select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 10
    - SSAS processing Hi, I created IS package for cube processing and if I execute this task , then execute result is successful. But I don't see any update information through BIDS when I browse the cubes. Why it happens and how can I check it Connection string is fine and i've also checked the processing configuration and I don't see any problem. Any kinds of advice would be appreciated. Thanks in advance. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 11
    - Schema (owner) Names Not Visible In Shapes On Diagram When reverse engineering a SQL Server 2005 database (using VS 2007 Professional), I can't figure out a way to display the schema name in front of the table name in the database diagram. For instance, If I have a table named Person.Type, it just comes over as Type. It knows what the schema is because it's in the properties box for that object. It just doesn't appear in the name on the shape itself. Is there a setting somewhere that I'm missing that will display the schema in the name Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 12
    - Select Statement Problem? Hi every1, Recently i have this exam about sql statements, it shows that it has 1 table like this one. name telephone1 telephone2 ian 1234567 7654321 test 1111111 2222222 How can we make a select query where the output is this name telephone_numbers ian 1234567 7654321 test 1111111 2222222 Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 13
    - MS SQL2005 express ed + SSIS installation problem Hi, I have tried to install SSIS going steps msdn2 using "mssql setup" but my "ssis" option is not available for installation. Pls, help! Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 14
    - Problem in MDX query for calculating total sales. hi, can someone help in finding the error in this mdx query for the given problem statement. Query : Sales performance by gender of the customers. - The expected output is 2 values of sales ,one for all male customers and other for all female customers. - The level CustomerID of dimension Customer has attribute GENDER. - I have calculated two sets [Male] and [Female] . - At present i am getting sales value for all the members ,i want one aggregated value for male set and another value for female set.How do i go about doing this Please help. MDX Query : WITH set [Male] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "M")' set [Female] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "F")' SELECT {[Measures].[SALES($)]} ON AXIS(0), {[Male],[Female]} ON AXIS(1) FROM [cubename] Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 15
    - help enabling FTS in multiple database Hi all, We have a remote server which runs SQL server 2000 DEV edition. We have 4 databases running in it. Our application needs the feature of Full Text Search in all the four databases. We have installed the necessary services. The problem is that we are able to create FTS on one database but when we try to run FTS on other databases the MSSearch service stops. on restarting it mssql stops. we are not able to do FTS on more than one database. We had tried the same in our local server but it is working fine. The only difference between the two is that the local machine are member server. Has this to do anything with the FTS Meanwhile the eventviewer doent help much, it just tells that the mssearch engine has stopped unexpectedly and it has done this 'n' time. Please help Thanks Smitha Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 16
    - Dervied Column - Expression? Hi: I have a Dervied Column Component, in which there is a column called RecStatusCode. The criteria to give a value to that column is below in SQL: (SELECT CASE CertParticipant WHEN 'Y' THEN 'C' WHEN NULL THEN 'A' END FROM [dbo].[SchoolCertRequest] WHERE SchoolID = (SELECT SchoolCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) and SchoolBranch = (SELECT BranchCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) AND LoanType=(SELECT LoanApplicationTypeCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID)) My question is how can I use this SQL in that expression field, or is it possible to have a user variable, with the above sql being the criteria, and the value could be used in the derived column, by just using the variable in the expression. In either case, I hope you understand what I am trying to accomplish. The reason why its like this is because currently in my Data Flow Task, i Have a OLEDB source which returns 25+ column values, the source connects to this derived column item, and then finally the destination oledb where the mapping takes place. So basically I am trying to avoid MERGE JOIN, because i tried using it , and it complicated the whole thing much more then it really needs to be. Like the RecStatusCode column, i have 5 more columns which are dervied, and the values are coming from a SQL statement similar to above. I really need some help here, and I have not seen anything in reference to this in BOL or any articles online. Thanks in advance. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
- Next
  - 1
    - The INSERT statement conflicted with the FOREIGN KEY constraint FK_source_destination. Hi. Please excuse the rookie question, but I am not sure how to get around this error. "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_users_editprofile". The conflict occurred in database "MyDB", table "dbo.editprofile", column 'userid'. The statement has been terminated." I encountered the error when running a series of test INSERT statements after creating a bunch of FK/PK relationships between the parent table DBO.USERS and several child tables. The one that this error complains about is DBO.EDITPROFILE. Code Snippet INSERT INTO users (lastname, firstname, email, alternateemail, password, role, securityquestion, securityanswer, zipcode, birthmonth, birthday, birthyear, gender, city, state, country, registerdate, editdate, confirmed) VALUES('gore', 'albert', 'bigal@inconvenienttruth.org', null, 'hugatree', 'User', 'what is your school ', 'harvard', 06510, 1, 31, 1970, 'Male', 'Greenwich', 'Connecticut', 'USA', '2007-06-22', null, 1) INSERT INTO precedence (userid, profileid, searchname, proximity) VALUES(1, 3, 'random search', 1) INSERT INTO userphotos (photoname, userid, location, size, caption, isdefault, ispublic, date, nophoto) VALUES('random image', 1, 'x/y/z/', 23422, 'random', 0, 1, '1998-12-25', 0) INSERT INTO editprofile(headline, aboutme, userid, date, interests) VALUES('Random Headline', 'random', 1, '1998-12-25', 'I am interested in anything random') DBO.USERS: Code Snippet CREATE TABLE [dbo].[users]( [userid] [int] IDENTITY(1,1) NOT NULL, [lastname] [varchar](50) NULL, [firstname] [varchar](50) NULL, [email] [varchar](50) NOT NULL, [alternateemail] [varchar](50) NULL, [password] [varchar](50) NOT NULL, [role] [char](50) NOT NULL, [securityquestion] [varchar](50) NOT NULL, [securityanswer] [varchar](50) NOT NULL, [zipcode] [int] NOT NULL, [birthmonth] [tinyint] NOT NULL, [birthday] [tinyint] NOT NULL, [birthyear] [int] NOT NULL, [gender] [char](10) NULL, [city] [varchar](50) NULL, [state] [varchar](50) NULL, [country] [varchar](50) NULL, [registerdate] [datetime] NOT NULL, [editdate] [datetime] NULL, [confirmed] [bit] NULL CONSTRAINT [DF__Users__confirmed__4CC05EF3] DEFAULT ((0)), CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED ( [userid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_email] UNIQUE NONCLUSTERED ( [email] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_editprofile] FOREIGN KEY([userid]) REFERENCES [dbo].[editprofile] ([userid]) GO ALTER TABLE [dbo].[users] CHECK CONSTRAINT [FK_users_editprofile] GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_lastlogin] FOREIGN KEY([userid]) REFERENCES [dbo].[lastlogin] ([userid]) GO ALTER TABLE [dbo].[users] CHECK CONSTRAINT [FK_users_lastlogin] GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_precedence] FOREIGN KEY([userid]) REFERENCES [dbo].[precedence] ([userid]) GO ALTER TABLE [dbo].[users] CHECK CONSTRAINT [FK_users_precedence] GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_savedsearches] FOREIGN KEY([userid]) REFERENCES [dbo].[savedsearches] ([userid]) GO ALTER TABLE [dbo].[users] CHECK CONSTRAINT [FK_users_savedsearches] GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_userphotos] FOREIGN KEY([userid]) REFERENCES [dbo].[userphotos] ([userid]) GO ALTER TABLE [dbo].[users] CHECK CONSTRAINT [FK_users_userphotos] DBO.EDITPROFILE Code Snippet CREATE TABLE [dbo].[editprofile]( [editprofileid] [int] IDENTITY(1,1) NOT NULL, [headline] [varchar](50) NULL, [aboutme] [text] NULL, [userid] [int] NOT NULL, [date] [datetime] NOT NULL, [interests] [text] NULL, CONSTRAINT [PK_EditProfile] PRIMARY KEY CLUSTERED ( [date] ASC, [userid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 2
    - Missing Properties??? Has anyone tried to open a cube into Business Intelligence Studio and the properties for the database vanished (project menu, properties) How do you get them back Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 3
    - SQL Restore Rights Hi All, I've got an SQL 2005 server setup with some databases. I'm trying to set it up so that a user can upload his database backup and then restore the DB using Studio Express but am having some issues with it. The user can upload his database fine, but when we try and go in to restore it, he can't view the directory or file of the backup. I've added the service account that SQL runs as, as well as the SQL2005%Machine%etc... user without much luck. The only thing I can think of from here is SQL permissions and I'm a little vague on how to accomplish what I want. One other thing is that if I add sysadmin rights to the user, they can see the directories fine. I tried adding dbcreator as recommended by other posts and that didn't work either. Any help would be greatly appreciated. Thanks! Brad Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 4
    - Multiple masks in a For Each File Loop container Hi, Is it possible to use multiple masks in a For Each File Loop container I need to process "*.txt" and "*.csv" and tried to separate them with all the usual characters("," ";" etc.) but it does not seem to work. I don't want to create 2 or more containers for each mask. Thanks Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 5
    - stored procedures compilation Dear all, Programmer had writen a stored procedure which gets executed on the page load of our website. if the page is refreshed 10 times the stored procdedure gets executed 10 time. Is there any way to stop the stored procedure compilation. Regards Mohd Sufian Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 6
    - Permissions for creating views In database permissions I have granted a user rights to create a view. When she tries to save the view (even save as) it automatically wants to save it to the dbo schema and says she does not have rights to save to the dbo schema. Two questions: 1) Can I set it up to where she can save a view to a schema which she is the owner 2) If not, then what permissions must be set to allow her to create / save views but not be able to create, etc. other objects such as tables and stored procedures Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 7
    - Cant install SQL Server 2005 on vista.. Ok ive tried looking everywhere for a solution but i just cant find one... please help me I need to install SQL Server 2005 on Vista, but i have issues. I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected. The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..." Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point. A walkthrough or something would really help... P.S Im running on Vista Ultimate and trying to install SQL Server 2005 Enterprise Edition Thanks! Robert Macnair Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 8
    - GENERATE(): Is there an alternative? For the following fact table (3 keys, 2 measures) Assessment_Date_PK Machine_PK Patch_PK PatchApplied (tinyint 0 or 1) PatchNotApplied (tinyint 0 or 1) the following Named Set has been created in the cube script (SSAS 2005) utilizing the GENERATE() function: CREATE HIDDEN SET CURRENTCUBE .[Last Patched] AS GENERATE ( { NONEMPTY ( ([Machine].[Machine Name].[Machine Name], [Patch].[Patch Name].[Patch Name]) )}, CROSSJOIN ( { ([Machine].[Machine Name]. CurrentMember , [Patch].[Patch Name]. CurrentMember ) }, {( NONEMPTY ([Date].[Date]. Members )). Item ( COUNT ( NONEMPTY ([Date].[Date]. Members ))-1). Item (0)} ) ); Introduction of this MDX has adversely impacted performance both 1) when the cube is processed and 2) when the cube is browsed (ie in XL07). Are there any alternatives to GENERATE that we might be able to try The purpose of the Named Set [Last Patched] is to provide, for each Machine/Patch combination, the last time it was assessed. With this Named Set, other calculations can be applied to answer questions regarding the last know patch status of the machines being assessed. Thanks + Ron Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 9
    - Activation procedure design I've been experimenting with Service Broker and was surprised at one aspect of the design: the interface to Activation stored procedures. I would have expected the queue to be a parameted passed to the procedure rather than having to hard code the queue query into the SP. In a system with lots of queues it seems plausible that the same activation procedure might want to be used with several queues. Any comments David. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 10
    - Replacement for Access Forms Hi, We had to migrate from MS Access 2003 to SQL Server 2005 due to some project requirements. We had used Forms , earlier, to enter data to the Access database. I understand SS2005 doesnt support forms. Can you suggest any other way of creating an equivalent entity as that of forms , so as to enable users to enter data to the SS 2005 DB easily. Thanks in Advance for your help, Regards, Sundar Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 11
    - Setting Maximum Memory I need to up the Maximum Memory setting. Out of the box it is set to 2147483647 MB. I assume this is ~2GB. I have been instructed to set it to 1GB less than total server memory which is 16GB. When I change the value it just changes back. How do I change it and how are these Megabyte numbers calculated OS: Windows 2003 R2 Enterprise SQL: SQL Server 2005 Standard Thanks! Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 12
    - SQL CE top/limit, unable to find WORKABLE solution Hi all, I'm being driven to distraction by my inability to find a workable solution here, i'll try and lay out my problem as simple as possible: My application analyses sentence structure, it stores hundreds of thousands of web pages, and stores all the words on those pages sequentially in a database with a primary id, the id of the page the word is from, and the word itself of course. ie : id , parent_id , word What i'm trying to do (which already works successfully in both SQL and MySQL) is to retrieve the word immediately before the one I specify and 3 words after the word I specify. Ideally in one union query but i'll accept it if that's too complex and go for two for now. Because of the sheer size of the database ( millions of keywords ) I can't afford to retrieve every single record and feed off the top results in the application itself. I've attempted to use subqueries: SELECT yek FROM child_barrels A WHERE 3 > (SELECT COUNT(*) FROM child_barrels B WHERE A.yek < B.yek) AND id>'" + id + "' AND parent_id='" + parent_id[x] + "' ORDER BY id ASC SELECT yek FROM child_barrels A WHERE 1 < (SELECT COUNT(*) FROM child_barrels B WHERE A.yek < B.yek) AND id>'" + id + "' AND parent_id='" + parent_id[x] + "' ORDER BY id ASC These raise an error on the first select statement in the sub query. (SELECT yek FROM child_barrels WHERE id>'" + id + "' AND parent_id='" + parent_id[x] + "' ORDER BY id ASC LIMIT 3) UNION (SELECT yek FROM child_barrels WHERE id<'" + id + "' AND parent_id='" + parent_id[x] + "' ORDER BY id DESC LIMIT 1) Above directly is the original MySQL code. I would appreciate any help available on this, thanks in advance. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 13
    - sql server 2005 Hi , i'm a C# developer. I want to upgrade this hotel app. i made from using access to SQL server. I got SQL server express 2005 and the management studio . Now i've been looking for a proper book for a whole lot of time. The last book i reviewed was Programming Microsoft SQL server 2005 . It says : "We assume you have basic, working knowledge of .NET programming in C# on the client and Transact-SQL (T-SQL) on the server. On the tools side, we assume you are familiar with the prior generation of SQL Server and .NET toolsspecifically, SQL Server Enterprise Manager, SQL Query Analyze r, and Visual Stdio .NET 2002 or 2003." ARRRG ! I'm good at C# , and ADO.NET , (datasets , adapters etc) , but i have no idea of what SQL server is all about. I 've never run any older version and never used any of thier dbs I know simple sql query statements like "SELECT * FROM <sometable> Where <somecondition> ". Oh and i have VS.NET 05 pro. I need a book that covers : installing a db on a pc , and mantaining it programatically via C# Adding tables , rows columns again , programatically working with relationships. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 14
    - Merge Join - Output of Lookup as sorted field? I'm doing a data conversion with one of my fields (SUMDWK) from one of the tables that will be used in a merge join. With the new, converted field, I do a look up. From this look up, I want to take a new field FiscalWeekOfYear, and replace the original field, SUMDWK. This is necessary because SUMDWK is one of the sorted fields. In the look up, it is not possible to change the Output Alias. Does anybody know a way around this Thanks. Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 15
    - Config and Connection String I want to store my connection string in a configuration file, however when I create the config file the connection string password is not stored. I can manually edit my config file and add the password to my connection string but I am sure that BIDS has a better solution. What is the best practice for storing connection string passwords in my SSIS Configuration files Tag: How Do I Hide Internet Explorer Menu and Tool Bar
  - 16
    - Standard Edition Limits and Partitioning by Multiple Cubes I have an application that is going to process large amounts of data and am planning on using the Standard Edition due to cost reasons. I'd like a validate a few items based on other people's experiences: What's a reasonable fact table size Can a 100 million row fact table be supported be reasonably supported on a 2 CPU server I know this is a loaded question...less than 10 dimensions, 10 or so measures...just looking for some other data points to compare to. I could create as many as 25, 4 million row cubes because of how my data is functionally separated and then issue by queries to different cubes. Has anyone operationally built a warehouse that is partitioned by building separate cubes There is little data shared, so not much data would have to be duplicated between cubes. I guess I'd have to build a DSV to each cube with a View on the fact table that would have the "partition key" in the view used for the fact table in the DSV. Even though partitions are not supported in Standard Edition, are there other best practices for handling a large fact table Any chance SP2 will enable partitioning of a cube (alas, there is a New Partion link in the current SP1 designer for some reason). With the price of disk these days, and the amout of data processed in even "trivial" applications, it would seem Cube Partitioning should be available in Standard Edition. Thanks! Tag: How Do I Hide Internet Explorer Menu and Tool Bar

TRA Tech

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

Re: How Do I Hide Internet Explorer Menu and Tool Bar

?®�?§Q?

If I am understanding what you are asking, that is not possible with SSRS.

Re: How Do I Hide Internet Explorer Menu and Tool Bar

TRA Tech

I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.

Re: How Do I Hide Internet Explorer Menu and Tool Bar

Joe Webb

Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe

Re: How Do I Hide Internet Explorer Menu and Tool Bar

TRA Tech

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE

Re: How Do I Hide Internet Explorer Menu and Tool Bar

Joe Webb

I'm not following you. Are browsing to the reports from within Report Manager Or are you calling the report from another web page

Joe

Re: How Do I Hide Internet Explorer Menu and Tool Bar

TRA Tech

I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.

Re: How Do I Hide Internet Explorer Menu and Tool Bar

?®�?§Q?

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application If so, you will have quite a bit of control over the web page. What tool are you using Or are you creating the web page from "scratch"