Thanks for the reply..

That answers my question. The master report page properties in play rather than the subreport page properties.

After analysis of both execution plans, the query when executing in Management studio is using Merge Join instead of Nested Loop.

So I included the hint "Option Merge(join)" and everything...

I added a parameter to SP. For a different value, only one SQL statement get executed. All sql statements are going against same tables. What is puzzling is execution...

The one thing I noticed different is the estimated number of rows is 1 in Stored procedure, which made the node Merge/Join instead of Nested Loop and everything from that...

The other thing I can add is the array manipulation. I made my mathematical calculations from an array. I can use CLR from either .net program or part of T-SQL...

I am wondering if one can write a function to set the value and use it anywhere without the limitation of the scope. Just a thought.

Dim x as...

Am I correct in assuming that you always want to pass the client Id from external source and giving a default value to internal or hidden value is not the...

Give me a specific problem, then I can provide a step by step solution to it.

The following is the general procedure to create the parameter.

Right click on the...

You can use report parameters for this purpose and say they are for internal use.

Right click on the colored traingle of the subtotal box and get the properties of it (Not the textbox). Adjust the back color

Hope this helps.

Let me understand the problem.

1. You want list of all registrants with guests (and their invoices)

2. You want list of all registrants with no guest (and their Invoices).

The first...

You can see your packages logging on to Integration services from SQL Server 2005 Management console. You can keep them in file server as well. 

Dim execApp...

None of the options worked. So I created a class to execute from VB rather than SQL server and included that class. I haven't finished testing yet and will post...

search on CellSetgrid and ThinSlicer(http://richardlees.com.au/Demonstrations/) are two free grids available.

Check them out. Atleast I feel you don't have to pay for the bugs. 

THE FILE IS ON SQL SERVER. Please note that I included the stmt. dtexec /SQL pkgfolder\packagename.. The reason for the pkgfolder is a way to group my subsystems. Nothing to...