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,
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...
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...
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...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.