Hi could you please try this:

1) At the end of the sp try to inset the records from two tables into a single table(temp table) which has got the columns...

Sorry to tell you that I didn't understand what you are trying to convey. Is it possible to put the expected format of result in an excel and attach? So...

You mean to say date and just below that the other data... right? like how it will come in a table..?

Select the individual column and do proper alignment...

Can you try using matrix ?

1)Drag the first column to the first column of the matrix

2)Insert one row for the column data and drag the second row record.

3)Hide...

Thanks a lot Luke,

Something strange happened, I gave the expression like below and it started working, really don't know why before it was throwing an error as "expecting http://" ...

Hi friends I was away for a couple of days from this request...

I'm still trying to get a solution.

Luke / Veeren ,

As you mentioned I can use the http:// link...

Along with the above solutions,

Please check the format of the field RegistrationDate is same as the hard coded value? else please do proper casting.

And are you able to use that...

Hi Enis,

So your SP is using temp table, as other friend mentioned even I believe this is the reason. You can follow above solution. I have attached one doc which...

Yes yes.. 🙂 thanks a lot.

hi,

Inside the SP are you using any temp table ?

Thanks a lot Gail,

I remember I red it in some books the point I have mentioned any way thanks for the clarification. Are you sure that all joins are possible...

Along with the reply other friends provided I would like to add one more.

As they mentioned it depends, we cant say one is better than other, but when you go...

Hi could you please try the below steps and see whether it is improving the speed.

1. Make the PRIMARY KEY on the table2 as NON Clustered

2. Create a Clustered index...

Hi Subreport itself is a report. What you are trying to do is not clear but still proceed as below.

1. Create the main report

2. Create second report (this your subreport)

3....

Please make sure that in the other machine:

1. ReportServices is running

2. Report Server is configured

3. In the property of the solution you have given the full path as:http://IP/Reportserver and folder...