Search results for query: *

This worked to get my total correct but I struggling getting the sign to reverse correctly. I know I can simply go into the format number option and check the reverse sign for display. However, this then reverses the sign in my current row as well so I end up getting one negative and one postive...

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...

...To the standard query. When I do it doesn't add anything to the report fields. Here is the query: /* -- diagnostics declare @Foreman UNIQUEIDENTIFIER --NOTE:Diagnostic declare @BusinessUnit nvarchar(99)--NOTE:Diagnostic declare @EmployeeREF UNIQUEIDENTIFIER declare @AccountType...

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.

THANK YOU SO MUCH!!!!!!!! You seriously made my week! I have been working on this part of the report forever and have been stuck! Thank you! Thank you!!

I tried the following: whileprintingrecords; global stringvar sRemarks:=sRemarks & if next({EMRD.JCPhase})={EMRD.JCPhase} or previous({EMRD.JCPhase})={EMRD.JCPhase} then if InStr(sRemarks, "|" + {EMRD.Equipment} + "|") <= 0 then sRemarks := sRemarks + "|" + {EMRD.Equipment} + "|" else...

I have previously tried the following and got close but still have the repeating issue: Formula 1 (located in detail section but suppressed): whileprintingrecords; global stringvar sRemarks:=sRemarks & if next({EMRD.JCPhase})={EMRD.JCPhase} or previous({EMRD.JCPhase})={EMRD.JCPhase} then...

Hilfy - That is a good idea but your example would definitely happen in this case. SkipVought - I don't understand exactly what you want me to do. Could you be a little more descriptive?

I don't know how I would do that because I need to be able to run the report for a certain time frame. For example if I run it for August I want to know what units have hit that particular phase code in a list view. Then the following pages have all the data for each entry. Since my report is...

Not sure what you mean by generating a list of unique values?

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 was able to get this to work using the following but there is still one issue: Formula 1 (located in detail section but suppressed): whileprintingrecords; global stringvar sRemarks:=sRemarks & if next({EMRD.JCPhase})={EMRD.JCPhase} or previous({EMRD.JCPhase})={EMRD.JCPhase} then...

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 =...

This worked perfect! Thank you!

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...

Is there a way to do this without having the possibility of crossing groups?