So friends my doubt is still not clear.. I'm copying it here again..

Ok.. so we understood the importance of order of declaration,thanks for that.

But even I have the initial...

Ok.. so we understood the importance of order of declaration,thanks for that.

But even I have the initial doubt in the post, similar code is here using WHILE.

Is it like...

Ok.. if there is main report and one sub report, then if you apply page break, it will be in two different page only right..? Main report in one and...

Hi can you check is there any space between the sub-reports.? if so delete that and align the sub-reports so that it wont overlap,the give page break after each sub-report.

Also...

Hi try this,

SELECT dateRange,DATEPART(WEEKDAY,dateRange)as Week_day

from

(

SELECT dateRange FROM ##salesdays

EXCEPT

SELECT date FROM dbo.csta_non_working_days

) as t

Hi in SSRS this is called cascaded parameter. ie the available values of a parameter changes based on the values of previously selected parameter.

To do this, the SP which provides...

Yes you are right SSRS 2008 is not dependent on IIS

Friends,

The dynamic connection for excel is not working for me when I'm appending the full time string, other wise it will work.

As I have mentioned when the connection string...

Hi Mhlewis,

Yes I would like to keep different excel file for each execution thats why I tried to append the full time.

As you told I can try taking the...

I agree with your point about Getdate() , the excel file name looks like

Name_2010_7_13_17_55 (Name_Year_Month_Day_Hr_Minute)

But I'm wondering then how the same is working fine with .csv (ie if I use...

dear friends one more strange thing what I have noticed is,

As I have given the connection string including the year,month,day,hr,minute if I execute the package within a minute say...

Thanks for the replays...

I have tried the same thing as mentioned initially it was pointed to one test file and then in the expression of the excel connection manager I...

Sorry friends...

2005 SSIS also giving the same error. But both 2005 n 2008 are working for flat file destination but not for excel....

Any idea how to make it work ?...

Hi Da - Zero,

Thanks for the reply.

As you specified I have tried the new expression in the Excel Path expression (New connection string.jpg attached) but Im getting error as...

Instead of IF ELSE you can use CASE statement, but here all the cases are with same condition ie @@ROWCOUNT = 0 , so no point in using that.

Check the...