Hi,

on same reporting calling it with manually different parameters and calling in the same report.

output has to be shown in 6 tables.

My SP and table are one each.

but when i invoke it every time i use different parameter.

so due to inusffucient time, this is happening.

do you nee more information on this.

Kindly help me on this if there is any work around.

thanks

but this report every employees will generate it when they need it(not every day or constant interval).

will try this and getback hope this doesnt need .net knowledge

i thought the SP may have several lines of code, only few may causing the issue which may be easy to find(index or other).

do you think my approach is wrong...

hello,

in profiler you can use StmtCompleted under stored procedure section to find out the time taken and based on that you can action it.

Hello,

in my production server the maximum memory in MB reads to 2147483647.

is it set by one of the technical team or system decided, because the values doesnt contribut to any...

Just a thought, do you require the input parameters to be defined too big like this.

then why dont you use between for date fields.

and check how it is running on...

thanks for prompt reply will check it

Hi Steve,

i said i don't find any much use in giving the file name's manually. it has to be automatically taken with some increment type for the successive file names.

is...

thanks

informed Sys admin team about it for winzip or win rar. waiting for reply.

just a thought is it not an issue SQL 2005 is giving option to specify file name...

Thanks for the posts guys.

Backup dome automatically through a job and maually write it on DVD.

Blueray option only management can decide on it.

i found out option of specifying 2 or...

Hi,

i have tried that.

this is the statement i am talking about.

"This address proof letter is being issued for associate to apply for name change on PAN Card in the individual’s...

Is ther any way around for ssrs 2005.

thanks in advance.

looks same like iif

can i know why you want to avoid iif

thanks