Search results for query: *

CR2008. I have several reports that the user wants to export to Excel and do some further manipulating and reporting. Presently, when the reports are exported some of the cells are merged and cause problems when they are being referenced in another worksheet within the workbook. How do I get...

Ian, unfortunately SQL is not available to me. The database I am accessing is a Btrieve file structure and SQL is not supported.

Thanks, Ian, for the prompt reply. I think that will work for viewing online and printing, but I know the user wants to export the report into Excel for further manipulation. I think I am going to have to approach this from a different angle. keith

I have a reports that has two groups. Group1 is mgr and group2 is cust. I already have the details suppressed as requested in the specs, so cust is effectively the detail section. Now, they want the same report with the group2 (cust) suppressed. When I suppress and/or hide this section I...

CR2008 & btrieve(Peachtree) I am producing a report that shows A/R amount, billing amount and calculating a % from those values, grouped by customer. A/R amount comes from main report using customers and jrnlhdr tables. Billing amount comes from a subreport using customers and ticket tables...

LB - thanks for the advice. as it turns out there is an FAQ (faq149-1329) on this site that walks you thru the process and I just got it working correctly. keith

I've tried subreports in the past and was hoping it would not be necessary this time. I was reluctant to go that route because I have date parms that I need to limit the data being retrieved. Can I pass those parms (date range, actually) to the subreport? Thanks so much the assistance. I...

examples of good results... summed by customer from ticket table BillAmount = $6,100 from jrnlhdr table MainAmount = $3,150 these values are for cust_a and are correct When I combine the two in a single report I get results well into the millions or I run out of memory depending on different...

Background - rookie user; CR2008; btrieve data(Peachtree) I have 3 tables: customer, jrnlhdr, & ticket; customer # is link to the tables. I want to report cash receipts from jrnlhdr and billing total from ticket grouped by customer for a given period of time. When I do this...