group header format displaying

[aal_fareed]

group header.png
hello all , i really need help displaying date field in my grid as " Month " only and place it as group header .
there is option to display the requierd format in the grid fields , but i cannot find how i can display the field as group header
the way i can create group header for my grid is through grid properties ' define group breaks '
so my question is , i have date field and i want only to display the month only ( group header ) ,

could be really silly question but can any please help me sorting this ?

thanks all

[aal_fareed]

Re: group header format displaying

headergroup.png

just wants to make it easier for ppl who are facing same issue .
so formating the date is easy after akk we have to define it in group header properties . by typing the following codes all you have to do is change ur field name and it will work :

<tr>
<td class="[class.gridDataHeader]" colspan="{systemcolumnCount}">&nbsp;</td>
<td class="[class.gridDataHeader]" colspan="100" >
<div>
<script type="text/javascript">
var d=new Date("{your_Field_Name_Here}") \\\\ this for year
var monthname=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")\\\\ for month
document.write(monthname[d.getMonth()] + " ") \\\\ this for month


document.write(d.getFullYear())
</script>
</div>
:

in my case i needed to get the year of my date so check attachment to see where to place the code

Ahmed sh

[MarionT]

Re: group header format displaying

Add the column to your table that is:

select month(MyDate) will give you a digit (let me know if you want the name)

or, you can Insert Expression in A5's SQL Genie as:
Character Function: MonthName(MyDate)
will give you the name of the month

does that help?

(this is based on MSSQL, I don't know for dbf or MySQL)

[MarionT]

Re: group header format displaying

to do the year:

year(mydate)

[aal_fareed]

Re: group header format displaying

to do the year:
am gonna try that and let you know thanks for your quick replay , although its working with me now by above code .. but
u just make it easier for me i will try it now .
thank you

[aal_fareed]

Re: group header format displaying

ok that function up is not working not sure why ... but using the prevoius script code is doing the job .
thank you for your kind help ...

_____________________________________________________________________________________________________________________
this how am doing it


formating the date is easy after all we have to do is define it in group header properties . by typing the following codes all you have to do is change(birthday) to ur field name and it will work :

<tr>
<td class="[class.gridDataHeader]" colspan="{systemcolumnCount}">&nbsp;</td>
<td class="[class.gridDataHeader]" colspan="100" >
<div>
<script type="text/javascript">
var d=new Date("{your_Field_Name_Here}") \\\\ this for year
var monthname=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")\\\\ for month
document.write(monthname[d.getMonth()] + " ") \\\\ this for month


document.write(d.getFullYear())
</script>
</div>
:

in my case i needed to get the year of my date so check attachment to see where to place the code

Ahmed sh

[aal_fareed]

Re: group header format displaying

groupby date.jpg
result.jpg
cus i really spent time in this i want to make it easier for next people who wants to get this done .
check attachment .. its easy and working like a charm !!
just all you have to know is
birthdate = your field name

second picture is result of the first one which is
displaying your rows orderd by month and displaying year only out of your field date as group .


code for copy paste to ur grid :


----------------------------------------------------------
<tr>
<td class="[class.gridDataHeader]" colspan="{systemcolumnCount}">&nbsp;</td>
<td class="[class.gridDataHeader]" colspan="100" >
<tr>
<td class="[class.gridDataHeader]" colspan="{systemcolumnCount}">&nbsp;</td>
<td class="[class.gridDataHeader]" colspan="100" >
<div>
<script type="text/javascript">
var d=new Date("{Birthdate}")
document.write(d.getFullYear("{Birthdate}"))
</script>
</div>
</td>
</tr>
---------------------------------------------------------------------------------------------

and function used in order is
month( ur field name ) << ordering your data by month of field date
year ( ur field name ) << ordering your data by year of field date

good luck all