Answer Questions

• Bladester50 Setting up Security

  Hi all, Okay, here's my problem: After I login into the Reports Server ( <servername>/Reports1/Pages/UILogon.aspx ) the Home page is blank ( accpet for links to Home |MySubscriptions | Help in the upper right corner). Please read on before thinking you know the answer. I am using Reporting Services with Forms Authentication with a custom security extension. In the LogonUser methothd I validate the user and return True if the user is good. Should I be doing anything else in this method or any of the other methods in my custom extension I'm asking because, I can use Sql Server Management Studio to login into the Reporting Server, view any folders such as the Data Sources or Models folder, but can't make any changes. In the User ...Show All

• Nightmare_BE federated query architecture advice

  I'm involved in a project building a federated query app. There is an ASP.NET web app talking to a central SQL Server 2005 db. Users input query parameters to the web ap, the request is submitted as a stored procedure to a central db, and from there it is distributed to the selected remote SQL Server 2005 db servers with similar but not necessarily identical schemas where the actual data resides. We must wait for all servers to execute the query and return the results, then aggregate those query results and present them to the web app user. The question is, what is the best way to design this with Server 2005 We need to be able to initiate multiple concurrent queries, then wait (up to some max timeout value) for all responses to ret ...Show All

• jam281 Ampersand in email subscription report parameter

  Hello everyone, I'm trying to set up e-mail delivery report subscriptions. When I enter report parameters, it accepts the standard MDX syntax (ex. [Time].[All Times].[2006]), but when I try to access a member by it's key: [Time]. & [2006] It raises the following error: Default value or value provided for the report parameter 'pTime' is not a valid value. (rsInvalidReportParameter) They seem to have the same problem here (see last paragraphs of the article): http://www.microsoft.com/technet/prodtechnol/sql/2005/smartreports.mspx Any idea would be very welcome. Thanks! TGA I have the same problem, I've tried replacing the ampersand with &amp; and %26 but the parameter ...Show All

• Hassan Ayoub Excel Worksheets Become Corrupt -- Bad Metadata?

  One of my main users has had a few Office 2003 SP2 worksheets go corrupt on him and I can't seem to figure out why. For performance reasons, I recommended that he use page filters whenever possible. As of late, he'll send a workbook along that has a few page filters (between 3 and 4) and one of the page filters gets mixed up somehow. For example, let's say he has a Product Line page filter and a Product Name page filter. The Product Line page filter has multiple selections enabled and he will go ahead and select a few product lines and save the file so he can simply refresh the data in the future. Eventually, the Product Name filter will actually contain the Product Lines and the Product Line filter becomes unusable, usually resulting in a ...Show All

• 87jerome Call ReportBuilder from Access

  Hi, I have created a report with ReportBuilder for WIndows and now I would like to call and run the report from MS Access. Anyone knows how to do it Your help/suggestion is appreciated. Thank you ...Show All

• Robb Melancon Custom Desktop Application

  Hi All, Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device. For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx I urge you all to in ...Show All

• NemanjaTheLost How to add columns at run-time?

  I have a table: column1 column2 column3 column4 data data data data data data data data I want to create more columns at runtime, what should I do desired output: column1 column2 column7 column3 column4 column5 column6 data data data data data data data data data data data data data data The number of columns to be added is random. Please help. You could look into using nested tables. You'd have to predefine the number of columns at each level. I haven't tried it myself but I think it fits your requirements. One row group is required at least. Assuming you installed them during setup (under Client Tools), by defaul ...Show All

• dj1s Package configurations stored in the database

  If the configurations are stored in the database then does the package pick up the configuration as and when required or it a one time pick when the package is executed. What I plan to do When the package is executed, I want to have a script task at the start of the package that will update the configuration table in the database with the values that the package needs to run with. I mean change the values of the configurations of the tasks which will be executed after the script task. Thanks for your time. $wapnil spattewar wrote: I would used a foreach loop if it would have suffice our requirement. One of the requirement could be that we want to download file ...Show All

