SQL Server Reporting Services (SSRS) Interview Questions 

I have SQL 2000 but I cannot find where I can download the stupid software! I want to test it out but I spending my entire day just trying to figure out where I can download this thing.

Im using SQL Server 2005 Express Edition as a database for my VB 6 aplication. I would like to pass a parameter from my vb6 aplication to a report which i made from SQL 2005 reporting services. Can somebody help me with the codes on how to pass a parameter and other which is needed to generate the report. Thank you.

Suppose my query is "SELECT * from Finance". How to pass this query from my VB/C#.net application to a report "FinanceDetails.rdl" report? Please help.

I connected to the database fine, but when I generate the model for the database, it gives me the following error message.
More than one item in the Entity 'PR' has the name 'X Charge Wks'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help

More than one Field in the Entity 'PR' has the name 'X Charge Wks'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help

Hi,

How can the size be calculated for the XML code generated from SQL Reporting services?

Regards,
Milan

I am experiencing extremely slow performance on my company's reporting server with only one report. There are currently about 30 reports hosted on the server, the vast majority of which will load within a few seconds after having being selected; however, one report on average takes about 5
minutes to load. Previously, when first added to the server several months ago, the report performed just fine, but in recent weeks the load time has signifcantly degraded.

I want to know all the possible ways to convert null values to zeros in Textbox controls using Sql Server Reporting Services 2005.
I know I could use isnull(columnName,0) in my T-SQL select statement, but that's ugly. I can also use some function in the Value property turning this: =Fields!TranNo.Value into something like this: =cint(Fields!TranNo.Value). Is there anyway to use the Format property? I don't know much about the .NET code that you can write in a report. Is it only capable of Functions and Subs that get called from field values, or could I code some kind of event handler like in an MS Access report? OnReportLoad kinda thing? If I could do that, could I loop through the rows and columns of the dataset and swap out the nulls for zeros there?
Thank you for your help! I've been trying to figure this out and going crazy!

Hi,

Im looking to re-install my Reporting Services for SQL 2000 and I cannot find the installation executable within the SQL CD. Does anyone have any idea where it is? Is it even included with SQL 2000? Or is it on a separate CD? Thanks.