Search results for query: *

I am working on getting a sub-report to display records related to the dates in the main report parameters, but it's complicated by the detail table in the sub-report. The table is organized in ascending order by DateTime and its only useful key is the MemberID. The detail table tracks...

Hello everyone! I created a formula to evaluate a string field. The * can be any number of characters including (),A-Z,., or other numbers. My current formula is returning a 0 for all records, even though there are some that meet the criteria. if {field1.flagcheck} in ["940.01*", "940.02*"...

[highlight #FCE94F]This worked! Thank you all so much for your help.[/highlight] Here's how I set it up. I created a total of 8 Running Total fields Each (1-8) was as follows: I named the field SummLevel1 Field to Summarize: Level (in this case I used the numeric field) Summary: Count...

The 3 are: MSORow: Running total, tboff.class, type of summary is count, evaluate for each record on change of field tbcl.id fxMSO2: formula, minimum({tboff.level},{tbcl.id}) fxMSODesc: formula, if {#MSORow} = 1 then 1 else 0

Unfortunately, I have to keep it in Crystal because this is eventually will get embedded into another report as a subreport. So, back to the grind. So, here is where I am stuck: set up each running total to only evaluate on MSO Row = 1 (use the actual field name) and have a second filter be for...

Hi Kray4660, It appears I am having a hard time with this because if I were doing this in SQL this would essentially query this recordset and select all records where MSORow =1 by Class. I will admit I know my way around SQL better than Crystal. Now, having tried this recommendation, I believe I...

Hi kray4660, Thanks for the clarifying question. The goal is to add the record in each group that is marked as MSO Row = 1. MSORow, fxMSO2, and MSODesc are all formulas I created to accomplish this task but I seem to be getting stuck at only summing the row marked as MSO=1 from each group...

Hi All, I am working in Crystal Reports and am having a hard time getting the sum of a specific record in each group. I am basically getting the min level within each group and having that counted towards the grand total. Basically only counting the most important record and summing that for the...