467,923 Members | 1,258 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

Problem in crystal reports

hi,

iam working with crystal reports.in my database table i have a
columns like dtmtime,parameter_index


dtmtime parameter_index status

1/2/2006 11 SVC
4/2/2006 12 COS
6/2/2006 11 SVC
7/2/2006 11 UNK
12/2/2006 12 SVC


in my report grouping field is parameter_index

i want to display startime,endtime for each parameter_index

here starttime for parameter_index 11 is 1/2/2006
End time ,, 11 is 7/2/2006

Startime for ,, 12 is 4/2/2006
endtime for ,, 12 is 12/2/2006


for this iam using formula fields
minimum(dtmtime),maximum(dtmtime)

but they give startdate for all param index is 1/2/2006
and end date is 12/2/2006

how to write formula with condition.

and my another problem is i have a subreport in this main report

in subreport i have to display Status descriptions
and toal hours

here total hours calculation is find the days between startdate and enddate of
a parameter_index and calucalte total hours in those days for each status.


for this purpose i want to pass startdate,enddate from mainreport to subreport

so iam using change report links and startime,endtime fileds linking to main report to subreport.

here the problem is status descriptions are not displayed.why because when iam linking with mainreport to subreport it is displying
only report fields.



please any one help me with this problems.

iam struggle with these problems from 3 days.


pls pls pls any one give the solution for this
Feb 10 '09 #1
  • viewed: 798
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Stephan | last post: by
1 post views Thread by Mithun Verma | last post: by
3 posts views Thread by Milan Todorovic | last post: by
3 posts views Thread by Miro | last post: by
1 post views Thread by =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.