Recent content by geestrong

Hello, Crystal Report XI and Sql Server DB I have about 27 individual reports that need to be consolidated. Is it possible to place all these reports into one? Thanks

Thanks, That works

Hello I am using Crystal Reports XI and Oracle 9i database. I have created a report that is grouped by quarter. I am using two parameters(StartDate and EndDate). My Team Lead wants the report to suppress the quarter (i.e. 3rd Quarter) because it does not end until 9/30. I will place the...

Thanks, I think I have it now! Thanks for your help! Geestrong

Thanks for the reply! Of course my users have a Avery format that is not in the list. I have have tried to modify the label that comes closest one in the list but it has two columns and I have not found a way to change that.

I am using CR XI Oracle 9 DB Is it possible to import Avery Label Templates into Crystal Reports and if so where would the template be referenced? Thanks

Thanks again, It worked! geestrong

I am revisiting this topic. The method used to suppress the criteria works, but it works when there is one decision on an application. There are times when there may be multiple decision on the application for Planning agency (i.e, where there may be a HOLD, and now there is a APPROVAL.) This...

LB, I have tried your solution and it appears to be working. I have to next apply it to multiply applications types! Thanks

I have the report group by application Number with is a contcat of application Type and number group 2 is agency with a specific order with B-Pln Rev firs t all other agency Group 3 is Decision ( Approved, HOLD, or NO Decision) Here is a sample of how the data looks like:' Group 1(Application)...

Hello, I am using CR XI and Oracle 9 DB I trying to figure how to suppress this criteria correctly. There are applications that come in. Based on the type of application, they go to certain agencies (ie Application Type 1 may go to agency1, agency2, agency3, agency4 or Application Type 2 will...

LB I do not think I can insert a summaries because of natural of the data and the business rules. But I will give it a try. geestrong

Hello, Using CR XI with Oracle 9 I am trying to sort on two formula values. One formula (a running total) calculates the number of times an application has been put on hold and the other formula calculates the number of days the application have on hold. I am unable to use any of the...

I figured it out! When you at the Report Title field to the report right click and select Format Field... Half way down there is an option called Display Field. You can create a formula! The only thing is you have to initial input a title to the Document Properties. The formula will over ride it...

Thanks for the quick reply. We are also using Crystal Report Server XI to schedule reports which are export to Excel. When the reports run, it uses the the report Title for the report name/file name. There are scripts that are running to move the reports. The reports that are moved to the...