Search results for query: *

Thanks for the help Skip. Much appreciated.

The table is calculating the average of the elapsed days field.

Thanks Skip. I re-ran the elapsed day figures below and the average should actually be 58.4. The average calculated in the table for assessor A is 63.9. It's close, but not close enough. 55 is the number of assessments for Assessor A. The first 2 figures of the 55 Elapsed Day figures are 199...

The black bar is group header 1. The grey bar is group header 2. The tables are in the Report Header.

Thanks Skip. I have attached a snapshot of page 1. I hope this helps. Please let me know if you need additional info.http://files.engineering.com/getfile.aspx?folder=0f6268b0-4a14-4705-b9af-cb25c2cb24cc&file=Capture.JPG

I have searched the threads for an answer because I know this question has been asked before. I was not able to find what I needed. I'm performing some datediff math in a group header and this works perfectly: ELAPSED DAYS: if isnull({Sheet1_.Next Assessment Date}) then 30 else (DateDiff...

The challenge seems so simple on the surface. I'm sure others have been sucked into this before. Thank you for the reply! I appreciate your help.

Thank for the response BattyJ. I appreciate it. I followed your steps but didn't get my exact desired results. All I get at this point with the new subreport in the header of the main report is a huge list of PR numbers with counts for each group. It's prob my fault for not clearly explaining my...

I'm using product version 11.5 I've read thread after thread about how CR will not calculate a summary of a summary. But I'm still hopeful there is a solution to my problem be it a table, running total, sub report, or something else. This is how the data appears on my report: PR1949 IN19717...

That works beautifully. Thank you so much!

For whatever reason, sometimes HTML is contained in a text field and displayed in my report. I can use the "replace" command when there are only a few characters. But sometimes, there are way too many characters. Here is a sample: <a>good text here and here</span><font-family>more good...

Thanks for the reply. I will try that.

I'm using CR 11.5 I'd like to provide a few summary stats in the report header and I'm having trouble counting records. I have three groups (group1, group2 and group3) and the data. I'm counting the number of records via "insert summary" at the group1 level. That works fine. I'm then...

I was able to get what I wanted with a table: Rows: Parent Records Columns: Tier Values (1, 2, 3..) Summarized Fields: Minimum of Tier Value This lists Parent records with at least one Tier 1 first, Tier 2 second, etc.

Using CR version 11.5 I'm not sure how to proceed but I think I may need to evaluate records using array logic.. and I do not have any experience with arrays yet. Each of my parent records also has one or more child records associated to them.. and children have Tiers (1-8) assigned like this...

I see how bad my original explanation was now... sorry about that. Pater, thanks for getting me back on track. This did it (very simple): if {@Color Blue}=5 then 5 else if {@Color Green}=4 then 4 else if {@Color Yellow}=3 then 3 else if {@Color Red}=2 then 2 else if {@Color White}=1 then...

I think I'm making something harder than it should be... but here goes. I have the following five fields: @White @Red @Yellow @Green @Blue Each field has a formula and the resulting numeric values will be: @White 1 if true 0 if false @Red 2 if true 0 if false @Yellow 3 if true 0 if...

This does help. Now a new question. Is there a limit to the number of sheets (tables)in a given spreadsheet? I've always has success linking several sheets. But now, I have a spreadsheet with 10+ sheets. When I go to create a brand new report (new connection | Excel 8.0), it doesn't show the...

Thanks for checking this. I really appreciate. And, I'll go back to the original version.

...Weeks:= (Truncate ({@Complete DateTime} - dayofWeek({@Complete DateTime}) + 1 - ({@Create DateTime} - dayofWeek({@Create DateTime}) + 1)) /7 ) * 5; Days := DayOfWeek({@Complete DateTime}) - DayOfWeek({@Create DateTime}) + 1 + (if DayOfWeek({@Create DateTime}) = 1 then -1 else 0) + (if...