Recent content by fredp1

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

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

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

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

Hi, Any suggestions on changing it programmatically? Cheers Fred

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

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

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

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

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

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

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

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

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

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