Hi,

Probably the best way is to create temporary table into the stored procedure and when you are writing to Excel file at that time you can say select * from...

hi,

this can give you last sunday. You need to manipulate date to get it every sunday.

select dateadd(day,1-datepart(dw, getdate()), getdate());

Hi,

Basically when there is select statement of average for admdat and disdat i need to specify some condition in where clause of that select statmenet.

table is simple but very...

Hi,

thank you very much for your reply. I got the solution to schedule it using reporting services subscription. It is very easy and quick job using reporting services.

If anyone scheduling...

hi,

When you write your stored procedure, at the beginning you can write some code which will create entry in one table. You can create one table like SQL_Usage (Report ID,...

Hi,

You can change date format by writing following expression.

DatePart("d",Parameters!startdate.Value) & "/" & DatePart("m",Parameters!startdate.Value) & "/" & DatePart("yyyy",Parameters!startdate.Value) & " and " & DatePart("d",Parameters!enddate.Value) & "/" & DatePart("m",Parameters!enddate.Value) & "/" &...

hi,

well you can change format of your date when you write expression by extracting date part from your date. Or you can change stored procedure date format so that it...

hi,

If one parameter (sub category) appears after selection of other parameter (category) then it is necessary that screen should refresh. At that time it will run your query from dataset...