Comments by binu.emiliya

binu.emiliya 26-Sep-18 1:37am View

Dear MadMyche,
Is there any way to use this code in a VIEW?

binu.emiliya 25-Sep-18 4:43am View

Ok, Thank you!

binu.emiliya 25-Sep-18 4:27am View

'2014-10-13 00:00:00.000' this is the date format I am using, and I am storing this code in a view so I am using TOP 100 PERCENT in this code. But I am not getting the last month of each semester dates.

Thank you for your time

binu.emiliya 25-Sep-18 3:17am View

Dear Maciej Los,

I am using this code now, but it is not returning last month data, say example Spring 2017 last date is 31-Dec-2107 but the code is getting data up to nov only.

binu.emiliya 19-Sep-18 6:42am View

Thank you Krithiga. This I have already done

binu.emiliya 19-Sep-18 6:42am View

This is also working great.thank you so much for your time

binu.emiliya 19-Sep-18 6:41am View

This is working fine Thank you so much for your help

binu.emiliya 9-Aug-18 3:54am View

Thank you,It is working fine

binu.emiliya 9-Aug-18 3:42am View

Thank You

binu.emiliya 9-Aug-18 3:42am View

Hi Santosh, Thank you so much. I made a mistake in my question.Both are IT i just shortened in the first row and forgot to change in the next one

binu.emiliya 8-Nov-16 5:07am View

So nobody is responded.I got the method,it is column on the report.Select Report properties,Column ,the default value is 1 change to 2,so the data matrix/Tablix will grow to the the next column.But here i am facing another problem , the groups rows are splitting across the columns.Any help for sorting out this issue

binu.emiliya 8-Sep-16 8:50am View

Thanks Maciej,

I used Mica's script and worked ! Thank you very much for your effort

binu.emiliya 8-Sep-16 2:38am View

Perfect! Thanks Mika

binu.emiliya 8-Sep-16 1:44am View

Deleted

This will be the correct result
<pre lang="HTML">
stid Ayear Aterm Award Details
-------------------------------------------------------
43 2014 fall
43 2015 fall HONOR Honor List
43 2015 Spring Good -->need to keep this
43 2016 spring HONOR Honor List
--------------------------------------------------------
</pre>

binu.emiliya 8-Sep-16 1:39am View

Hi Mika,

Thanks .But it exclude all good and nil records
I need to keep one row for each term and year.

binu.emiliya 8-Sep-16 1:33am View

Hi David,Thank you very much.I have to create the schema and sample data to make your work easier :)
This is very close to my result but it excludes rows which have detail as 'good'
For each term ,if i have any honor list i have to exclude 'good' record
For the first one ( Award and Detail as '' ) is another exception which we need to keep as such ( that term for that student is foundation so there is no honor or good)

these are the scenarios

1.award and detail nil or space ( not null) - keep it as same

2.award is nil or space detail is good- if there is other record in this term and year
exclude it else ( if there is no honor list in that term and semester) need to keep that record

for example student 43 for term 2015 Spring there is no honor so i need to keep that record with good as such.
But in Spring 2016 you can see two records one is honor and second is good.In this case i have to keep the honor. I hope my explanation is good

Thanks Again

binu.emiliya 8-Sep-16 1:23am View

Hi Maciej Los,

Thank You.I used Exists but did not get the result i was looking for
In your solution i can see it is excluded 2015 Spring .
If there is no honor and detail is good i need to keep that record
so there will be a record for each term.
Thanks for your support

binu.emiliya 22-Sep-13 3:58am View

Hi Ganesh,

Thanks for your response.Yes i am also looking for any unique ID,But I don't know anything about android development ,I know only VB.net/ASP.net or I can look for JAvascript code also,But the code in your link seems Java..Thanks agian

Comments by binu.emiliya (Top 18 by date)