Answer Questions

• AndyK SQL DataReader Mischief ! HELP !

  Why oh, Why is this happening.. Fastest winner gets a gold star ! hehe Just after i check the value of the data reader against the string in the IF statement, the code skips. If there is a record (=) to my varible everything is fine. However the IF ELSE will not work inside the While loop ! If i remove the record from the database and run the below code the IF statement skips (well skips the (Else)) and bombs out. Public Sub ...Show All

• Thomas Horan Problems instancing Reporting Services

  I set up Reporting Services as a Web Reference and when I try to instance it, I get a "type expected" error message.  Let's say the web reference is named SQLRS.  When I do a DIM rs as NEW SQLRS, a blue squiggly appears under SQLRS and it displays the type expected error message. What am I missing   Anyone know or have a link to an example I could look at   Thanks for any help. Additional in ...Show All

• Kolokolov Source and Target - Both Behind Firewall using NAT

  In this situation do I need a proxy or forwarder at both ends to prevent connection issues Are there plans to handle this in future SSSB upgrades. Thanks. I'm not sure I understand the question correctly. Just for NAT, you need to enable port forwarding on both NAT devices (firewalls), and the routes should point appropiately (to each other's firewall). When you mention forwarders, you refer to SSB forward ...Show All

• plsh Annoyed with SQL Server 2005 Imponderables - Help!?

  Hello, upon our recent upgrade to SQL Server 2005, there are three issues that have plagued me that I cannot find a workaround for, despite much forum scouring. 1. I have a DTS package that I migrated to SSIS.  The migration seemed to go smoothly, and I can successfully run the SSIS package.  However, when I try to create an SSIS job from it, the job fails to run.  I merely get a "The step failed" error message.  I've ...Show All

• gokaraju Selecting a default value in dropdown

  Hi everyone, i have a report parameter that is a single select dropdown, populated from a dataset that is an mdx query on a cube. Here is an example of what the mdx query produces (sorry about the formatting):   ParameterCaption ParameterValue                                &nbs ...Show All

• Reggaeton_King RUNNING A DTS PACKET FROM WITHIN TSQL

  Here is my problem: I don't have permissions to the 'master' db, thusly I don't have permissions to 'xp_cmdshell'. However, I need to output several small tables that I have created from one large table into individual text files. Now, from the documentation I have read this is easily possible with the use of dts packets. However, my knowledge of dts packets is non-existent. So, I have created a dts packet that will take the data from a table ...Show All

• KristerS mdx question

  I have 2 dimension tables :students and classes related through a fact table that contains the keys of these tables in addition to other keys such as academic year and other stuff. the classes dimension has an attribute called class_department. what is the statement in mdx to get the class_department for a student in students table thanks Christina I guess you want the MDX query Since I don't know ...Show All

• Phillip Misner MSFT Expression question

  I don't know any other way to ask it than to post my code and ask what's wrong w/ it. It looks right to me, but I'm getting an error every time. Any and all suggestions are greatly appreciated! This one returns a value of False: =iif( Fields!Appearance.Value=4, Fields!Appearance.Value="Poor", iif( Fields!Appearance.Value=3,Fields!Appearance.Value="Fair", iif( Fields!Appearance.Value=2,Fields!Appearance.Value=" ...Show All

• bobbyp transaction log

  Good day to everybody, I have this problem once, but maybe i will encounter this again regarding the transaction log that I do not know why it grows bigger that it consume my harddisk space of 15gig althought my data file consume only 25mb How does it happen and why The only thing i do is to make a new temporary database, copy the tables inside on it and erase the old database whose transaction log is full, then bingo!!! I emptied my harddisk wi ...Show All

• radpin Aggregates in Matrix Reports

  I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem. I have a calculation (Aggregate) that has a scope that is for both the Row and the Column. Example: What is the percent of total sales and percent of total category sales How do I do these Percentages in a Matrix                 &nbs ...Show All

• Chitra Using a subreport with a parameter

  I am new to subreports, but I understand the concept and maybe what I want to do does not require a subreport. But what we have is a report that has four groups that can be drilled down to the details. From the details, I would like the user to click on a cell (which is a customer ID number) and then have the report display the customer's details in another report (like address, city, state, zip, etc). Am I on the right track in using a subr ...Show All

• Randal Greene Remote Error Problem

  Hi all, I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors): An error has occurred during report processing. Cannot c ...Show All

• rishimishra Enable or disable a relationship between 2 tables at runtime?

  Is that possible Can somebody show me code in how to accomplish this. Thanks    If you mean foreign key relationship: yes -- see the ForeignKey.IsEnabled property. You can switch FK relationships on and off.  ...Show All

• Kranti GUID in Mobile SQL

  I have been trying to setup the GUID new GUID when I add a row into a Pocket PC WM 5.0 Mobile SQL (*.sdf) utilizing C# through Visual Studio 2005 - targetting Pocket PC Smart Device Any help would be most welcome... Thanks It is marked as newid() -- I blocked the chec for null and it allows me to see the data in the grid but the data is not persistent, and if i try to readd new data then i get a SQL system error on the not nulla ...Show All

• Olivier Robin Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All