Search results for query: *

Crystal 11 I have the following report layout. Gist of the data is that each "service" can be offered to multiple suppliers for bid, one of those suppliers is then selected to actually perform the service. The suppliers that can be offered or Assigned might change on a day-to-day basis, so I...

Crystal XI SQL 2005 I have the following formulas in a report: Detail Section (Both fields evaluate correctly) @HSActive (correctly evaluates to 1)= if {@Service} = 'Home Sale Assistance' and {rpt_service.serv_status_desc} <> '>Cancellation' and {rpt_service.serv_status_desc} <> 'Cancelled'...

Crystal XI SQL 2005 I am displaying the results of survey responses in the Detail Section of the Report and then summarizing those results using a Cross-tab in the Report Footer. The survey responses that are being summarized are a mix of Scaled Scores (1-5) and Yes/No responses. Based upon...

Crystal XI SQL 2005 I am displaying the results of survey responses in the Detail Section of the Report and then summarizing those results using a Cross-tab in the Report Footer. The survey responses that are being summarized are a mix of Scaled Scores (1-5) and Yes/No responses. Based upon...

Crystal 11, SQL 2005 Background: I am trying to create a summary Report of Survey Information. There are multiple surveys of which each contains multiple sections and questions under each section. Questions can be 1 of 3 types: Scaled Score (1-5), Yes/No, or Verbatim. I am ignoring verbatim...

Crystal 8.0 SQL 2000 Two problems that I need help with. I have reviewed all prior posts and cannot find a solution. I should note that we are moving to Crystal 11 soon but that does not help my problem now! 1.) Dealing with field lengths greater than 254 characters. I am trying to display...

I have a spreadsheet with multiple worksheets (17 in total.) One worksheet is serving as the database, the other worksheets are linked and pulling information from the "database" worksheet. I need to make a copy of 12 of these worksheets and save them as filename=worksheetname with only values...

Crystal Reports 8.0, SQL 2000 I am trying to write an effective formula to find the first date (Listing Date) that is the FIRST DATE that is => than the base date (Acq Date) that I am comparing it to. Being relatively new to Crystal I do not understand if there is a more direct way of...

I am trying to write an effective query to find the first date that is => than the base date I am comparing it to. Being relatively new to SQL I do not understand if there is a more direct way of getting to the value rather than having to first find the dates that are => (via subquery?)and...

I have the following code. Everything works fine, Except for the PasteSpecial. I end up with a new file with only one sheet named "Results" - but the formulas are still present - obviously I just want the Values. I've tested the PasteSpecial code by itself and it works fine. No errors are...

I have an Excel spreadsheet that has an "Input" tab where the user enters their information, a "Results" tab that performs calculations based on that input. I want to be able to email the "Results" to a client without the "Input" information. I entered the "SaveAs" script then recorded the...

I have an Excel spreadsheet with two tabs: "Input" and "Results". I created a Command Button at the bottom of the "Input" sheet and I want it to do the following: Copy "Results" to a new workbook, then save that new workbook with a relative filename based upon the contents of...

I have an Excel spreadsheet with two tabs: "Input" and "Results". I created a Command Button at the bottom of the "Input" sheet and I want it to do the following: Copy "Results" to a new workbook, then save that new workbook with a relative filename based upon the contents of...

I have a spreadsheet that has a data input section at the top and a "Results" table at the bottom that uses the input data to calculate various estimates. I want to create Command Button that will allow the user to Save ONLY the "Results" data range to a new file, with the file name derived...

I've read through the various Help articles regarding Lookup/Index/Match and can't seem to find an answer to my question. I have the following "Master" table on which a school Conference scedule is built. "Teacher" is the students primary classroom teacher. "Translator" and "IGR" are support...

CR 8.0 SQL I reviewed previous posts and thought this process would be straightforward. I'm obviously missing something important. I want to do a cross tab that displays Daily, MTD and YTD activity based on a datetime field (rpt_customer.cust_rec_date) I want the output to look like the...

CR 8.0 SQL I currently have a Chart & Cross Tab Report in the Report Footer. Q1 How can I get the Chart to appear on page one, page break, then begin the Cross Tab Table on page two? Q2 I want to add a column to the cross tab but I do not want the info to appear in the graph AND all I want is...

Crystal 8.0 SQL I am trying to get the following calculated field working as part of a Cross-Tab Report. Everything seems to work OK except for 'C208' and 'C218'...is it not permissible to use an "AND" statement nested in the "If"? If not, how else could I configure to get the same results...

Hello everyone, I am receiving the "Subquery returning more than 1 value" error from the following code. I understand that the error is being created by customers where multiple records might exist for "serv_type IN ( 'C201','C209','C212','C218'). Question 1: Is there any way to modify the...

CR 8.0 on SQL I am utilizing the Business Objects Support solution for calculating Business Days. As is formula works fine, however, I need to look at "LastDay" as a variable. If "LastDay" is not null, perform the calculation, else use CurrentDateTime and perform the calculation. Any ideas on...