Search results for query: *

I have a very strange thing occurring on my report. I have a parameter formula that is supposed to allow you to choose what you want to sort by: if {?Sort}='N' then {udDriverDatabase.FullName} else if {?Sort}='D' then {udDriverDatabase.DriverStatus} else if...

I need to create a report that is a cross tab because it will have to automatically expand based on days entered. The columns will be the week ending date. The rows down will be the employees. I need the value under each column to be the max value label. So for example: Employee A Group A = 10...

I have created an income statement of sorts using a cross tab. The user now wants the exact same thing but instead of a value they want each field to be the percentage of revenue. Is there a way to always get the value of a field and ignore the grouping in the Cross Tab? I am using this formula...

I am working on a Chart where the data isn't in an ideal format in the table. There are 13 fields within the table and each represents a column in the chart. My chart setup is as follows: Series - nothing Categories - nothing Values - Sum of Field 1 Sum of Field 2 Sum of Field 3 Sum of Field...

My report was working perfectly until I needed to add in another table. The first table has one record for each phase code per month like below: Mth Phase Amt 5/1/2016 1604. 61,056.60 6/1/2016 1604. 0.00 7/1/2016 1604. 0.00 The table I am trying to add has multiple...

I am running version 14.0.2.364 (2011 I believe). I am struggling trying to add a calculated member to my cross tab. I know I could do a manually crosstab but it would take along time so I was hoping to do it within a crosstab. This is how my crosstab is setup: This is the results: This...

I am struggling coming up with a way to highlight certain cells in a Matrix report. I want to highlight the cell for the corresponding work order if the Date scheduled = the column date. Any ideas? Thanks!

I am creating a file that need to be uploaded to a website and each field needs to be an exact length. For example the last name fields need to be a total of 20 characters. Johnson Anderson Brown Is there a formula that will take however many characters the name field already is and add spaces...

I am looking for information on creating a file for upload to a website. This file needs to have certain position starts and ends for each column. Some of the columns will be blank and others need to be a certain length. Does anyone have any information that would be helpful or know of any...

I have one field that has First Name Middle Initial Last Name all together separated by spaces. However, not every field has a midddle initial. I have tried searching for a formula that will work however I am not able to get exactly what I need. My information is as follows: In the {HRDP.Name}...

I need a formula to say: if the effective date is between day 2 and the last day of the month to put the next months date Not sure how to get a formula to reference days of the month. Thank you!

I am working on a report that has a page header. That has various fields but when I select fields from a certain table it will not display on any page except for the vary last page. Any idea why this would be? Could it be a link issue between tables?

I have a report that has the amount deducted for health insurance in payroll and a subreport with the rates from human resources. Is it possible to highlight the field in the subreport if it doesn't equal the amount in the main report?

I am working on a report that has certain locations for all of our equipment. For example: YARD YARD2 CORP AVA SOLD JUNK X-KM My problem is that I am trying to condition the report to only print some of the locations. I would like to only see the SOLD, UNK, X-KM, JUNK and the blank locations...

I have a report that uses a crosstab. I have a formula that combines the employee number and the employee name. I would like to sort by the employee number but when I combine the number with the name it converts it to a string and it doesn't sort numerically. Any ideas? Name Formula...

I have a report that is sorting by the following formula: If {EMCM.udFleet}='Y' then 'Category: '&{EMCM.Category}&' '&{EMCM.Description} Else "" What I am trying to accomplish is if the Category of Equipment has a Yes checked for fleet then to include the category else print nothing...

I am working on a report for our equipment. The report has the name of the unit and I want to put the rate but I cannot get the rate to work correctly. We have a category rate that defaults for each unit unless it is overridden with a specific rate. This is my formula as of now but it has some...

I know that there are several other thread with suggested formulas but I must be missing a step because it never seems to work correctly. I have tried this formula for the row labels: whileprintingrecords; numbervar d; d:= if d = 200 then 255 else 200; color(200,d,200) and for the inner cells...