Answer Questions

• ricc How do you hide items in the Report Explorer Web Part?

  Does anyone know if it is possible to hide a report in the report explorer web part in sharepoint. I have a report that can't be run by itself. It can only be run when you click on a detail line from another report. Thanks. Hmm, it should hide them in the SharePoint view as well. A quick test here hid the elements. Can you look to see what the url is on the iframe on the WSS page. It should have something like ViewMode=WebPartList in the url. Can you confirm that it does Hi Hypno, I don't have a property called "Do not show in list view" but I do have one called "Hide in list view". I have to think that they are the same. Unfortunately when I checked it and applied the ch ...Show All

• ming1127 SQL Syntax Error

  Thanks in advance Below is basic sql script. I don't know why it has syntax error. Please explain why and advise correct answers. DECLARE @Date_Range VARCHAR (200); DECLARE @RowCount int ; SET @Date_Range = '(Date BETWEEN CONVERT(DATETIME, ''2006-11-1 00:00:00'', 102) AND CONVERT(DATETIME, ''2006-11-30 00:00:00'', 102))' ; SELECT @RowCount = Count (*) FROM MyTable WHERE (EmployeeID = 1111) And + @Date_Range; Line 9: Incorrect syntax near ';'. Thanks, Arnie. Would you please explain your way. I am new too this area.   Mugambo wrote: Snow: However, there is a caveat.  This code will ...Show All

• DQM Using (ReportItems)

  Hi all, I am using ReportItems to refer to a Text Box in the Details section to a text box in the ReportHeader. The problem i am facing is that i am getting the Header Text Box populated only in tha last page and is blank from the First to the Penultimate Page. Kindly help me out! Is there any property that has to be set ...Show All

• Jandost Khoso Semi-Additive Function not aggregrating on non-time dimension

  I have an on-hand quantity measure in my SQL Server 2005 Analysis Services cube. I set the Aggregate function to LastNonEmpty so that the measure will not sum up across the time dimension but will sum up across the product dimension. My problem is that this measure will not sum up across the product dimension when using LastNonEmpty. It properly displays the data at the leaf level of product but won't sum up for any of the parent levels. When I change the Aggregate function to Sum, it properly rolls up to the parent levels. But, of course, also rolls up the time dimension which I don't want it to do. Can someone provide me with some guidance on this I think I found the answer in your pos ...Show All

• SolveIt automate GACing assembly

  Hi, Unfortunately the deployment Utility does not support adding dll's to the GAC. Still I want to automate it. (By the way on target machines GacUtil is not present). I tried to make a setup project that only adds a dll to the GAC, however the setup project still makes an application folder. How can I turn this off Regards, Henk Unfortunately, VS does not allow you to delete the application folder I haven't used the Visual Studio installer projects for some time, but is there not a File page in the project Can you not delete the app folder in that File page Saying that I can highly recomend WiX as a method of generating MSIs. Checkout the very good tutoria ...Show All

