Click here to Skip to main content
15,880,392 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dears,
I have one small dataset table contains 4 columns: ID, loandate, amount, age. these columns are selected from two big joined tables.

now from this small dataset table I want to select loans from this time range ex. 2/2/2012 (startdate) to 2/2/2014 (enddate) and at the same time I want to select the loan before the start date(2/2/2012).
the output should be placed in a crystal report with C# and visual studio 2010.

so can any one help please.
Posted

 
Share this answer
 
hi,

I already did successfully get data between two dates. but my problem is how to get data also for time before startdate in the same record as I get data between two dates. example:
----------------------------------------------------------------------------------------
| time before start date 2/2/2012----------|| time between 2/2/2012 & 2/2/2014
|--------------------------------------------------------------------------------
Age | no. of loans before start date | amount || no. of loans in between | amount
--------------------------------------------------------------------------------------
18-25 |.......................................|.........||..........................|
25-30 |........................................|.........||..........................|
30-35 | | || |
35-40 | | || |
40-45 | | || |


Can I do such table from that dataset table consist of 4 columns as, loanid,age,loandate,amout using crystal report?

I appreciate your help.

sorry I tried make demo table but the editor is overlap my text draw
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900