Search results for query: *

Never mind... I was able to get the max using "regular" formulas to get the max (as opposed to a running total) and that calculates the value in time to use it as a subreport link.

Does anyone know if it is possible to force a subreport to wait to run until after the records for the main report have been read (or printed) in Crystal 2011? The quick explanation of what I am doing is this: I am trying to calculate a running total whose value is then used to link a subreport...

Does anyone know the formatting syntax for setting up conditional formatting for the currency symbol position? I am using Crystal 10. I would like it to have a leading position for businesses in the US and a trailing position for businesses in France. Below is the (successful) formula I am...

If you just want to save it for possible future use, and it doesn't need to be in the report, you can right-click on that subreport and select "Save Subreport As." Then you can just save it in a directory somewhere for safe-keeping. Should you want to use it in the future, just re-import it back...

Thanks, Ian, I double-checked, just in case, but I don't have any of those three properties checked for any of the groups or sections. Oh well, I had some hope for a few fleeting moments... :) jc

Hi, I am using Crystal 10 and Microsoft SQL Server 2005. When exporting a report to Excel, for each page break seen in preview mode, I am getting a single blank row in the exported file. I have suppressed all page headers and footers, but don't see where the extra row is coming from. If I...

What formula did you put in the suppress section field? If you didn't already, try putting in the following: {trans_type} = 5 This is assuming that field is a number; if it's a text field, you'd need quotes around the 5, of course :)

Those fields can never be null, so the iif statement should be ok. I was using something similar for the suppression that was not quite working, but your formula works perfectly--thanks!

Sure, here they are: {@service_active}: IIF({ACCESSION_ACC_SERVICE.activate_rec} = True, 1, 0) {@service_approved}: IIF({ACCESSION_ACC_SERVICE.activate_rec} = True AND {ACCESSION_ACC_SERVICE.acc_srv_apprvd} = True, 1, 0)

Howdy, I have a report where I am trying to conditionally suppress a group header based on sums in the group footer. The report is grouped by order#, and the order services are in the details section. If one or more order service has not been signed off as complete I want to suppress the...

I have a crosstab where I am labeling it with textboxes placed directly on top of the crosstab. The problem is that, if the crosstab is longer than one page, the textboxes are only displayed on the first page. Because of the positioning of the textboxes, I am unable to use a fake group header to...

lbass- It was the subreport links--now it works perfectly! Thanks so much for your help. jc

Thanks for the help--that got me partway there--I was able to get the page to generate a second time. However, the subreport doesn't have any data in it. It is definitely printing the correct department page twice, since the department page header is correct, but the subreport only displays text...

I am trying to figure out a way to have a page repeated (appear twice in the report) if it contains certain data. I have a report that prints customer order items by department. The report is grouped by department, starting a new page for each department from which the items are ordered, and...

Hi Dana- That worked perfectly--thanks so much! :) --jc

Turkbear-- Thanks for the suggestion. Unfortunately, I am trying to increase, rather than limit, the number of records that are returned. The way the data model is set up, only one record per sample is retrieved, and therefore printed on the report. I created the LABEL_COPY_NBR table to try and...

I have a report that prints out a label for each sample on a sample submission form. I created a parameter where the user is asked how many copies of each sample label they would like to print (this number could potentially be different each time a report is printed). I created a table...

I was having the same issue as ericb123 regarding the Excel export. I followed lbass's instructions to get the section with the blank subreport to suppress (thanks!) This works perfectly when viewing the report in the viewer, as well as exporting it most formats (doc, rtf, pdf). However...