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 bkrike 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: *

  • Users: pvirsf
  • Content: Threads
  • Order by date
  1. pvirsf

    CR 9..how to report last modification date of data source

    I am running CR9. Anyone know a way to report the last modified date of the ODBC data source file? Thks to any who respond. rsf
  2. pvirsf

    Export file name list viewed in Windows XP Explorer to Excel rows

    Does anyone know of a means to export a list of file names with extensions in a particular folder under Windows XP, to an Exel spreadsheet or text file....one file name per row or text line? I.E. you would be converting a folder listing of file names viewed in Windows Explorer, to data records...
  3. pvirsf

    Call subreports from a loop in main report

    Running CR 9 on Windows XP, PC. Does anyone know of a way to repeat the same subreport a dynamic number of times, from a loop in the main report, changing only variable(s) in the main report for each loop which are shared into the subreport, to yield different results from the subreport each...
  4. pvirsf

    surprised to see "Package Object, expected OLE linked object

    Help please, I am under a deadline. I am developing a simple report to run on CR ver 9. I want to display a logo image based on whatever the content of an image .bmp file is at the time the report is opened and run. I tried using an OLE Object, browsed to the .bmp file created with Paint...
  5. pvirsf

    Surprise "package object", expected OLE linked object

    I am developing a simple report to run on CR ver 9. I want to display a logo image based on whatever the content of an image .bmp file is at the time the report is opened and run. I tried using an OLE Object, browsed to the .bmp file created with Paint, selected Linked, and put the field on the...
  6. pvirsf

    multi LOJ's to look-up table or aliases of that table?

    I am pretty new to CR running CR 9.2. Can you have multiple LOJ's to the same index field in a table used to lookup info to be associated with various other primary tables? e.g. look-up product data for a product.id, where the id is stored in other tables. The relationships might be: Sale.id =...
  7. pvirsf

    Multi LOJ links to lookup table or alias?

    I am pretty new to CR running CR 9.2. Can you have multiple LOJ's to the same index field in a table used to lookup info to be associated with various other primary tables? e.g. look-up product data for a product.id, where the id is stored in other tables. The relationships might be: Sale.id =...
  8. pvirsf

    Range selection for table with mulitple EJ links

    I am running CR 9.2 against a SQL Server db using ODBC. I have 5 tables. I want to report fields from all five on the detail section of the report. Activity.id field in primary table links with LOJ to Sale.id field(indexed) in Sale table & links with LOJ to Oppty.id field(indexed)in Oppty...
  9. pvirsf

    Suppressing subreport output in Main report Preview

    In a CR 9 report, I have several subreports in the Main Report footer subsections. Can I somehow suppress the output of these subreports in the Main Report Preview (where drilldown on any one subreport is not available)? The user wishes to run them all at once, i.e. in a "batch job", but be...
  10. pvirsf

    Suppressing subreport output in preview of main report

    In a CR 9 report, I have several subreports in the Main Report footer subsections. Can I somehow suppress the output of these subreports in the Main Report Preview (where drilldown on any one subreport is not available)? The user wishes to run them all at once, i.e. in a "batch job", but be...
  11. pvirsf

    Drilldown zeroes shared array printed in group footer

    My report runs on CR 9 on a SQL Server data base. Formula P_A prints the value of an array element A[1], being used to do a manual running total, in a level 3 group footer. A[1] is assigned a value in the hidden details section. At the zero level view (no drilldown), it prints correctly in...
  12. pvirsf

    Multiple subreports to run off the same selected data

    Is it true that subreports run independently and independently retrieve data from the data source per the tables, links, and selection defined in the subreport? I am running CR 9 on a MS SQL Server db. I want to have 4 subreports with different grouping and totaling schemes, run from a primary...
  13. pvirsf

    two unequal link values to same SQL Server db table

    I am building a CR 9 report where I have two values of a link, at the same time as the report runs, and I need to link to a given SQL Server db table to do two look-ups. Can a second alias for the look-up table be accessed by the second link value? The SQL query generated by CR seems to accept...
  14. pvirsf

    drilldown zeroes shared variable...continued need for help on thread

    After duplicating my situation in one of the CR sample Xtreme reports, drill down works fine and the shared variable is not zeroed. The sample uses a MS Access data file. My report accesses a SQL Server db over a VPN connection. Could this be a factor? All seems to work fine except for this...
  15. pvirsf

    Shared variable in drilldown to group detail

    Using CR 9 for a report with a subreport in the main report header. The subreport calcs a mannual conditioned running total that is placed in a Shared NumberVar to bring it back to the main report for percentage calcs for the group running totals. The main report preview shows the correct data...

Part and Inventory Search

Back
Top