Search results for query: *

Yes I just need then to update the links in the master template workbook from the closed 3 other worksheets or workbooks. I know can do it by using edit > link > update source but I need to make it simple for other people to use with less computer ablities. Since the 3 linked report are...

Skip They are all linked to the master workbook template by special paste links. Thanks

I have a master work book that feed information to my master template with all my information being linked by 3 daily reports that I run. How can I create a button to link my three closed worksheets to my open workbook without having to open all four workbooks. Masterbook POS ZCSI 2067500...

I tried using IsNull ({Department.Name}) in place of the original IF IsNull ({Department.Name}) OR Length({Department.Name}) = 0 THEN "<Unassigned>*" ELSE {Department.Name} But when I run the report it now replace the DEPARTMENT NAMES with the Word "FALSE" for all the DEPARTMENTS.

I am working with the following tables Batch [Transactions] TransactionEntry Item Department I want the report to list all the departments in the database. I need the reported departments list to show the departments with $0.00 in sales as wells the departments with actual values greater then...

I basically need to list all 51 departments in our store. Right now only the departments with sales greater then $0.00 are being list in report. I need the report to list all 51 departments including departments that have $0.00 in sales. Items that are not linked to a Departments need totals to...

I inserted some crosstabs in the date closed group footer and got the results that I needed. Thanks for your help. I have a few other things that I would like to do with this report. Should I start an new thread? Also is there not a file posting area on this site where one can actual look at...

The summary results at the batch group level when I inserted summaries on the detail fields basically adds the totals as one Grand total for (Count, Open, Shift, Close and Over / Short) and does not give me the combine total for the individual Tender Types. I Basicly want to get the...

Did not get results that I was hoping to get. Example of the detail section of report below. Basically I need to get the details of all the Tender Types Count Open Close Shift Close OverShort for all the batches that closed {@DateClosed} summarized in my footer With all the other summarized...

I'm using Crystal 8.5 I need to summarizes the Detail section of my report in my Group Footer for all the Batches Tenders that closes. Summary data for batch(es) that closed on: @DateClosed I have a DEF File as Follows and I have given report breakdown below. I have a little knowledge if...

Hi You really helped me out before with a time clock report just over a year ago and it working great. I was hoping you could help me out again with my cash register analysis report. Is there a way to attach a pdf file? Thanks Ralph

Hi LB I made these changes before I got your response and it seems to be working ok. Please just check these out and tell if they seem ok. I changed {@regular} to: local numbervar x := If Sum ({@Hours}, {@WeekStartDate})<=44 then Sum ({@Hours}, {@WeekStartDate})-{@holidayhrs} else 44 -...

Hi LB All is well, but for some reason the holiday hours are adding together with overtime hours. Change {@overtime} to: local numbervar x := If Sum ({@Hours}, {@WeekStartDate}) + Sum({@holidayhrs},{@WeekStartDate}) > 44 then Sum ({@Hours}, {@WeekStartDate}) +...

I LB What do you mean by for rounding, just plug each summary formula into the rounding formula instead of {@hours}. Do you mean this or to replace {@hours} with {@regular) because it tried both ways a got an error. //{@regular) If Sum ({@Hours}, {@WeekStartDate}, "daily")<=44 then Sum...

I should have explained myself a bit better for these two last items. The formula for holidays does work but I just need it to pull the total hours worked for the date of the holiday And summarized like (Sum of HolidayHours) Example 4th of July Holiday and 15th of July Holiday Sun 7/4 Mon...

***I got it to work.*** I just have a couple other questions and should be set to go. My report looks great now thanks to you. This was the magic formula. //{@regular} If Sum ({@Hours}, {@WeekStartDate}, "daily")<=44 then Sum ({@Hours}, {@WeekStartDate}, "daily") else 44 I had to get rid of...

*****THIS COULD BE THE PROBLEM***** I thought I had mentioned this earlier but I did not type into message. For your suggestion of //{@regular} to be placed in the GH#2 header or footer: if sum({table.hours},{table.date},"weekly") <= 44 then {table.hours} else 44 I used //If Sum ({@Hours})...

These are the latest Results. ____________________________________________________________ Report Header ____________________________________________________________ Page Header ____________________________________________________________ Page Header A Bi-Weekly Timecard Report As of...

Thanks again lbass. I did get the date labels to repeat for each week, moved them from the GH#1 to GH#2. I entered the formulas and did not get any errors but it is not reporting correctly. I do not see my error(s). I was hoping that maybe I could email you a sample of what I could and you...

This is the report DEF FILE ; ; Timecard Report ; Filename = BI-WEEKLY TIMECARD.RPT Description = Timecard Report HelpContextID = 0 GroupCount = 2 TableCount = 2 DefaultSelectionFormula = {@WeekStartDate} in Last4WeeksToSun DefaultSelectionDescription = Week Starting Date in Last Four...