Answer Questions

• Erik11 Simple Textbox question

  I have a textbox that contains enough text to fill up 3/4 of a page. If i place the textbox halfway down the page (where the whole thing wouldnt fit) it will take the textbox and place it on another page. Is there any to way to make it use the whitespace on that page and continue the textbox on the next page Any possible work arounds Using a list or table try putting a rectangle on the page, make it the size you want to cover, then place the text box inside the rectangle. No; textboxes are always kept together. We are considering improving this behavior in a future release. ...Show All

• Markish Specify cell background color for cell that contains subreport

  Hello. I have a subreport in a cell and I can't specify the background color of the cell. I have a "dummy" dataset in the subreport to always return data so that it appears grey, but the problem lies in when there is a carriage return/line feed. The next row will be white with color only where the subreport is located and not where other subreports in the same row are located with no carriage return/linefeed. Thanks! BJ I have it set in the subreport and it is fine when the subreport itself will bleed to the next line because it has a background color set. If I have a subreport in the same line as another, if the other bleeds to the next line and the other doesn't it will show a white backgrou ...Show All

• Noa LEFT JOIN Conundrum

  I have, what I think, is a simple query to perform but I can't figure it. Maybe someone can help There are 3 simple tables: tblMain Idx FirstName LastName ReasonID tblReasons ReasonID_R Reason tblOtherReason Idx_R OtherReason tblOtherReason is only used if the user chooses "Other". Then their freeform reason is stored in tblOtherReason.OtherReason. ReasonID is an integer field. It's used simply to link to the textual Reason field in tblReasons. All I want to do is run a simple SQL command that will return all of the records in tblMain, though displaying tblReasons.Reason instead of tblMain.ReasonID and adding the extra field tblOtherReason.OtherReason Using the Design View in MS Access I generated a basic query: SELECT tblMa ...Show All

• Mitch5713 MDX Query Help...Please

  Hi, I have a fact table containing the following columns: CustomerID RegionID CategoryID ItemID Price Relationships: A customer belongs to only one particular region and category Each customer can buy the same item at different prices The measures are LowPrice and AveragePrice Query For a particular customer, what was the customer price, average price and low price for some other combination of region and category ( this not the region and category,the customer belongs to) For ex: CutomerId RegionID CategoryID ItemID Price 1 1 2 1 2.00 2 2 3 1 6.00 3 2 3 1 4.00 Report should display for Customer 1 , ...Show All

• voltagefreak Help with generating a password with non repeating characters

  hello all, I have to write a query to generate a password which should have not have any repeated characters. The only far that I was able to go is : SELECT SUBSTRING(CONVERT(varchar(10),@member_id),1,1) + CHAR(((ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),2,1))-47)*2)+64) + SUBSTRING(CONVERT(varchar(10),@member_id),3,1) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),4,1))+32) + SUBSTRING(CONVERT(varchar(10),@member_id),5,2) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),7,1))+33) + SUBSTRING(CONVERT(varchar(10),@member_id),8,3) but this does generate repetitve character code. Please help. Thanks, Yep, that was my concern also. A "tru ...Show All

• SP534 Service Broker Table Copy, file send?

  Hi There I have a table at my initiator, i have a copy of this table at my target, every morning i want to refresh the table at the target with the data from the initiator via service broker. What would be the best way to do this One major consideration would be that this table would be very large +- 1.6 million rows. I was thinking of exporting the table to file like a csv, compressing the file and then sending it via service broker. Then at the target i would uncompress and bulk copy the data into the table at the target. But can this be done How would one go about sending a file via service broker For example if i wanted to send a .csv or something via service broker how would i do it I know i can send binary dat ...Show All

• UmerTahir #Error using IIF and divide by zero

  I am getting an error in a calculated field that could potentially divide by zero, even though I'm using an IIF. The column displays in the report as "#Error". My expression looks like this: = IIF(Fields!Qty.Value = 0, "None" , Fields!Hours.Value / Fields!Qty.Value) I have successfully used this approach with INT fields, but this time the Hours field is a NUMERIC(9,2). My workaround is to do this: IIF(Fields!Qty.Value = 0, "None" , IIF(Fields!Qty.Value = 0, 42, Fields!Hours.Value) / Fields!Qty.Value) I guess the 42 is cast to an INT inside the second IIF and the calculation works. What's strange is that the division would even be carried out in the event of Qty = 0 from the first II ...Show All

