Search results for query: *

If you're referring to the Record Sort Expert, I have already done that. The fields are showing up properly in the details, but not in the actual report.

How would I sort the data inside the groups then?

I have a report I'm working on rebuilding in a new format that has two groups, which are then additionally sorted in the Record Sort Expert by date. The report calls for the previous month's data to be compared to the current month's, which had been done with the previous function in the former...

I've been bashing my head against this one for a while, but can't seem to figure out why this one doesn't quite work as expected. The function would be to take an imported set of data in a table (Sheet1) that has been cleaned for erroneous data, check it against the existing data and import any...

Taking this one as an example: if {table1.p2} = true then (if {table2.data_through_date} in {table1.p2_start} to {table1.p2_end} then {table2.data_through_date} >= {table1.p2_start} else {@rollingyear}) else What I'm trying to do is that if the data being brought in...

Working on a record selection formula for creating a report with multiple charts, sorted by which "goal" they pertain to. A few of these charts need to display a certain date range stored in the database, the rest need to display a rolling year. The date range is essentially a financial year for...

Just got it working! Using the same formula field, Except for the "Use a Formula:" field, DateDiff("yyyy",{table.data_collected_month},(Date (Maximum ({table.data_collected_month}, {table.goal_id})))) < 1 A little bit... bulky, but working. Got the idea from playing around with that maximum...

Take your time, I appreciate the help!

If I'm following idea behind the formula correctly, it seems like it should be fine for what I would need, but it looks like it's adding in the final month twice. For example, the YTD should be 11, with the last month being 2, and it's coming out as 13.

Yes, the goals are fields in one table of the database. Exactly. Sorry If I was a bit wordy getting to the point.

I'm not really sure what you mean here. The way the report is currently grouped is so that each goal has a separate section of the report with a chart and other information displaying the past 12 months. Also I'm trying to avoid selecting the year entirely, as it would have to be selected...

Hi all, Little bit new to Crystal (using XI), so bear with me. I have a Access database that includes two different dates for every data piece. Each one has a date for the month the data is collected, and the month that the data is reported (eg. a month could be collected for November, but not...