Recent content by nerdlinger

I have a report that I generate each week using Crystal 8.5. I email it to a person who does not have Crystal of any flavor on their computer. Is there a viewer available(Other than the 20mb) offline viewer that ships with 8.5 that this person can download and install on their computer to view...

I need to display some data in three columns -- not to exceed 27 records-- in the detail section of my report is there an easy way to do that? Thanks

thanks--hn

Ken, We can do this...So what I would do is select all for the account number in YTD...where and how do I put the MTD conditional statement...in a group? thanks

Ken, The bars will represent the answers to the question. there are 15 possible answers. So for example: Only 3 questions for brevity) Q: what attracted you to our store? There were 10 responses ---For the current Year-To-Date(Less Current Month)--- A: 30 said "Location" A: 30 said...

Need some expert guidance on how to accomplish creating a chart. What I have is a field with the possiblity of holding any one of 15 values. This will be a sub-report linked to the main report by accountno. No problem there. The main report is a monthly report. What I need to do is chart the...

My report uses 2 groups, I currently have each group on its own page. I do a summary of all the groups in the report footer. Currently this summary prints on the last page. I am looking for a way to force the report footer onto a separate page--thanks

I am having a problem with a shared variable I have a subreport(placed in the Report footer of the main report and suppressed) that I calculate monthly values in and I need to get them into the group footer of the main report. I keep getting a zero on the report when I do the following...what am...

Here is what I am trying to accomplish. I have a main report that accepts 2 parameters, account number and date range which calculates averages on that criteria. The typical date range for this report will be Sunday-Saturday. I have a subreport linked by account number. The date range in this...

Solved

I took the advice of an earlier response by KH and I am almost there. I am receiving a divison by zero error now. Here is what I have done thus far. This takes place in a group. Thanks,This forum has been most helpful -------------------------- First determine the value of the record(it...

I need to get an average on a field within a group. The field I need to average is a character type and the values that it can contain are the numbers 1-10 and the text "Don't Know" and "Refused To Answer" I need to weed out the text strings and get a sum of all the...

Using a parameter query with only 2 parameters feeding into the report is painfully slow when the table has over 50,000 records in it. Is there any way to speed this up? thanks

I need to count all the "Yes" values in a table and am using the following Count({as.q1},"Yes") and keep receiving this error The Summary / Running Total Field Could Not Be Created Any idea what I am doing wrong... Thanks