• Kaos MSSQLSERVER login failed for user 'MACHINE\user'. [CLIENT: <local machine>]

  I just did a fresh install of SQL Server 2005 Developer Edition and SP1. I elected Windows auth during install. After rebooting I get 2 errors in my Application Event Log: MSSQLSERVER Login failed for user 'COMPUTER\user'. [CLIENT: <local machine>] (event ID 18456) and Report Server Windows Service (MSSQLSERVER) (event 107) which says: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. In the data section it says it can't connect to the machines "master" database. I can manually login. How can I fix the problem and get rid of these messages Thanks. Mark Here are the errors that I get in the Application Event Log: Type: Error, Source: Report Server ...Show All

• michael412 simple dts - set some constant values

  Hello, I have a simple dts which imports data from one table to another. I want to insert some constant data to some columns of the target table, since there are no corresponding columns in source table, and target columns do not allow null values. How do I do that In the mapping table I can only map source columns to target columns. How can I map target columns to constant values. Thanks in advance you can use the dts designer to do that there should be two packages involved. one that creates the database before designing "package two" run the first package to have the schema change design the second package and do the mapping   you dont even need a dts solution use northwind select * ...Show All

• kangalert Configure Integration Services on a Cluster

  Hi I am having an active/active cluster setup where there are 2 virtual SQL Servers one with default instance and other with named instance. 1) i need to know how to cluster integration service. 2) how are the integration packages are run, are they run by the integration services service, or by the SQL Instance 3) When fail over happens from one node to other will my packages continue to run i had setup Integration Services on a Cluster per the following article: http://msdn2.microsoft.com/en-us/library/ms345193.aspx .... but when i do fail over or move the group to another node ... getting an error indicating: An error occured attempting to read properties for the 'xxx IntegrationServices' resource. The object alr ...Show All

• Stonemeel Help with installing VS Tools

  Hi, I have a problem with the installation of SSCE31VSTools-ENU.exe into VS2005. The installation ended after a few seconds although in the event log there is information that the product is successfuly installed. However, when I run Visual studio there is no project under Smart Device regarding SQL Compact database or something similar (there are only templates for: device application, class library, control library, console application, empty project and nothing more) VS2005 is in this version 8.0.50727.762 (SP.050727-7600) In application event log there is: Product: Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 [ENU] -- Configuration completed successfully.'" Has anyone some idea if there is a ...Show All

• Adam2342342341 MDX to locate data on a higher aggregation from a lower aggregation

  I think I have a strange problem with a cube. The problem does come from the source data provider, but since there are no means to change that, I have to live with it and make the best of it. Let me try to describe my situation: I gather data on two levels, two different grades of aggregation (for me: Groups and individual lines). On the higher level, I see an exact amount of time (<-my target), on the finer one I only have a sum of my target value and another time span. I also have counts of members on each level. What I need to do is "split up" the sum value I have on the fine grain level according to distribution on the higher granularity level. Does MDX provide a way to "look up" one aggregation level fr ...Show All

• vicarious Pivot Table with SSAS 2005

  hi i facing problem when i tring to browse cube created in SSAS 2005 from pivot table in FP appear this error The query could not be processed: o An error was encountered in the transport layer. o The peer prematurely closed the connection . any one have solutions for this problem thanks Ensure that you have the Microsoft OLE DB Provider for Analysis Services 9.0 installed, as well as Microsoft Core XML Services 6.0. They can be downloaded here http://www.microsoft.com/downloads/details.aspx FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en Once they are both installed, run regedit and look under HKEY_CLASSES_ROOT/MSOLAP - there should be a key called CLSID whi ...Show All

• SynergyNT Local cubes connection

  Hello, I have created 3 local cubes which resided in the same .cub file. The cubes created from AS 2005 cubes. How can I make ADOMD connection to all 3 cubes at the same time in my client application (C#) The problem is that Initial Catalog (database name) in connection string in case of local cubes is the same as the cube name. Thanks, GB In ADOMD you don't connect directly to any specific cube. Once you have connect to the database (catalog) you just specify which cube you want in the query. So you only need the one connection and you can use that to query any of the cubes in the catalog. eg SELECT measures.AllMembers ON COLUMNS FROM <CUBE_NAME> Yes, XMLA script is working for me. I found the instructions ...Show All

• bilalso SQL CE and visual studio 2005

  Hello, I am trying to install SQL CE v.2.0 to use it with visual studio 2005. The problem is that when I try to add refference System.Data.SQLClientCE I cannot find it hence I belive that it does not install properly. I am new to this so please try to be as more informative as you can. Kindest regards, John. search for system.data.sqlserverce.dll in your "c:\Program Files" directory tree. Once you find it, you'll have to use the "browse" tab to go to the directory, add the file to the project references. Then you'll find you can use the namespace. I'm about 4 hours ahead of you on this track, I think. SQL Client v2.0 reference is in the folder given be ...Show All