Search results for query: *

I have a report that is first grouped by type (i.e. speaker, client, etc). Once that grouping is performed, the end user wants the report to sort by email if the type is a client or to sort by affiliation if the person is a speaker. I cannot figure out a way to force the sort by a non-grouped...

I have a report that's main purpose is to show events with a spend >$200k OR attendance over 60 ppl. The attendance portion is no problem, but the spend is stored in a different table in multiple rows per event so I need to sum it first. I've tried a simple summary field, displaying in the event...

I have a report with two groups and a details section. The first group is company name and the second is event type. The details section shows fields related to the event. I have done different scenarios with the keep together function on both the group and the sections. Toggling each on...

I have a report with three subreports. In the third subreport, I am using a variable from the second subreport named "AverageCostPP," placed suppressed in the report footer of third subreport. I need this AverageCostPP field to multiply with a running total on a count of attendees with two...

CR v10 I have a subreport in the report footer of the main report. I have the details section of the subreport hidden (drill down ok) bc I need the user to be able to drill down. When I click on the header of the subreport while in the main report, it just shows the same header and...

I have a report with details a, b, c, and d sections to allow fields to grow and not run into each other. We use our reports in our main database and also display on the web for clients. In the database and in my developer view, the fields do not overlap on each other at all, regardless of the...

I have the following formula for calculating the difference between two dates. I need to run a calculation once I get the correct value. DateDiff("d",{Meeting.TravelStartDate},{Meeting.TravelEndDate}) The date set for this particular report is 4/29/12 to 5/4/12. It spans two months and a...

I have a date field pulling from parameters, showing the date as: May 5 - May 6, 2011 I want to remove the month from the second field, if it matches the month of the first field. I have tried something along the lines of if (month {enddate})<>(month{startdate}) then '', but I get errors...

I have a shared currency variable that I'm using in my report. It returns the correct value, along with the $ sign. However, it will not let me format the field for a fixed symbol. I can't figure out why! Any ideas? crystal reports v10

I have a field (table.budget) that I am showing a sum of in the group #1 footer and displaying the top 10 records only. I summed the same field for the report footer and it carries the top 10 sorting properties with it. The problem is, it's showing the total for all records, not just those who...