Search results for query: *

lbass, Thank you for your kind assistance. I reorganized my data and implemented your suggestion using DistinctCount - it works!

I should have added that I need to perform separate counts on the different services, not just total of all services. Output would look like: Service 1 Assigned Organization1 = 2 Assigned Organization2 = 1 Service 2 Assigned Organization1 = 3 Assigned Organization2 = 4 etc....

Not necessarily. Each Customer can have multiple Services. There is one organization assigned per Service. Thanks again!

lbass, Thanks for your reply. Using Sum for the "Offered to Organization" seems to be working perfectly. However, I cannot get a correct count of the "Assigned Organization" that is in GH3. I setup a simple count formula @service1assignedcount if service=service1 and not isnull(assigned...

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...

lbass, Thank you for your response. I thought I was effectively Summarizing the Detail records via the formula in GF2? I tried a number of variations but each fails. I need to evaluate multiple conditions in the details section to arrive at a summary result in GF2, then be able to sum the...

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'...

LB, You got me on that one. I tested the fields and they are in fact NOT Null Values. My apologies to you for not having my facts together. I added your "Else {@null} to the end of the original formula and it nows works like a charm. Thanks!

LB, Tried exactly as you described but result in the Cross-tab is still evaluating to Average as if Nulls are being counted. I created a new Formula @Null with nothing in it. Changed code to: if isnull form_0164_customer_satisfaction_survey_section_detail.chk_excellent}) and...

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...

LB, After I have created the SQL Query Expressions how do I bring them back together? I tried adding them to a new formula but I get the error "A string can be at most 254 characters." Here is the formula where each expression represents a 254 character segment of the verbatim response field...

LB, Thanks for the quick response. Here is the code that I am using for translating the fields to numerical values in the report. I changed to "Maximum" but now it appears that it might be evaluating all questions in that Section and displaying that Max (rather than evaluating each question...

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...

Sorry for the inerrant post from tcgoth!

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...

Combo, Thank you for the post and the helpful code. It works great to get the worksheets saved as files in the specified directory. I just realized that I need to PasteSpecial Values AND Formats. Is there any way that they can both be accomplished at the same time? I ran a macro record and...

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...

Not sure if this helps or hurts, but here is the code so far. I added your criteria selection suggestion to the FROM clause where highlighted in red. I understand the creation of the Formula field that you mention, just not how to use the Group technique to produce only a single result per...