Search results for query: *

Well holy cow, Charliy, that worked perfectly. I must have been making it harder than it seemed. Thanks!

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...

Thanks again

Sorry, thought I was done, but I'm not. When I put the name in the Name group header, I hide it (dd ok). When I run the main report, it still gives me no space to double click for drill down. What basic am I missing here?

Yep, one ID. The main report has a parameter pulling out the one ID the user wants to see. Okay, if I have to have a dbl drill down, I'll do it. Appreciate your help.

The two clicks will be a problem for the picky user in this instance, so I need to avoid, IF possible. I have the sub grouped on person and the name in the details section, on hide (dd ok). When it's like this, there is no available space to double click on to drill down. I've tried removing...

Thanks, lbass. The sub is actually grouped by person already. I have this set up just like any other report where I want drill down available, but no dice. I removed the ondemand part of the sub, bc I think that's very confusing for the user. So I have data in the main report and the sub in...

Nevermind, I see that it's a caption so I just entered some text to display. The problem with that is that it then suppresses the total that I want displayed with the main data report. The drill down is just fluff that the end user wants to be able to click on.

Thanks. When I do that, choosing either the ID or parameter from the main report as the field in the ONdemand SR caption, I get the "formula result must be a string" error.

Not sure how I would do that? It's running on a different set of criteria. Overall, not familiar with on-demand subs.

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 tried that but then any date set that doesn't hit that month switch is over by one.

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...

Thank you both for your help. BrianGriffin, I think using a variable was too complicated for me. I was unable to make it work. LBass, you were right. I was trying to use the format text conditional area to make this happen. As soon as I made it a formula instead, I got the results I...

It's a DateTime field and the datasource is SQL. The formula returns a number like 5.00. When I put the second formula in the report, it returns 05/05/2011. Thanks!

Ugh, I'm sorry, Brian. I made a mistake in the original post. The dates I'm formatting are just regular date fields, not parameters. My parameter for this report is an eventID. Sorry for the confusion. In the event that your code would still work, I tried it, replacing it like below and I...