Crystal report counting of data

Question

0.00/5 (No votes)

See more:

Good day experts,

here i am again asking for some sugestions regarding to my problem.
i Have a columname shift and checkoutShift on my table.here is my scenario:

shift 1 time between 6am to 2pm
shift 2 time between 2pm to 10pm
shift 3 time between 10pm to 6am

First Transaction checked in on 1st shift for 4hrs
Second Transaction checked in on 1st shift again, for 12hrs

my first transaction check out on the same shift which is 1st shift. upon viewing my report on shift 1 ,i can see the total check in which is 2 and check out which is 1. Now, the second transaction checked out on 2nd shift.upon viewing my report on shift 2, i didnt see the total count for checked out.

i used running total to get the count of data in my table, below are my code on my running total:

CSS

{EndOfDayReport;1.roomtype}='Premium' and
{EndOfDayReport;1.hours}=12 and
{EndOfDayReport;1.checkOutStat}=1

i dont know what type of code here i'm missing..
Thanks for your help experts.

Posted 7-Jul-14 0:09am

Chester Costa

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

elieser0213 · Answer 1 · 2014-07-07T19:45:00

Solution 1

Right Click on the report

then Insert->Summary

Under Summary
Choose the Field to summarize

and under calculate this summary
Choose "Count"

then thats' it. Hope this helps

Posted 7-Jul-14 19:45pm

elieser0213

Chester Costa · Answer 2 · 2014-07-07T20:39:00

thank you for your quick response mr.elieser0213..but my problem is not solve.

i'm using running total to count the total check out.in my running total, i have a formula only to count the specific data like:

count roomtype
formula:

CSS

{EndOfDayReport;1.roomtype}='Premium' and
{EndOfDayReport;1.hours}=12 and
{EndOfDayReport;1.checkOutStat}=1