Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL-Server-2008 , +
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
thanks in advance
 
how to display daterange in crosstab ?[^]
Posted 26-Feb-13 2:07am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Member 9846414 at 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: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi,
 
Check the following link
 
Crosstab Date Range in Reports[^]
 
Access Basics
By Crystal
[^]
 
Regards,
GVPrabu
  Permalink  
Comments
Member 9846414 at 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 at 28-Feb-13 3:46am
   
Hi,
 
Where you used this formula..? in side a condition or Direct Formaula
Member 9846414 at 13-Mar-13 2:28am
   
in side a condition .can u tell me how to use this formula step by step

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,327
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,920


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100