Search results for query: *

I have a cross-tab report that has 2 rows. The first row is the source "current" row and the second is the "history" row. There are several columns one for each month for the next 18 months. I would like to be able to in place on the column total for each month column to subtract the current row...

I have a standard report that I would like to update but am struggling getting it to work without errors. I need to add this query: SELECT FilteredFieldLogEmployee.Field_Training_Custom ,FilteredFieldLogEmployee.Injured_Today_Custom ,FilteredFieldLogEmployee.Holiday_Custom...

I need to figure out a way to get a sum of just the yes values. It puts a yes if the employee should get Per Diem that day and a no if they do not. I have done this over and over in Crystal reports and in Crystal I would just create a formula to put a 1 for yes and a 0 for no. Sum it and be...

I am creating a report that will count how many forms were submitted on each day. I need to still have a column in my report for that day even if no form was submitted on that day. I can't figure out how to do this. Currently it omits every date that does not have any forms submitted.

I would like to take data that looks like: 1100.1 (phase code) 154691 (this is a list of units charged to that phase code for the month) 154691 154691 15853 15853 15853 15853 1720.14 17030 17030 17030 17040 17040 171003 171003 I would like to change...

I have a report that is just how I want it except for the total row. I am very familiar with Crystal Reports and in Crystal I would use the running value function but in Report Builder if I try runningvalue I just get an aggregate error no matter what I try. Help! I need this report ASAP!

I would like to create change the format of the following: Group Header 4 = Phase Code - 1100.1 Group Header 5 = Equipment - 18270 Group Header 5 = Equipment - 18500 Group Header 5 = Equipment - 18600 Group Header 5 = Equipment - 19000 Group Header 5 = Equipment - 19001 to Group Header 4 =...

Is there a simple way to change all negative numbers in a report to red? I know that I can write a formula on the formatting of each field but I have a report with 50 plus formulas. I am really hoping there is an easier way then writing this over and over changing the field: if Sum...

I am working on a report that has hundreds of lines of data. I would like to return only the rows where a field (complex if then else formula) is one the highest 10 rows. Is this possible? I am kind of hoping I can do it through a suppression formula.

I am working on a report and I have everything I need except for one thing. I have a crosstab in my report that is extremely simple (here is a sample): Description Amt General 1000 Indirects 5000 Civil 100 Buildings 300 Electrical 2000 Tools 150 Wind...

I need a to do a date difference that goes something like this but I don't know how to get the prior detail row information: if {APUR.ApprovalSeq}=Minimum ({APUR.ApprovalSeq}) then dateDiff("d", {APUR.DateAssigned},{APUR.DateApproved}) else if {APUR.ApprovalSeq}<>Minimum ({APUR.ApprovalSeq})...

I am using the following formula: dateDiff("d", {APTH.udReceivedDate},Minimum ({APUR.DateAssigned}, {@APRef})) Is there a way to get it to display something even if one of the values is blank or null? I know that note every invoice has a received date but I still want it to at least display 0...

I am wondering if there is a like or similar formula that I can use for this. I would like to compare 2 different strings. One of the strings comes out as a default format from our system. It looks like this: 830. (there are 2 spaces before the 8) This field is something that is entered...

Why can't I use this formula as a group? if Sum ({@First Year}, {@SortEmployee})>0 and Sum ({@First Year}, {@SortEmployee})<=60000 then 'Under $60,000' else if Sum ({@First Year}, {@SortEmployee})>60001 and Sum ({@First Year}, {@SortEmployee})<=114999 then '$60,001 to $114,999' else if Sum...

I want to be able to run a report without having to enter a beginning date. I would like to enter the ending date and create a formula for ending date minus 6 weeks. Is this possible?

Is there a way to link 2 DateTime values in Crystal without looking at the time value? Example: Table 1: 7/8/2013 7:00 am Table 2: 7/8/2013 12:00 am I would like the link to only look at the date. Thanks!

I need help with a formula to count the number of days worked over 12 hours in a week. This is what I am looking to create: S M T W T F S John Doe Detail Row 2 3 4 6 9 4 2 Detail Row...

I have a report that is working perfectly and looks great. However, the person who requested the report would like it to be exportable. The problem I am having is there are 5 subreports that make up 5 different columns. When I export the report no matter what options I use the subreports go down...

I have a report that is working perfectly and looks great. However, the person who requested the report would like it to be exportable. The problem I am having is there are 5 subreports that make up 5 different columns. When I export the report no matter what options I use the subreports go down...

I keep getting a division by zero error... if Sum ({JCCD.ActualHours}, {@PhasePart1})= 0 then 0 else if (Sum ({JCCD.ActualHours}, {@PhasePart1})+{@ToDate+-SubPhasePrint} = 0) then 99999 else (Sum ({JCCD.ActualHours}, {@PhasePart1})/(Sum ({JCCD.ActualHours}...