Answer Questions

• Inferno986 Getting aggregate returns with single parameter(matrix)

  I want do a comparison with 2 years worth of data: IE: I have a column that is either calendar year, quarter or month. Only one parameter must be passed for this but the preceding year must also be called. Like when Qauter1 2004 is selected it must return: Q1 2003 Q1 2004 Field!Value Field!Value I can only get it to show all the years or one. Any help much appreciated. I've tried to implement this method but was unable to get it working: My data source is a cube and the first option did not return anything in the report when previewing This is all within a matrix with year as the column group I may have not explained this correctley: ...Show All

• Benorama TextBox break layaout in excel

  Hello, I have textBox in header of report, and it's expression - based (= "test text"), when I export in excel I get at the first time report that looks normal. But at the second - I get report with broken layout (I can press CTRL + F5 and all will OK) Or I can set TextBox static(not based expression) and all will OK too Could you please help me to solve this problem I'd like to have a dynamic textBox and normal layout. Thanks What's difference between based expression textBox and static when it's renderring ...Show All

• jonez108 How can I bind a ReportViewer to a DataSourceControl?

  I have created a System.Web.UI.DataSourceControl which interfaces with an external application and, with the help of a DataSourceView, generates an IEnumerable collection which can be used as a binding source. The primary use is to publish a table of data to a web page using a GridView which is bound to the DataSourceControl via it's DataSourceID property. All of this is working perfectly and now I want to be able to publish this same grid to a ReportViewer running in Local Mode. What is the proper way to do this I know I need to design a report, but am unclear about how to make the connection between my DataSourceControl and the report. Here's what I have done so far, but am not sure if I am on the right path. Starting with my existing, w ...Show All

• Jason D. Camp Is this possible? How

  hello guys, I want to create a report using a bar chart data region from a cube. The cube contains Date and Time dimentions. Here is my question: The catagory field (x-axis) value of the bar chart is dependent on the paramaters value(i.e.StartDate and EndDate). For instance if the difference between StartDate and EndDate is greater than 1 year, the x-axis value for the bar chart should come from the Date dimention and display the year value. Similarly, if the difference between StartDate and EndDate is less than a day, the x-axis value for the bar chart will come from the Time dimention and display the hours value. Does any body came across this kind of scenario. Appreciate your assistance. Amde ...Show All

• doczap Reporting Services 2000 Standard Edition <> Internet Access

  Hello people, There are quite a lot of threads about deploying Reporting Services for Internet Access. Some say you can't use the Standard edition for global access, some say you can. The problem is that I can't find any hard evidence in MS material like the deployment guide. I only wan't to know if it's possible to deploy a Reporting Services 2000 Standard Edition for Internet Access with anounymous access. Does someone can tell me why it's not possible Any resources that say it can't be done Many thanks! Worf ...Show All

• c-breeze SQL Server Managment Studio Express 2005 Import/Export Wizard

  I've created a new database and restored the database from a backup. I'm wanting to import raw data from an excel spreadsheet into the tables of the new database. When I right click on the database, and hover over tasks the import/ export data menu options are not in the menu.The menu items ends at 'Generate Scripts'. I'm connected on a local instance to a registered server. Can anyone advise hi, Lee Rivers wrote: I've created a new database and restored the database from a backup. I'm wanting to import raw data from an excel spreadsheet into the tables of the new database. When I right click on the database, and hover over tasks the import/ export data menu options are not in th ...Show All

• Leon Zhu Implementing Sql Server Express within a Strict Domain Environment...

  I am looking for some assistance from the grand knowledgebase out there concerning the implementation of Sql Server Express 2005 on a client's strict domain environment. I am designing and implementing a pos software that resides on registers and a server within a number of stores. The registers are running WePos and the server is running Server 2003.  I run an instance of sql server express on all devices. The registers read the server when it can see it but when it cannot it reads the local instance. I am seeing a number of performance issues and I am trying to tweek the installation and coding of SSE on all devices. Any words of wisdom for me out there Thank you, Sir Robert   The issue is more off how ...Show All

• Robert F Bouillon Decimal Separator with Comma... is Possible???

  In Sql Server Express I need use in field MONEY "update product set price= '1,23' where cod='001'" i don’t use "update product set price= '1.23' where cod='001'" hi, with all kind of datatypes supporting fixed or non fixed decimal values you have to use the "." as decimal separator... so you have to code UPDATE ... SET price = 1.23 WHERE... and this without the " quote for the value... regards ...Show All

