Recent content by NickieP

Try average as your summary not sum

Group on Statute code suppress rows where case <> group1 If you want just a list, rather than a report , Hide the group names but show the Statute code on the detail line so : Statute Code 28-701A case1 Statute Code 28-701A case3 This works if each record has both a statute code and a case...

Then I'd double check the source data. Check there's not a space before the "J" in January.

Hi, If your data starts at the end of year 1 into year 2, could your groups be Year & month rather than Months (1 -12)? This would make Jan(month 1 year 1) appear before Dec(month 12 year 2), where you just want Jan-Dec - regardless of year. Instead of group by month, group by month number...

Hi, I presume whole data set is a billing batch so : If G1 is Customer, G2 is Invoice(or credit note) your footer should be in G2 something like :[field.docname] [field.docno] page n/n - if you have credit notes, this work as Credit Notes will say "Credit Note", rather than hardcoding the...

Create a formula field @Server&App {serverfield}&" "& if isnull{applicationfield}then "" else {applicationfield} Group on @Server&App (suppress detail) to get a list of all the servers and the applications, inc server if no application There's more than one way but if you just want a big list...

Create 2 formula fields: @SwitchPageHeaderOn WhilePrintingRecords; booleanVar ShowPageHeader := Yes place it in the group2 header(make font white on a white background to hide it) @SwitchPageHeaderOff WhilePrintingRecords; booleanVar ShowPageHeader := No place it in the group1 footer in...

Use a spreadsheet or Access table of all dates to link to the existing data. Link New.Date field from this new date table to Existing.Date field (left outer joing from new to existing field) Use the date filter on the new.date i/o existing date Then you will have all dates, with null in dates...

At detail level, try a formula field @timeinroom where it clears up all the instances of bad data here first at line level, using IF and case statements etc. You should then be able to refer to this new field and use PREVIOUS in a 2nd formula field or use running total functions on the new...

I would have 2 separate formula fields, one for diagnosis date, one for location. Then concatenate these in a 3rd field @Diagdate&"-"&@location group on these using specified groups so many options will be grouped together if required, or cross tab the results. Great if few locations and few...

oops, sorry forgot you were doing running totals. you can have a formula field that only counts the the first instance in the group @newfield if group1,fieldemployeenumber = previous(group1,fieldemployeenumber) then 0 else fieldsalary then sum or count the @newfield If the data...

Section Expert;details add a formula to suppress current row if a record for the same thing already exists (you must already have something in common to know you don't need both records). E.g. if an employee is in two teams, but you only wanted to show one team per employee without grouping the...

Try database, set datasource location in the bottom pane, find the new connection(ODBC etc)and the DB With the table or whole DB highlighted in the top pane(current data) highlight the corresponding table or DB in the bottom pane(replace with) -if they agree(such as if pointing a test DB...

Use Microsoft XPS Document Writer, set up a new paper type of large dims, call it Crystal. Make your reports use that paper size on that printer. It doesn't default to the new size, (unless they fixed the bug), but any reports you save that paper size on will keep it.

Select the parameter and choose edit. Check the list of values has the radio button for "dynamic" checked and is pointing to the field with the options you wich to choose from e.g. country, city,person etc... CR may have defaulted the parameter to static and so is expecting you to type something...