Answer Questions

• swfranklin List Property - can grow/can shrink

  I'm trying to generate a report that will simulate Avery Standard form 5388 - a basic 3 x 5 index card. I'm using a list and a table to generate the output. Basically I have the list sized at exactly 3 x 5. I'm limiting my rows to be returned to 5 rows so that the table does not grow too large, and I'm using the Page Header to handle the top space, and have placed the list/table regions within the body region to handle the left margin. The ...Show All

• Lubeto Is the STDEVP Function in SSAS same as STDEVP in MS Excel?

  Hi, I am struggling with implementing a Calculated Member to perform the same STDEVP() as in MS Excel, over a FACT table. I have tried using the STDEVP() provided in the Cube designer Calculation tab, and have failed to get STDEVP ( Set [, Numeric Expression ] ) working. My FACT table looks like this   Time_Key   Customer_Key   Transacted_Amount   ... I supposed <<Numeric Expression>> should be replaced with [ ...Show All

• Christian Neuhold SSIS Script Component

  Dear all, Such a pain, I know. Yesterday I did a couple of questions regarding transformation rows and very kindly I obtained answer (Thanks Jamie and Michael) But now I face another stupid issue and is how to map source with destination columns inside Script Component Task. On my Flat File Source I’ve got defined thirteen columms (from Column0 till Column13); that’s fine. And then, I’ve got a sql table as destination with another ...Show All

• Devo Rendering Report

  I have created a page in Reporting Services with one row of data, but when the data is increased to 5 rows my pages doesnt render that...Any suggestions Thanks it worked with a list. You need to use a dataregion (List, Table or Matrix) to display the data. Try adding a table with detail rows, each row from your dataset would show up as a detail row in the table. ...Show All

• JohannSinuhe Object reference not set to an instance of an object

  I enter http://localhost/reportserver and get the error message from Reporting Services:: "Object reference not set to an instance of an object" along with a link to Get Online Help. I click the link to get the "Details" and am told "We're sorry, there is no additional information in the error logs or knowledge base. I've run the RS Configuration Manager many times to try different options, I've also run SQL Server Co ...Show All

• Kamran_MSFT Page numbering - X of Y format

  I have a reporting services application which generate reports for given IDs. You can pass any number of IDs. e.g.. If you pass 2 IDs it will generate a single report for those 2 IDs.. Page numbering would look like 1,2,3,1 for ID 1 it has generated 3 pages while for ID 2 it has genereted only 1 page. But I want the page numbering to return 1 of 3,2 of 3, 3 of 3, 1 of 2, 2 of 2. Parameters i pass to generate the report is only the ID. ...Show All

• petxa AdomdConnection.GetSchemaDataSet - using restrictions

  I'm attempting to use AdomdConnection.GetSchemaDataSet to see what information is in the AdomdSchemaGuid.PartitionStat dataset. I am setting the restrictions parameter to null. The error I get is "Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException : XML for Analysis parser: The DATABASE_NAME restriction is required but is missing from the request." All well and good, except that I can't see in the documentatio ...Show All

• Computerman45 Updating empty Image field in existing SQL table record

  I have an existing SQL table with a little less than 100,000 records in it. I need to update an image field in each record with n image selected by the user at runtime. (The image will actually come from a webcam). I am able to successfully add a new record, including the image, to the table, using DataAdapter/DataSource. However, I am unable to update an existing record. The code I am using for both the update and the Insert is identical except ...Show All

• shassbel Proxy account not responding

  Hi, I have an SSISS package running in a job step, the job is owned and has to be run by a non-sysdamin SQL login. I have created a new credential (windows autrhentication, sysadmin priviledges) , mapped it to proxies 'SSISS' and 'Operating systems (CmdExec)' and have assigned the job step to run as that credential. Yet I'm getting the following error message: Unable to start execution of step 1 (reason: Error authenticating proxy Domain\ ...Show All

• Marc2002 Transformation Service question about de_dup process.

  A standard SQL statement that is used a lot in SQL is a left join. What I'm trying to do is dedup a table. Example: Select * from table1 as t1 left join table2 as t2 on t1.firstname = t2.firstname and t1.lastname = t2.lastname and t1.gender = t2.gender and t1.dob = t2.gender where t2.lastname is null What I thought was with in a data flow I have one OLDBD SQL statement that is the full table and in the second tab ...Show All

• John Roper-Lindsay Open the subreport in an new window .

  hi can any one tell me whether a sub report can be opened in an new window. I assume you don't mean subreport, rather you mean a drillthrough report. You can only do this in your custom app, not Report Manager. When you host the report, use rc:LinkTarget=_blank in the URL. You can also choose any other frame. thanks for the reply .i have tried this but it is not opening in an new window , this is what i have written http://localhost/ ...Show All

• MurfMan Question about the way that some element are displayed in the viewer

  Hi! I've notice in some reports that some lines doesn't appear in the viewer but if i print the report or if i export it to PDF i can see the line. I can't figure out what is the cause of this. Anyone know what is the cause of this Thanks ! I've figured out what the problem is. Most of my reports are imported from Access so maybe the problem came from the import function. Like you said i've found that some ...Show All

• rvsrinu SQL 2005 Database Mirroring - AD required?

  Hi, for SQL 2005 - to set up database mirroring, is it required to have Active Directory installed or to be part of a domain I am looking to use a workgroup with the SQL machines only and to not reference any domain and cannot find this information - is this possible This is primarily because the domain controller is Novell eDirectory. I am aware of Microsoft's SFN, but would like to not have to use it or any AD if at all possible. Thanks ...Show All

• kubaw Getting data from 2 different sources

  Hi, Im using SSRS to create a report which has one table that resumes a state of something. I have this information in 2 diferent tables and im using mdx querys. My inforamtion is like this Table 1 S M L Total Shop Stock 1 4 3 8 shop sales 2 4 2 8 Table 2 S M L T Wareho ...Show All

• Greg Mc Export and Import Database from Sql 2000 to Sql 2005

  Need help exporting a database from Sql 2000 Exterprise and Import it to Sql 2005 using Sql Developer. I have tried to do a detach - copy mdf & ldf to new syatem and then do an attach - This doesn't seem to work Also tried backup on 2000 and then Resore on 2005. This doe not seem to work. Source system is 64bit and destination system is 32bit Not 100% certain but the problem is probably with the 64bit to 32bit conversion problem.&nbs ...Show All