• C&amp;#35;Student schedule the task

  I want to schedule the task using contro panel schedule task item. I want to run two package in sequence. If the execution of one gets over then other should start. I have configured the execution detail in BAT file. I know how to schedule the task. But can anyone please suggest me how to schedule the task in sqeuence i.e. execution of BAT file in sequenece (one after other). thanks for the reply. But My packages are not dependent. and I want to use the windows schedule task. I want to run it using the BAT file, PLease suggest me how to schedule it using windows scheudle task one after other I suggest that specifing job from sql server agent is th ...Show All

• mattdawg Programmability of parameter bar(layout/items)?

  Hi all, does anybody of you know how to code and customize the parameter bar of the SSRS reports I know about putting code behind expressions but how is it with parameters How is it possible to... 1. define the layout of the parameter bar and the positions of the parameter items 2. make the parameter items user-specific Is it possible to define a report with the report designer and hand over data (parameters) by code-behind or a referenced assembly Thanks a lot for any help Best Regards Marc Hey Russell, that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control. Cheers Marc ...Show All

• Martin Mason Cell Calculation for cells that already has values

  Hi, I have the table like this Jan Feb .. Dec account 50 20 ... On the cube i would like to make it using calculated cells and that look like this account 50 70 ... Same cells has before. I have tried a few stuff but i cant put values on top of the ones that are already there, so i get the values in the cell and not the values in the calculated cell. Funny, though, i have put a constant (1) i the 'AS' part of the calculated cell syntax and it adds the cell value with the constant. But if i try to add with the value time.lag(1) SSAS just ignores the value. Is there a way to do this by calculated cell Thank you You did not mention which version of Analysis Services you ...Show All

• skalapeno NTEXT special character "SQUARE" appearing where a return should be. How do I fix this?

  I had to import some FileMaker Data into SQL Server 2005 and in the resume field a "SQUARE" special character is appearing everyplace that a return should be. It has really messed up the formatting. I know how to use the updatetext in a cursor to replace the special character but I don't know what to replace the "SQUARE" special character with so the text is displaying a new line rather then this "SQUARE" character. Any help would be appreicated. Where do you see this This is can be common if you have a control that isn't set to multi-line, but it shouldn't show up like that in SSMS. First step is to identify the character. For example, if your string looked like this: this character her ...Show All

• twonjosh Bug?? Transfer SQL Server Objects Task - error when copying Views

  I'm trying to copy data over using a Transfer SQL Server Objects Task however I get problems trying to copy over views. I get the similar error (pre sp1) when using import/export wizard and copying over views. Now with SP1 the views just don't transfer. I'm transferring from SQL 2005 to SQL 2005. The error I get is: Error: 0xC002F363 at Transfer Data (NEW), Transfer SQL Server Objects Task: Table "vw_XXXX" does not exist at the source. Task failed: Transfer Data (NEW) I know the view exists at the source because: A) I can select it in the Views List Collection within the Transfer SQL Server Objects Task B) I'm using the view on the source Somehow the views are not transferring. Anyone have any ideas ...Show All

• Six Default Parameters Not being set

  Hi there, In my report, I have set the default parameters such that it is supposed to automatically render when the page loads. I have set the defaults in Report / Report Parameters and it even works in the preview pane, however, when I deploy the report, the defaults are not set. This report has subreports, and I've tried setting their defaults. Has anyone come across this Thanks, LBD Hi there, What is the default value you are trying to set Did you try to go to the Properties page of the report in Report Manager and set the parameter there Sometimes I noticed that you have to delete the report before deploying if it already exists on the report server. cheers, Andrew That s ...Show All

• vasudupe SQL Query

  I have a query that i created which searches all logs to see what users did on the website for the COMPUTER account. SELECT u.ID, u.LastName, u.FirstName, u.Company, ua.AccountID, wsl.SessionBegan, wsl.ServerName, wal.Activity FROM [User] u INNER JOIN UserAccount ua ON u.ID = ua.UserID INNER JOIN wwwSessionLog wsl ON u.ID = wsl.UserName INNER JOIN wwwActivityLog wal ON wsl.SessionID = wal.SessionID WHERE (ua.AccountID = 'COMPUTER') AND (wsl.ServerName = 'www.test.com') AND (wsl.SessionBegan > DATEADD(Month, - 6, GETDATE())) ORDER BY ua.AccountID What i would like to do is the following reformatting: LAST Name | First Name | ACCOUNTID | Aug 06 | Sep 06| Oct 06| .... | Jan 06| Feb 06 The activity should be ordered by t ...Show All