12,062,966 members (36,310 online)
Rate this:
See more: , +
hi i am new to crystal report plz help me by seeing below link
Actully below link said that was some what usefull to but my table not like that my table is seen below :
id score marks date
1 23 33 1-6-2012
2 43 54 1-8-2013
3 54 76 7-6-2014
1 4 5 4-3-2013
1 3 6 8-5-2014..so on
i report should like this
----------------------------------------
id :1
-------------------------------------------

months 2012-2013 2013-2014 2014-2015 .. so on
june-1 23 33
march-4 4 5
Agt-8 3 6

note: it starts from june to july(means ex:june2012 to july2013)based on months score and marks should be move plz help by see below plz modiffy that query .here i am usoing crosstab bec
i want to dispaly daterange horizontally

how to display daterange in crosstab ?[^]
Posted 26-Feb-13 2:07am

Rate this:

## Solution 1

Member 9846414 28-Feb-13 1:44am

thank u verymuch i am using formulka feild can u tell error for this boolean variable required here lke that error is comming i was written in formula like this
toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) help me by sloving this error
Rate this:

## Solution 2

Hi,

Crosstab Date Range in Reports[^]

Access Basics
By Crystal
[^]

Regards,
GVPrabu
Member 9846414 28-Feb-13 1:45am

thank u verymuch i am using formulka feild can u tell error for this boolean variable required here lke that error is comming i was written in formula like this toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) help me by sloving this error
gvprabu 28-Feb-13 3:46am

Hi,

Where you used this formula..? in side a condition or Direct Formaula
Member 9846414 13-Mar-13 2:28am

in side a condition .can u tell me how to use this formula step by step

Top Experts
Last 24hrsThis month
 Dave Kreskowiak 337 CHill60 300 d@nish 175 Chris Maunder 135 Garth J Lancaster 120
 Dave Kreskowiak 1,827 Richard MacCutchan 1,225 d@nish 980 OriginalGriff 800 Sergey Alexandrovich Kryukov 733