• Seiggy count function in a query

  Hello SQL Experts, I have a Query which is giving me correct result. but i was interested in getting just the count of the Issues it returns. ----------------------------- select distinct T1.dbid,T1.id,T1.title,T3.name,T1.implemented_status,T69.name,T1.submit_dat-e,T1.abc_rank from ( ( ( ( ( issue T1 INNER JOIN statedef T3 ON T1.state = T3.id ) INNER JOIN project T2 ON T1.project = T2.dbid ) LEFT OUTER JOIN parent_child_links T48mm ON T1.dbid = T48mm.parent_dbid and 16780481 = T48mm.parent_fielddef_id ) LEFT OUTER JOIN testrecord T48 ON T48mm.child_dbid = T48.dbid ) LEFT OUTER JOIN sw_label T69 ON T48.available_in_version = T69.dbid ) where T1.dbid <> 0 and ((T1.issue_type = 'Defect' and T2.na ...Show All

• Andrew Sims Question

  In SqlServer, What is the datatype to mask a field of a table I mean if I want to save a password in a table, entering to SQLServer I'd want to display "*****" instead of "hello". Thanks... There are HTML, .NET, and Win32 controls that can be used to mask user input as they're entering some sensitive data in your application. If, however, you want to ensure that users can't query your database for the names and passwords of all of the other users of the database, then you'll want to use any of a variety of permissions on your database. For instance, if some operation is being done on the user's behalf, you could control the permissions on a table containing sensitive data to allow only ...Show All

• AravindaBV Display exported JPEG in a browser

  I am exporting a chart as a jpeg trough a VB script (rs.exe): results = rs.Render( "IMAGE" , "" , "JPEG" , "image/jpeg" , "byte[]" , Nothing , Nothing ) The image is named rr_luzern.jpeg, but it is not displayed in the browser, because actually it is a tiff image. How can I make reporting server render JPEGs     ...Show All

• corbin Connection problem. Business Scorecard Manager 2005 and SSAS 2005.

  Hello, I have a problem creating a ADOMD connection from BSM 2005 to SSAS 2005. (Choosing standard connection) It seems like it's connecting but I cant choose "database name", or it does'nt list any database names. No error messages. When I click Cube name I get the error stating: The business scorecard manager server could not connect to the database. Verify that all data has been entered in the boxes and the connection info is correct. Any suggestions // Richard I added NT AUTHORITY/Authenticated Users to cube reader-role and then it worked. Hi Edward, I used the SQL Profiler and I can see that it is not me as the user who is trying to conn ...Show All

• HopeDreamsComeTrue Import works but no data? Part 2

  Now I got a little bit further on my own. But, I have run into this issue with, "Not being able to import the data to the database". I can import the column headings, then that is were it ends. I was reading up on this and it made it seem as if you are to go back after you get the column headings. Then do the same to get all the rest of the data. But, for some reason the "Query or Copy" menu doesn't display to do the query action to import this data. Is there anyone who knows what I am talking about, please help.. I am using SQL SERVER 2005 and I am trying to import via the import wizard. I'm not able to catch if this is a continuous problem you have had previously, that helps if you can refer your old ...Show All

• Mohsen Kokabi Grouping problem

  I am working on a report for a small POS. The report should allow the user to choose the time interval to group sales records, e.g. 1 hour, 2 hours or 4 hours. I believe I can setup this by the DiscretizationMethod and DiscretizationBucketCount of the Hour attribute in my DimTime dimension. However, the problem that I am facing is this POS will support multiple branches. Each branch will have their particular opening and closing hour. So, how can I group all the transaction into groups, said "Before Shop Open" and "After Shop Closed" This sounds strange but will happen quite often as overtime work is always expected in my living place. If this is infeasible, is there any workaround I think the business user certainly want to know how many ...Show All

• ergas An attempt to attach an auto-named database for file......

  I've read through all the posts in this fourm that are related to the problem I'm getting with this error message on my main form, but none of the fixes seen to solve the problem. So I hope someone can get me pointed in the right direction. I'm running visual studio 2005 professional, and SQL Server 2005 Express Edition and this is a desktop application. I added the db file to the solution with the Add New Data Source wizard, I can create the datasets and preview the data correctly. An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I run ...Show All

• bhavu How can we put two charts available in the same page and make them available in every page?

  Hi, all experts here, Thank you very much for your kind attention. Would please any expert here give me any guidance and advices for how to put two charts available in the same page And how to make all the charts available to each page automatically Really need help. Thanks a lot in advance for any guidance and advices for that. With best regards, Yours sincerely, ...Show All

• bennettdan How to specify datatypes for Excel columns?

  So I have Excel Source in my dataflow - so I do a simple transform and try to save it to db and guess what - a freaking error message: Columns blahblah and BlahBlah cannot convert between unicode and non-unicode datatype. I cant figure this MS stuff out - why the heck is this data from excel unicode to begin with & I just dont feel it is right to always use the derived columns to convert datatypes when dealing with Excel data. Am I missing something again or is it another one of those MS gotchas -- Note - all profanity in this post is replaced with words like freaking, stuff, gotcha and so on by the author Jamie Thomson wrote: Why do you have an issue with Derived Column I'm not slating you for it - I'm just interested ...Show All

• ZopoStyle Dynamic queue receive sql ?

  Hi There My activation sp must be able to read of various queues. I load a variable with the queue name that activated the sp btu i cannot get the syntax working to receive or get a conversation group of a queue name that is a variable. I have tried: WAITFOR ( RECEIVE message_body , conversation_handle , message_type_name , message_sequence_number , conversation_group_id FROM @callingQueue INTO @msgTable WHERE conversation_group_id = @conversationGroup ), TIMEOUT 2000 ; But i get this error: Incorrect syntax near '@callingQueue' . Looks like you cannot use a variable. So i tried the following: SELECT @SQL = N' WAITFOR ( RECEIVE message_body, conversation_handle, message_type_name ...Show All