• mitasid Installing SSIS with SQL Server 2000

  Hi All, I have installed SSIS on server running SQL 2000 but I don't see the Business Intelligence or SSIS. I could see the SSIS service is running but do not see VS or BI version of VS. Any ideas Thanks in advance. I do able to see client tools but NOT BIDS. Fahad, I didn't see the option to install BI Dev Studio from VS 2005 installation. Do I need to install full VS to get the BI Dev Studio Please advice. Thanks. Bader Cheema wrote: That was my understanding too but after installing SQL 2005 client tools and Integration Services, I don't see the BIDS. Under Start->Programs->Microsoft SQL ...Show All

• BobInVermont Hyperlink action expression problem

  Hi, I've got a problem with navigation hyperlink action expressions not being evaluated correctly on 2005 when they worked perfectly on 2000. I've got expressions as follows: =LReportsWeb.LReportsCustomAssembly.GetWebAppPath() & "default.aspx ReportURL=" & LReportsWeb.LReportsCustomAssembly.URLEncode(Globals!ReportServerUrl & " " & Globals!ReportFolder & "/ContactReports&PIN=" & Parameters!PIN.Value & "&Dealer=" & Parameters!Dealer.Value & iif(Parameters!Surname.Value = "" , "&Surname:isnull=true" , "&Surname=" & Parameters!Surname.Value) & iif(Parameters!StartDate ...Show All

• creaturita Should I use XML Datatype

  Hello All, How much memory is consumed by the XML Dataype column when initially In what scenario should we XML Datatype Please see my scenario given below and justify that should I use XML Datatype Personal Information Key Name Address FriendsList BankAccounts PhoneNo Name PhoneNo BankName AccountNo If I have a scenario like above which option should I use Option 1: Make three different tables Named Main, FriendsList and BankAccounts Header table named Main PersonalKey Name ...Show All

• JLarkin matrix: more than 1 column in static rowgroups ?

  Hello, I am working with a matrix report item and would like to display something like that : DataGroup1 DataGroup2 StaticText11 StaticText12 Data1 StaticText21 StaticText22 Data2 StaticText31 StaticText32 Data3 But I cannot find a simple way to have 2 columns of static text on the left. The only way I've found is inserting a table report item in the matrix cells, but it cannot be exported in Excel. The only samples I found do'nt have multiple colums in the static rowgroup. Is it possible Kind regards, Xavier Miller. Hi, I'll try to give an example. I'm using the following query on the AdventureWorks db: SELECT Production.Product.Name, Production.ProductSub ...Show All

• simon chow report exported in Excel shows an extra empty page

  Hi We are working on sql server reporting services 2000. We designed a report and exported the same into excel. The original report has lets say one page information, then before printing when we see print preview it shows up an extra blank page and similarly if the there are two pages in the report ,in the preview we are seeing 4 pages ie two extra blank pages. Any help to solve this issue would be appreciated. The same thing we are exporting in PDF format also and here to same issue. We have SQL Server 2000 and SQL Server 2000 Reporting services and Microsoft Office 2003 Thanks in Advance DnetMgr Moving to SQL Server Reporting Services forum. It sounds like the (report body width + page margi ...Show All

• pwhitaker Viewing SQL Statements

  Is there any way that I can store the actual sql that a report generates after parameters have been filled out. I know the log tables contain parameters information, but ideally I would like to be able to copy the actual sql and run a query in SQL Server Management Studio. You can use SQL Profiler to capture the statements that are being sent to the server. ...Show All

• lissbpp Unhandled Exception

  After I installed Sql Sever 2005 and open SQL Server Management Studio, I get this error just after connecting to any server (DB / AS / IS).. Also, during the installationm, I had ignored an error that was raised while SSIS was being configured. The error said, that thr is already a 32 bit registry on the target Com + Application. You must remove the registry from that app. I have done the installation of SS2005 X64 edition. Attaching the exception :- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.TypeLoadException: Method 'GetMenuItems' in type 'Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Default ...Show All