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

    exporting large report (170 column) to excel

    i have a 170+ column report in cr. when i export it to excel, after about column 75 the data is out of order (column headings are in correct order, but data is not) and each time i export it, the "out of order" section is out of order in a different way. the fields being exported are group...
  2. apelecanus

    cr 9 report running on .net returns 'field name not found'

    hi, i've created a report in cr9 that uses data supplied by a stored proc on a sql 2000 server. the report runs without error locally but when run by the CrystalReportsViewer .net component, the .net client returns: Error in formula <formula name> 'Local StringVar returnString; ' This field...
  3. apelecanus

    extracting visio db table attributes to excel

    i'm using visio enterprise architect and would like to build a spreadsheet for data conversion from my visio database model... i can report on my tables via the Database/Report/Table Report but my only save option is an .rtf file. anyone done anything like this? thanks, ann
  4. apelecanus

    &quot;cannot write to a read only file&quot; and &quot;unable to process error&

    additional information: we do no file locking within our programs. we have a programmatic record locking system in place which is not the issue. the errors returned are in the dreaded red box and they offer no explanation other than the error message.
  5. apelecanus

    &quot;cannot write to a read only file&quot; and &quot;unable to process error&

    has anyone seen these errors?? we had foxpro for dos 2.5 exe and data running on a novell 3.12 server with the desktops and printers running on win2k network (and office xp on the desktops). then the novell server decided to commit suicide. so we moved everything onto the win2k file server...
  6. apelecanus

    foxpro 2.5 dos on a win2k server

    is anyone running foxpro 2.5 for dos apps from a windows 2000 server? we're getting ready to move our applications from a sickly novell 3.12 server to a win2k server. we already have win2k desktops, printers and clients and things are working smoothly on that side. we're looking for any...
  7. apelecanus

    file creation error

    i'm running a foxpro 2.5 exe on a windows 2k desktop from a novell 3.12 server over a win2k network. networked printers are attached to the novell server. config.fp points to temp directory on the local harddrive. (variables editwork, tempwork and sortwork point to c:\foxpro\temp) config.nt...
  8. apelecanus

    Group footer info repeating

    I'm using cr8 to report on a 600k foxpro database. I have 3 levels of grouping: year, product family, product with subtotals on product family and year. the output should look as follows (the output actually looks good for about the first 5 years of an 11 year report) 1999 product family a...
  9. apelecanus

    CrossTab on large database not calculating correctly

    Thanks for your help. I violated the first rule &quot;know thy data&quot;... and there was actually a category that only two records fell into that the cross tab didn't have a case for. These two accounted for the stray numbers. Thanks again.
  10. apelecanus

    CrossTab on large database not calculating correctly

    I checked the totals for job one in the database with sql and in CR8 and they are correct. And cr is still showing erroneour numbers... you're right my example should have read job 1 job 2...
  11. apelecanus

    CrossTab on large database not calculating correctly

    ... oops! by the way I am doing the above with CR8
  12. apelecanus

    CrossTab on large database not calculating correctly

    Hi, I have a 600k record foxpro 2.5 (.dbf) database with roughly the following structure job number product coverage amount My cross tab rows are based on product + coverage, columns are sums of amount based on job number. the product/coverage group totals are correct, but the individual...
  13. apelecanus

    how to use vb6 recordset as dynamic table at run time?

    1. i'm relatively inexperienced at both vb6 and scr7, but have been using both to create reports for about three months now. 2. i would like to find information on how to pass a recordset created at runtime to a crystal for use a a report table. (i've not found the magic search string for...
  14. apelecanus

    Difficult formula help please

    You check the value of the returned julian date and if it is < 100 string on the leading zeros couldn't you?
  15. apelecanus

    is it possible to pass a variable filename to cr7?

    my goal is to have multiple users able to create simultaneous instances of the report table. CR uses this table as a lookup key into other tables in the database to produce a report. (as i type this it sounds like a bad design plan??) vb really is sending the create table, select and insert...
  16. apelecanus

    is it possible to pass a variable filename to cr7?

    Additional Info: cr makes an odbc connection to the db2 tables. cr is launched thru vb using the cr control component (ocx) thanks again
  17. apelecanus

    is it possible to pass a variable filename to cr7?

    Hello, I'm using vb6 to create tables on DB2 for use by cr7. I'm having resource conflicts when multiple users want to run report concurrently, i.e. bad report output. I'd like to use a variable filename to be passed to cr7 at runtime, but can't get cr to accept one. anyone have any ideas...
  18. apelecanus

    sum of a running total field

    I was able to &quot;fake&quot; a total of running totals by creating a suppressed field in my group footer that kept a &quot;running total total.&quot; I then created a formula to display that total and placed it in the report footer. hope this can help!

Part and Inventory Search

Back
Top