Comments by Dhivya.J - CodeProject

Dhivya.J 13-Nov-13 6:45am View

I am trying to change the schema of "dbo.MytableName" to "xxx.MytableName".

Dhivya.J 4-Nov-13 3:38am View

I have nearly 600 tables in one DB and my SQL contains 3 databases like this. Is it possible to use trigger in this case?

Dhivya.J 4-Nov-13 3:37am View

Thank you. Is the trigger you mentioned are table and record specific?

Dhivya.J 18-Sep-13 7:29am View

Hi Mubin.

I have done this already.

Thank u

Dhivya.J 18-Sep-13 7:15am View

what kind of information you need?

Dhivya.J 17-Aug-13 1:18am View

Deleted

Triggers are not used in the stored procedure

Dhivya.J 6-Jun-13 3:01am View

Yes. :)

Dhivya.J 5-Jun-13 3:08am View

Thank you.

Dhivya.J 9-May-13 2:25am View

Thank you.

Dhivya.J 9-May-13 1:36am View

Thank you. I have to convert whole column.

Dhivya.J 8-May-13 23:24pm View

Thank you

Dhivya.J 8-May-13 9:47am View

Deleted

Thank you. Can u give a simple example?

Dhivya.J 16-Apr-13 2:24am View

Hi Los. I am not torturing myself and right now I dont have rights to do this in SQL. That is why i wanna handle it in report.

Dhivya.J 15-Apr-13 23:30pm View

Hi. I know this is possible in SQL and i want this to be handled in my report only.

Dhivya.J 2-Apr-13 5:12am View

Thank you. But my report is exported to numbers(exactly saying float values), not in # symbol's. My problem is, I want to "manually convert it into number" to sum the whole column.

Dhivya.J 29-Mar-13 0:58am View

Thank you:)

Dhivya.J 27-Feb-13 0:52am View

My report contains float values. For me the below expression worked.

=IIF( (B=0 OR A=0),0, ( ( A/IIF(B=0,1,B) )-1 ) ).

Dhivya.J 26-Feb-13 7:47am View

Thank you for answering. This only handles NAN, not infinity and #Error. I need to handle all these three(NAN,Infinity,#ERROR) in this expressions.

Dhivya.J 27-Jan-13 23:33pm View

Hi. Thank you.

Dhivya.J 2-Jan-13 5:28am View

Yes. The old copy is working fine in client machine. After I modified(not in design part) and renamed it, the new one is creating this problem. The IE version is IE7 and the versions of the client and server are same and the issue is also the same in both.

Dhivya.J 2-Jan-13 2:55am View

Hi. Can you pls tell me what do you mean by render?

Dhivya.J 2-Jan-13 2:54am View

I am running the report directly from the report server using IE7.

Dhivya.J 2-Jan-13 1:49am View

Hi.. Do you have any suggestions??

Dhivya.J 1-Jan-13 23:24pm View

Thamk you.

Dhivya.J 1-Jan-13 22:50pm View

Hi. I am new to SSRS. Could you please tel me how to generate a button at runtime?

Dhivya.J 1-Jan-13 22:45pm View

"You can use any comparer to see the difference of the previous file and the current file."
Hi. As you said how can I compare the previous with the current file?? can you please explain..

Dhivya.J 31-Dec-12 7:08am View

Thank you. I am working on a client machine. Other than IE7 none of the browsers are installed in it. This report is viewed as I expected in server, from where i deployed it and viewed as I expected when exported in excel too. The problem is while displaying it in IE7. I don't know why?? Any suggestions??

Dhivya.J 31-Dec-12 1:12am View

As you said the reference too needs an update, shall i know where it will refer?? Thank you.

Dhivya.J 26-Dec-12 9:15am View

Hi
Why dont you post this as a solution. Thank you.

Dhivya.J 26-Dec-12 6:49am View

Thank you. But my expression is like this

IF(Parameter=2, I hav to check both conditions like ((a/b)-1)>3, "red" and ((a/b)-1)>(-3),"green")

or if (parameter=3, if((a/b)-1)>0, "red" and ((a/b)-1)<0, "green" )

Pls suggest...

Dhivya.J 26-Dec-12 5:03am View

Hi I want to include this expression in another iif condition.. so i cant able to use switch for this. thank you. Any other suggessions??

Dhivya.J 13-Dec-12 6:24am View

Thank you

Dhivya.J 28-Nov-12 7:02am View

If I refersh fields simply without executing the query, i m getting my dataset with empty fields.. Pls help.

Dhivya.J 28-Nov-12 6:59am View

I have tried what you said but still i m facing the issue... Any more ideas? Pls help..

Dhivya.J 27-Nov-12 0:08am View

Thank u for your reply. Ya I have used the fields exactly as you said.. But still I m getting those errors which i mentioned earlier.. thats wer my problem is... Pls help..

Comments by Dhivya.J (Top 35 by date)