Hi Willem,

Thanks for the reply, when I ran it through BIDS I have got the below error:

"An error occurred during local report processing

An error has occurred during report...

Hi

When you drag a field from the dataset to the "Drop series Field Here" section of the chart, what ever values comes in that field will show as Legend.

I'm...

Hi

If my understanding is correct, you can just merge the two cells of the footer and can give the below expression.

=IIF(Fields!ACTUAL.Value < Fields!MINIMUM.Value,"INSUFFICAINT DATA FOUND","")

No need of adding third column....

Hi ,

Just an addition to the above method, also I hope you know the database name among the existing the databases in the server, if so you can even use...

Jack,

Just to clarify on more thing,

I need to try this in production database , so before executing ( I'm not sure whether the default trace is enabled or disable over...

Hi Jack....

Many thanks...!!!! it really helped me... hope it is a very good knowledge for others too...

Once again thanks for your prompt reply...

Regards,

MC

Hi many thanks for reply.

I'm not that experienced in SQL ,I think the below script is the basic to get the default trace.

SELECT * FROM fn_trace_getinfo(default)

Could you please help...

Hi,

May be the link is different. In IIS brows the homepage as in the screenshot. This the correct link you need to use to open the report.

Regards,

MC

Hi

If you are in a position to can't change the table structure , lke you have month column but can't add the sort order column , give the order...

Ok, so meane to say flagged for recompile is different from this? I thought both are same, my be my lack o knowledge.....

If you dont mind can I know what...

Hi

Could you please check whether the below script can help you..

SELECT OBJECT_NAME(ID)AS SP_NAME,* FROM SYSCOMMENTS

WHERE TEXT LIKE '%WITH RECOMPILE%'

Regards,

MC

Oh is it so... Many thanks. Because in some article which I red about CURSOR, it was mentioned as "a temptable will be created in tempdb " , that is...

Hi,

When you keep it as hide, try passing some default value (either use From query or Non-queried option).

Regards,

MC

Hi Pooja,

In that case better don't use the sub report. Modify your sp so that it will return the details of all the employees under that department, then display this...

hi friends, 🙂

I got the solution also...

Inside the sp we need to give SET NOCOUNT ON ,ie

CREARE PROCEDURE SP_NAME

(@INPUT1 INT,

@INPUT2 VARCHAR(30)

)

AS

BEGIN

SET NOCOUNT ON

IF(1=2)

...