Answer Questions

• Timothy Butterfield SQl Server CE question..

  Hello.. I want to install Virtual Directory (PC Windows 2000), but I've got this error "The computer that you specified is not configured for NTFS. You do not have to set permissions." Did I can't do my merge replication using PC without NTFS You do need NTFS to properly set permissions on the virtual directory. Darren Thanks Darren.. I'm already convert my PC from FAT32 to NTF ...Show All

• TommK subtotal and subaverage

  Hello, I want to have a subtotal column AND a subaverage column (or n total columns) like the one in the following example - but without the extra Avg column in the Data area. How to do that 2000 Q. 2 April Avg May Avg June Avg Total Avg North 4800 4800 5708 5708 5580 5580 16088 5363 ...Show All

• 勇敢的心 Formatting Date/Time

  What do I have to use to Format my date/time fiels so that they will not include the both the date and the time I imported the db's and reports from access and anything date/time shows both. The VBA functions I know are powerless to fix this. So: Format(fields!DateField, 'hh:mm') Format(fields!DateField, 'ddmmyyy') What are the equivalents Yes, I read the manual. Still not obvious to me. - Thanks in advance. Format is the VB.NET Forma ...Show All

• Karthik R SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Dave Githens PivotTable Total from Database

  hi, i'm trying to create a PivotTable in which I will be able to see totals coming from the database, not a calculated total field performed by the PivotTable. The data are structured with a hierarchical dimension for wich values are existing for each low level detail item and also for the high level detail item. Is it possible to create a PivotTable based on a ROLAP(with SQL query) access that provide this kind of result (with tota ...Show All

• erato Way to develop and publish reports using Model Designer

  I am working on BIDS (June CTP release) from last 6 months and especially on SSRS 2005 and SSAS 2005. After my research and development, I would like to publish my methodology to develop and publish report using SSRS 2005 and would like to ask experts to provide us suggestion for any better way to go ahead with SSRS 2005. Following are the steps, followed to prepare report based on Model, 1. Create a basic report using Report Builder 2. Save Rep ...Show All

• Julie2 SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• fatlog Cascading Parameter issue with RS2005... It worked in RS2000

  Our company is attempting to convert several RS2000 reports to RS2005. We have 4 default parameters on every report. 1) Date Range (dropdown) – populated via Non-Queried Available values (Ex. Today, Week to Date, Month to Date, Fiscal Period) 2) Fiscal Period (cascading dropdown) – populated via Query Available values (if Date Range = ‘Fiscal Period’, select the last 24 fiscal months, else select Date Range value) 3) Start Date (cascading t ...Show All

• CarlVerret same visual studio standard 2005 product key from the "ready to launch" dvd set

  Hi, I attended the Technet Ready to Launch event and obtained the dvd set, but when I tried to install the sql product, the software won't take the product key (the key is the same as the studio product).  Anyone experience the same Hi, I did called this morning (11/30/05) and SQL Server Support for Developer transfer me to 1-800-360-7561 to generate product key.  The customer support only validate t ...Show All

• Ferozanna Problems With SQL 2005 SP1 (x64)

  Hi, After installing SP1 onto our SQL x64 2005 box (running Server 2003 x64 R2), I have come across two problems. The first is that the install seems to fail for database services (and I see I'm not the only one), declaring the following: Thanks for the reply. The file permissions haven't been touched, and disk space certainly isnt an issue (doesn't even come close to filling any partition). I've dropped some more information into ...Show All

• jyotish Report Viewer/Default Parameters

  Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer Thanks. accessed acceded accused accedes accursed Edit... Ignore all Add to dictionary (No suggestions) Edit... Ignore all Add to dictionary accessed acceded accused accedes accursed Edit... Revert to "accesed" If you are using the Repo ...Show All

• Scott Ha Shading By Value

  Currently in my reports I am shading every other row by using an expression in the background color property. This works fine. Is there any way to shade by other options I have a report with a non-unique id as the first column. I would like to be able to alternate the background color based on these id's. For instance I might have three rows of white background (id = 1), five rows of grey background (id = 2), and two rows of white background ...Show All

• Jens Uffhaus Can't Deploy AdventureWorks in Analysis Services

  Hi All, We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure ...Show All

• trager Im a beginner: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied.

  Hi! when i try to import data from Microsot Access to Microsoft OLDB DB Provider in the "DTS Import/Export wizard", an error occurs: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied. I'm using windows autentication and the data base of destination is <default>. Could you help me out Tank you Please check if SQL Server is running. Thanks. Make sur ...Show All

• esskaykay Problems saving edited Functions in SQL server database using Visual Studio .Net 2003

  I'm fairly new to using SQL Server - can anyone recommend the best tools for creating/editing/debugging Stored Procedures/Functions on SQL server 2000 SP3. I've tried using Visual Studio .Net 2003, but there are problems just trying to save edited Functions in the SQL server database. The database (upsized from Access2003) is on SQL Server SP3, which is running on the same computer as VS2003. Using VS2003 Server Explorer, scalar-valued ...Show All