Search results for query: *

Thanks, Chris - I do use version 7 of Crystal, so that will be useful as soon as my SQL knowledge has progressed a little! I'm using a 'SAMS Teach Yourself SQL' book for now which is relatively simple. Could anyone suggest a good reference guide for later on? Cheers, Paula

Many thanks - I'd looked at the similar formula on the Crystal Knowledge base, but hadn't been able to turn it around to my needs successfully. Yours was far clearer. Thanks again, Paula

Stig, Have you tried the following? Select relevant field and right click; Select 'Format Field'; Use 'Decimals' drop down list to select '1.0000' format Paula

I'm working with a report based on a SQL view set up by one of our 'experts'. For reasons only known to himself, one of the fields (MOD_DATE) has been created as a string (DD/MM/YY). The appearance on the report is suitable for my needs (date is in English format), but obviously can't be...

I'm working with a report based on a SQL view set up by one of our 'experts'. For reasons only known to himself, one of the fields (MOD_DATE) has been created as a string (DD/MM/YY). The appearance on the report is suitable for my needs (date is in English format), but obviously can't be...

Thanks Robert - I've certainly run into problems as my reports get more complex (they're mostly based on large databases e.g. knowhow items database for an international law firm, so table joins are always an issue...hence my interest in SQL so I can get to the bottom of things!

Many thanks, Ben...and you didn't even make me feel stupid! :-D

Thanks Ben... When you refer to the 'query analyser', presumably this is software which is supplied with the SQL Server software? Basically, I'm working on a networked client PC, and will be able to connect to the SQL server with a password/username...do you think the query analyser software...

Here's a nice easy one for you folks... Somehow I've managed to work with Crystal Reports for some time now, without having to involve myself with or understand SQL or SQL servers (or even much about relational databases. Until now. I'm now trying to develop reports based on complex SQL...

Thanks very much, Ken. Problem solved - my sanity saved! Your input into these forums is invaluable. Paula

Thanks Ken...here's a run-down of the tables (including the alias you suggested to me the other day!): ------------------------------------------------------------ KnowhowItem ID (Linked: KnowhowItem.ID to KnowhowDraftList.ID and KnowhowItem.ID to KnowhowQAList.ID) Title (in...

My report looks something like this (based on a SQL database - knowhow items records): Title Created Date Created By Assigned To Some records will hold data for 'Created By' but not 'Assigned To'. Where this is the case, the record does not show in the report at present. I...

Thanks Ken...I've put your advice into action. It seems that when I work with just the 'AddedBy' usernames, 5 pages of results are returned. However, if I add in the 'CreatedBy' usernames, the report reduces to just 2 pages. As far as I'm aware, some entries in 'CreatedBy' will be blank...

Thanks Ken... I've tried this, but it seems to block out all the data in the report when I update (having added the new column). Excuse my pitiful lack of SQL knowledge, but do you think this is due to the type of link? Thanks again, Paula

Bit of a long shot, this one! I'm having problems getting the information I want from linked tables (knowhow/research database on a SQL server). Table 1 holds most of the obvious record fields (e.g. item ID, title, date added, added by ID etc.). However, to get the full name of the person...

Bit of a long shot, this one! I'm having problems getting the information I want from linked tables (knowhow/research database on a SQL server). Table 1 holds most of the obvious record fields (e.g. item ID, title, date added, added by ID etc.). However, to get the full name of the person...

Rondalo & Ken - many thanks for your help. My problem is well and truly solved and I've registered lots of Tipmaster votes for you!

I need to create a simple report based on monthly totals, in the following format: May June July August Total Records added: 12 10 56 23 Unfortunately, each record added to the database concerned only has an individual date, so I need...