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 Chriss Miller 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. fredp1

    Subreport Shared variables

    Hi Pete, Thanks for the reply. The formatting of the post made it unclear. After a good night sleep, I agree it was made more complicated than it needed to be. In this instance, I just kept the report similar to what you suggested. Thanks. In the example I provided, I was trying to get all...
  2. fredp1

    Subreport Shared variables

    I need to produce a report which shows the invoice details as well as the serials that was shipped. The invoice details is simply 1 row per invoice number. The problem is when displaying the serial numbers, as they are a one to many serials can be shipped for each invoice. I've tried used a...
  3. fredp1

    MSysObjects - Update all queries Modified Date and time- TOUCH

    In the 'old' days, there was a program called TOUCH. It was used to change the modified date of a file. That way developeres could distribute code and easily tell if source or a file has been modified. The date would stand out for that one file if a change was made. I'm doing the same thing...
  4. fredp1

    MSysObjects - Update all queries Modified Date and time- TOUCH

    While i appreciate the criticality of the system tables, I was just trying to get the date modified updated. The way the responses are written is best if you do not touch them, as appossed to its impossible to do. If it is impossible to do with a program, I'm forced to use a cumbersome manual...
  5. fredp1

    MSysObjects - Update all queries Modified Date and time- TOUCH

    Hi, Any suggestions on changing it programmatically? Cheers Fred
  6. fredp1

    MSysObjects - Update all queries Modified Date and time- TOUCH

    Hi, I need to update the modified date/time of all queries to have a particular date and time. This would be similar to a 'TOUCH' command. By having all queries with the same date/time, Auditors can aesily tell is a query has been modified. Does anyone have some code to do this as a SQL...
  7. fredp1

    Merging multiple database data

    Hi, Their are a number of options. 1. use a union query in crystal. see thread http://www.tek-tips.com/viewthread.cfm?qid=1200068&page=1 as an example. 2. use Access by linking to each of the tables in each db. Then create a union query in access. Use the Access union query as the db source in...
  8. fredp1

    "Left Outer" failing when used after a Stored Procedure

    Can you post your code? I've see programmers use a left outer join with a filter on the right hand side table which effectively cause the SQL to behave like a equal join, hence missing the unmatached records. Fred Cheers Fred
  9. fredp1

    Using Excel Data in Report

    Hi, I'm not a frequent user any more.... I've tested it with CR10 v10.0.5.628, Excel 2003 v11.6355.6568(sp1), Win XPsp2 and it works fine with a dao connection. In the past I found that MDAC can be a bit of a issue. Download the lastest from the Micosoft web site. Also check your service packs...
  10. fredp1

    How to open Picture with associated program

    Hi Win2000 sp 4 and Excel 2002 sp3 does not open the picture via a hyperlink using the associated program. It always using MS Photo Editor. In Win2k, i've associated a the file to open using IE, but the hyperlink in Excel always uses MS Photo Editor. Does anyone have any solution? Thanks...
  11. fredp1

    Centralised administration of the Frequent Contacts Address book

    Hi, How does an administrator specific entries in the Freq Contacts address book for all users? GW 6.5 e.g We had a name setup for sending email to a help desk. The help desk structure has changes so we created 2 new addresses but do not want users to send email to the old address. The old...
  12. fredp1

    CR9 (or CR in General) vs. SQL???

    Hi Mike, CR can report off a number of tables/views. It does this by generating the SQL needed as designed by the developer. It knows this by the fields that you have used on the report, the linking of the tables , the selection criteria etc. It is generally pretty easy to design a report...
  13. fredp1

    convert numeric date to date

    The UFL for Numbertodate can be downloaed from the BO support site. Cheers Fred
  14. fredp1

    SQL expression

    Okay,If i'm not mistaken, if thats the whole query for your report, then you do not really need to have a sql expression. It should be able to be done with a simple left outer join. Is there any thing else needed with the report? if not then i i'll propose a left out join solution and the sql...
  15. fredp1

    How to fix report if SQL Server database name got changed

    Unfortunatly I had the same need a few weeks ago to change a dozen or so reports and changing the ODBC DSN detail is simply not enough. I'd recommend that you do a set location then do a verify. The set location is the action that will make CR point to the new db. The verify is to make sure...
  16. fredp1

    Sub Reports

    As kskid mentioned... avoid using the subreport. Why are you using the sub in the first instance? Maybe you can avoid using it depending on the detail. If you are not doing any filtering or the join to the Category is straight forward why do you need a sub? Can you provide more detail? You can...
  17. fredp1

    Crystal Reports: Database Error

    If you think its a DAO problem try getting the microsft MDAC update. Also I believe there is a service pack for the Jet engine (could be SP8) that is not with MDAC. If you are still having problems... specify the version of Access that your using and what tests you have already done. Also have...
  18. fredp1

    Results of Excel export in 9 not the same as 8.5

    Just picking up on the second tread from gtwood about Exporting to Word... I've just seen that Ver XI has made the exporting to word/rtf 'editable' instead of text boxes. However it still wasn't quite WYSIWYG as I saw numbers right justified instead of left justified, and background colours not...
  19. fredp1

    Export Drill Down / Subreport

    In 8.5 you can only export on the 'main' window/tab. i.e. you cannot export on drilldowns. V9 and above has this functionality for exporting on any tab. Cheers Fred
  20. fredp1

    MSAccess database linked to SQL database bombs out on run

    It works okay for me. I have a linked table in Access that I'm using in CR. I'm using Cr 8.5, Access 97 linked to SQL 2000. Win 2K sp4. Basic suggestions is update MDAC from Microsoft and also patch the Jet engine for Access. SQL ODBC version is 2000.81.9002.00 Also make sure that CR is...

Part and Inventory Search

Back
Top