Search results for query: *

I don't think there's a way to do this. You can make subreports as small as possible, then select the "overlay next section" property, but if your group contains hundreds of records, you'll still get a block of empty space. If no one can come up with a workaround is there any chance...

tincan56, I hope my last reply will help you. Unfortunately (/fortunately) I won't be around to check for replies as I am leaving for Las Vegas for the weekend in a few hours. Best of luck! Robert

Hmm. I got a little confused myself so I carefully re-read everything you've written, and I think I understand. Please correct me if I'm mistaken. You want to FILTER OUT any record where there is a one WORKING day difference between the Settle date and Maturity date. What happens if the...

This is a little hard to answer without knowing what you are specifically trying to do, because the topic is so broad. The different date functions available in Crystal are visible in the formula editor. Just open the Date/Time, Date Ranges, and Type Conversion folders in the Functions tree...

I forgot to add the semicolon after the line below. // Get the total number of days__________________ TotalDays := datediff ("d", {?FirstDate}, {?SecondDate});

I don't have time to figure out a separate formula, so I'll give you a quick and dirty method that will basically just invert the other formula. Assuming: ?FirstDate = Start date ?SecondDate = End Date NumberVar Idx := 1; NumberVar BusinessDays := 0; NumberVar TotalDays := 0; // <---- NEW...

Sure, just click on the &quot;New Page After&quot; or &quot;New Page Before&quot; properties as necessary under the Format Section window. For instance, if your summary page is in Report Footer a and your graph page is in Report Footer b just click &quot;New Page After&quot; in Report Footer a...

Not to my knowledge. Do you think you can get away with suppressing the Column Grand Totals in the Format Crosstab | Customize Style tab (or just suppressing the grand total lable and field cells) then inserting a formula in a section below the crosstab that works along these lines...

That should help dean12 a lot. That particular feature of sharing object properties among group selected objects has caused me some trouble in the past when unwanted properties were copied over into other objects without my knowledge. But that won't happen in dean12's case and should work...

garths2, Geez, JoeCrystal hasn't said anything except to give you a workaround and to point out that one line in the Crystal help could be misleading. You're inferring the purpose of the Val function based on the comment in the help, when its obviously not working that way and its not how the...

Nobody needs those steenkin borders either. I don't know of a way to stop CR from automatically adding them to subreports. You can remove them by right clicking on the subreport object, selecting Format Subreport | Border tab | set the line styles of all sides to None.

I worked out a formula to do this some time ago, here's what I got (you'll need to make hopefully minor modifications to adapt it for your use). Assuming: ?FirstDate = Start date ?SecondDate = End Date NumberVar Idx := 1; NumberVar BusinessDays := 0; // This array will store all the holidays...

I see. There isn't a way to do what you are asking. There are some alternatives, but I don't know if they would meet your requirements: a.) Make the date totals appear at the beginning of each date instead - Format Crosstab | Customize Style tab | click on {Orders.OrderDate} row | Check...

Here's a minor undocumented feature that doesn't make the transition from 8.5 to 8: If you have an 8.5 report that has a pie chart with the labels set to be displayed on the sides, the labels will lose their positions when you save to ver. 8. Minor, but very annoying as the labels will overlap...

Sure, just double click on the label and enter your new text.

I made a quick test report here using a Left Outer Join and it worked. The suppression formula in your detail section should be IsNull(Log In Table.Primary Key) = FALSE (sorry, I typed &quot;True&quot; in my first response). If that still doesn't work, there's another technique, but it is...

Are these truly Grand totals that you want to display at the top of every page (as in you have to repeat the same values for every page), or do you want totals for that page? If its grand totals that they want, you can insert a subreport to display the totals in the page header. I'm not quite...

Yes, there is a Crystal function that does this. Write your formula this way: If IsDate(StringField) then // Checks if the string can be converted to a date CDate(StringField); // Converts the string The CDate function is pretty smart and can translate many different formats, but if it...

How about trying this: > Make the table with the User ID (let's call it Table A) your main table and link to the one with the log in info (Table B). > Add the staff name from Table A and your log in status field from Table B to your detail section. > Add a suppression formula for your detail...

I stand corrected. Thanks for the info synapse, that's a handy tip to know!