Search results for query: *

Hi I know this has come up with earlier versions, but... I am using Crystal Reports v. 9, but some in my organisation are using earlier versions, so I want to be able to save some of my reports to, say, v. 7 or v.8. Any way to do this - & if not, what possible mad reasoning lead the Seagate...

Fantastic! Worked like a treat... Cheers, Rob

I want to report the results of an array as a string in the group footer, in the format "ArrayItem1, ArrayItem2, ArrayItem3 etc" The formula (called @Array)I am using to output the array is the following: whileprintingrecords; stringVar array MyArray; numberVar Counter; if...

Thanks GeekGirlau I had tried that, and almost thought it was a solution. But...(& so often there is a "but") I need the document to show a date of when it was first printed, not subsequent printings. I also tried createdate, but that just carries the date the original document was...

Hi I have a problem inserting a date into a word document. Normally I would insert a date field into a document, & make it update automatically. However, I am creating a template for a merge document, & getting the date to update automatically causes a problem, because when Word inserts the...

Dgillz I can't access the registry, as I am on a work computer & they have us locked down pretty tightly. Cheers, Rob

Chelseatech I've tested it using the same data in both Crystal SQL designer & Crystal Reports - works in SQL Designer, not in Crystal Reports. Maybe Crystal Reports is slower to query the DB? I noticed a time delay of only 4-5 seconds when browsing in CR. I've never noticed it as an issue...

Thanks for the replies DGillz & Chelseatech, however: I found the "Select Distinct Values for Browsing" which was already ticked, so I unticked it and nothing changed, so I re-ticked it & nothing changed. I can't edit the registry because I'm on a work machine & don't have access...

Hi I am using Crystal Reports 8.5, to query a "view" (this view was created by one of our DBA's) of an SQL database. When I use the browse option to look at the data in a field, it only shows, say, 20 entries. However, when I query the same field using Crystal SQL Designer, there...

Thanks all I wasn't reporting off a query, but the outer join advice was great - I hadn't done it in the report, and when I changed the links to outer joins, it worked like a charm. It seems to be reporting all the null values fine, without me doing a null test in the formula. Is that good...

Hi I fear this question may be something incredibly basic, but... I have a report that includes a number of fields - until now this report appears to have worked OK. However, I have added a field that not all records will have a value associated ie. for some records, that field will have no...

After a quick look through that document, I can see some definite possibilities. Thanks again synapsevampire.

Thanks for your prompt reply SynapseVampire. I am indeed saying that it's the contents in the formula that are dupes. Your suggestion about using arrays sounds interesting - unfortunatly programming/coding isn't my strong point - do you have anything that can start me off? Thanks.

Hi there My apologies to begin with if this question is a little convoluted... I am using CR 7, reading out of a SQL database. I use a formula that concatenates records into one string, and splits the string when it gets close to the 254 char limit. It is as follows: WhilePrintingRecords...

Ido Thanks for your timely reply. I tried your suggestion, but it gave me the error message "The remaining text does not appear to be part of the formula" with the cursor placed at the beginning of the formula. Is the "split" function available for CR7? Cheers, Rob.

Hi I am using Crytal Reports 7, reporting out of a SQL database. One of the fields is a postal address field, that uses chr(13) to encode a new line in the field. So, for example, the field looks something like this ( chr(13) is, naturally, not visible): 31 Smith Street chr(13) Smithville...

Faithful1 - thanks for your reply. I had tried that one, but it suppresses the whole field, rather than the individual values in it. So I end up with output something like this if not supressed (output as a string): fish, cattle, deer, fish, fish If there is another entry with the same...

Hi there My apologies to begin with if this question is a little convoluted... I am using CR 7. I use a formula that concatenates records into one string, and splits the string when it gets close to the 254 char limit. It is as follows: WhilePrintingRecords; StringVar list; StringVar list1...