Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Oglesbay

    Crosstabs and Averages

    I did try that, but I couldn't figure out how to find the average. I couldn't do it as a Running Total and when I tried to write the forumla, I kept getting errors. (I can't remember right now what I tried yesterday.)
  2. Oglesbay

    Crosstabs and Averages

    I started a previous thread to figure out how to create the crosstab with my data. Now that we have auditors asking for some data, I need to figure out how to get it out of my data. Here is the link to the previous thread: http://www.tek-tips.com/viewthread.cfm?qid=1593712 Basically, this is...
  3. Oglesbay

    Multiple page dynamic flowing form

    For all those LiveCycle Designers (v8.2) out there, I have been able to create the dynamic form so the fields expand as needed, even going to another page if there is a lot of information. The problem I've run into however is that I've had to add more dynamic fields and have run out of space on...
  4. Oglesbay

    Excel macro to move data then delete rows

    And to clarify, the data fields aren't really "Class Name", "Instructor", and "Class Date." There are real fields in there and I just simplified what I was trying to show.
  5. Oglesbay

    Excel macro to move data then delete rows

    This is an Excel report that shows all the courses that have been taught in a 5 month period. It was exported (only options are HTML and EXL) out of a seperate applicaion which is why it looks the way it does. I'm trying to get it cleaned up so I can run totals, charts and all that other good...
  6. Oglesbay

    Excel macro to move data then delete rows

    Hello all. I am an Excel expert, but I've never had to do VBA coding in macro's, so I guess I'm not too much of an expert then! The issue I have is I have a report that looks something like this: Class Name Instructor Class Date Class...
  7. Oglesbay

    Group Selection Formula

    lbass - You are right that there is nothing wrong with the formula, we just drilled down one group too many. By grouping by question that is what brought our error. If I removed that group and put the formula on the class, it worked perfectly. Thank you all for all your assistance with this issue!
  8. Oglesbay

    Group Selection Formula

    Ok, I'll try to explain it again. A "perfect day" is when we get all Strongly Agree on ALL questions. The forumula above simply returns only the questions that all have Strongly Agree. For example, one class returned only two of the nine questions because in those two questions all of the...
  9. Oglesbay

    Group Selection Formula

    Well, while I was hoping you guys could help me out I thought I came across the answer. What I ended up doing was doing a group select formula as follows: Sum({@stronglyagree},{table.question} = Count({table.name,{table.question}) and Count({table.name,{table.question}) >=4 This formula...
  10. Oglesbay

    Group Selection Formula

    LB - The formula didn't quite work. It looks like it did sum up all of the 1's and only returned the classes that had 4 or higher responses, but the responses that came back still had some Agree, Neutral and Disagree in the responses. I think we're on the right track but I need to only return...
  11. Oglesbay

    Group Selection Formula

    I was able to get assistance with my previous group selection formula and it worked wonderfully. The problem is that they changed how the data is stored and now it is in text where it was numbers in the past. Let me give you an example of my data. We are trying to find the "Perfect Days" in...
  12. Oglesbay

    Minimizing Responses to One Line

    LB - Works like a charm now! All the data shows up but the problem with it is that the first three columns are only single digit numbers and the last three are comment fields with unlimited information. So the all the data can't be shown if I resize to fit the comments. Is there a way to change...
  13. Oglesbay

    Minimizing Responses to One Line

    LB - I tried your formula and I get and error with the "else" section highlighted saying "A string is required here. Here is my formula exactly as I have it: if ({HealthStream_Evals.Evaluation} startswith "The most useful information" or {HealthStream_Evals.Evaluation} startswith "Of all the...
  14. Oglesbay

    Minimizing Responses to One Line

    Going back to my original question, and your first post lbass, what if I also wanted to show data like this: Microsoft Excel Chad Oglesbay Question 1 Agree Question 2 Strongly Agree Question 3 Neutral Comment 1 The class was amazing and.... Kevin Schmitt...
  15. Oglesbay

    OLE Object prints as black box

    Yeah, it is not checked. One thing I did find is that if I "Export" the report then it comes out just fine but if I Print the report using our PDF printer, that is when I have the issue. The weir part is I have been printing using the PDF printer for the last three years without issue.
  16. Oglesbay

    OLE Object prints as black box

    I'm currently using CR XI and have a report that has two Excel OLE objects. I copied them over from another report and they both showed up and printed perfectly on my new report. However, now one of them shows up as a black box. See the attached photo below for example: the top object is fine...
  17. Oglesbay

    Creating formula that will work in a graph

    I created the two formula's you said but I have an issue with the second one. I am getting an error on the first part of the formula that says "There must be a group that matches this field." Here is exactly what I have (with the full real names): sum({@Test Formula -...
  18. Oglesbay

    Creating formula that will work in a graph

    Well the chart that I had working on another report had the date as the "on change" variable and where it was asking for the "show values" I had the percentages of the three questions and it worked great. I'm trying to replicate that and if I explaned it differntly, I apologize.
  19. Oglesbay

    Creating formula that will work in a graph

    Sorry, thought I had everything explained. For the chart, it will be a bar chart where the x-axis is the questions (there are 3) and the y-axis is the date. The time frame will be from the parameter query that I set up. What I'm thinking the "on change" field should be would be the date and set...
  20. Oglesbay

    Minimizing Responses to One Line

    Yeah, right after I posted that I went back and I must have been blind cause I knew I could do that and I jsut didn't see it earlier. Thanks lbass.

Part and Inventory Search

Back
Top