Recent content by nicatt

The solution which appears to be holding is to formula New Page After setting with 'not onlastrecord' to Group Footer #1. This seemed to work for us. I just don't understand why :)

Yes, I noticed that checkai and I had posted almost at the same time so that neither of us knew the other was posting. Glad it worked out for you.

Doesn't this say termdate <= DATEADD(d, 30, GETDATE()) or in other words termdate less than or equal to 30 days from today? So if this is July 20, 2004 you should get everyone with a termdate less than August 19, 2004. Try termdate >= DATEADD(d, -30, GETDATE()) or in other words termdate...

Here is my suggestion. Since you want to use the output of the stored procedure you must be on the same platform. Your biggest problem is that the first proc's data is transient and will be deleted after the proc completes its run. To use its data you would have to catch it before the proc...

I am curious as to what you would like to accomplish. The stored proc outputs data that you use for something and you would like to use that same output for additional purposes not related to the first output? Your first proc outputs data but you don't use it for anything and you want to write...

I will check on the service pack. More correctly the version I have is 8.5.0.217 but the company controls updates, etc. I will also experiment with what happens when the page number is in the Header. What mystifies me is why I don't get an extra blank page if the 'not onlastrecord' was the...

This is a difficult issue to show in words. (Crystal 8.5) A report has three groups with the 'page n of m' on the page footer. Group #1 Footer is set to Free Form Placement, Suppress, New Page After, Reset Page Number After and Keep Together. We are underlaying Group Header #2 to Group...

Sometimes one makes things too complicated for their own good. Thank you both for your more reasonable suggestion.

forgot to mention I have Crystal 8.5

Is there a way to test each line in a detail section to see if one field is suppressed and then count the name. In the below example, I selected the field setting of 'suppress if duplicated' for the name. Can I test if the name text suppression is 1 or 0 for true or false? I can then sum the...

I think I found how to do it. Run a loop against the table incrementing a integer in the new column. Then in the stored proc, check the table for the MAX(integer value) in the table's column at the start of the proc. (If there are 113367 records the max value is 113367 the first time). Then...

I wish to create a unique column in a sybase table that currently contains 7 million rows. I also want future row inserts to have similar uniqueness when inserted using a cursor in a stored proc. The table will need to have a column added to it. It was suggested that the problem could be...

I am not an expert but did you try.... Update dbo.TmpMaster30_1 set FirstProm = select (min(h.Prom) from dbo.TmpMaster30_1 t, dbo.FACT_OF_PROM_ARCHIVE h, where t.PersonNo = h.PersonNo)

I am looking at the possibility of purchasing a copy of Crystal reports. My home is about an hour from work and I hate working weekends or late into the night as I am sure many do. An alternative would be to purchase a copy of Crystal and port work back and forth to my home. Living in the...

I noted in the original post Database = Access Example data = IF Month (Issued Date}) = 2 Expected output = Then "Feb" and so forth Admittedly I did not note that it is Crystal 9. I have tried the Left outer join to a date table and it throws a DAO error. I will continue to struggle with it...