Hi Steve,

This still gives me the same value i.e. 38. It does the same way like average function do i.e. (30+30+30+50+50/5).

I need it to calculate 40 (30+50/2).

It is not giving me any error. It is just not displaying the average like I want. In the grand total it shows the average for Total Units column as...

If I develop 4 subreports also, when my user wants to see the 4th level which has again 200k rows and I think it will be again the same issue....

I need to develop a report which has 4 levels of drill down, so instead of creating 4 subreports i just thought of using toogle and develop the report.

Hello,

My SSRS is not on the same physical system of my database.

I’m developing a drill down report and I need all the rows. I have all done all my...

Its givving Query Engine Error. Its running fine on my system. Just when i publish it on the server its failing.

I have created an identity and joined both the tables on them. I created clustered index on the identity so that the order is not changed. So far it works,...

When i used the full outer join, its not giving me the results which i want. It's giving me like this:

NULL ...

Thank you. While I was working after reading the article, my user suggested she wants it in CSV format. Which I can manage.

I know I may get these kinds of...

it worked when i changed it like below and then pass in open query.

Declare @SalesMonth int

Declare @SalesYear int

DECLARE @TSQL varchar(8000)

Set @SalesMonth = 5

Set @SalesYear = 2009

Declare @SalesMonth1 varchar(10)

Declare...

Hi, I tried it before but it was not giving the output the way I desired.

NULL NULL NULL 2009/04/01 - 2009/04/07

1 10.00 A 2009/04/08 - 2009/04/14

2 10.00 B 2009/04/15 - 2009/04/21

Thank you so much, it worked.

I figured it out. I added one to datediff in where clause. I made a temp table and removed where startdate is greater that end date. Thank you...

If I’m running for @SDate = '3/1/09', @EDate = '4/21/09' then it is giving me only 7 weeks.

It’s not giving me the last case which is ‘04/19/2009’ to ‘04/21/2009’.

Suppose if the start date is ‘2009/04/01’ and end date is ‘2009/04/19’ then I need to split them as

Startdate1=’2009/04/01’

Enddate1=’2009/04/07’

Startdate2=’2009/04/08’

Enddate2=’2009/04/15

Startdate3=’2009/04/16’

Enddate3=’2009/04/19’

Like this I need to split the days. The maximum which...