Search results for query: *

Many Thanks Ian, That will work a treat. Best Regards Roger

Hi All, Can anyone tell me if there is a way to display more that one record (field) in the detail band? I am aware that I can use the Next() function however if I use this such as Record 1 field plus Next(field) it will show the first record plus the next, but on the following page it will...

Thanks Hilfy, I'll have a look at this today..... Best Regards Roger

Hi All, I want to automatically disconnect InfoView users after x minutes of inactivity. This is because we have a limited number of concurrant user licenses, and most users 'forget' to log off after running a report. Is there a setting where I can specify the number of minutes before they are...

Thanks Turkbear, That is good advice and I'll follow it up. Best Regards

Thanks Brian, Yes you are right...I have just discovered that the max number in an array is 1000 so really it's a no-goer anyway. I was trying to come up with a solution to speed up a report linking two massive tables (90 million records in each approx). I thought perhaps to filter one...

Hi, I have been trying to create an array in Crystal Reports (XI). I have a single table with a column containing codes. All I want to do is create an array in Crystal to hold the codes contained in the table. There are approx 2000. Can anyone tell me the code? Best Regards rpecan

Thanks Chelseatech, I'll try this later when the networks guys come in. Best Regards Roger

Hi All, I am using CR XI and have developed a report to access a table which holds paths to images. I have added an OLE object to the report (a default graphic)and in the Format Graphic, Picture tab have used the 'Graphic location' formula to point to another graphic at a specific location when...

Sorry, that should read XI

Thanks Madawc Yes, should have put the version ...it's CR IX (Professional)

Hi Everyone, I have created a parameter with 2 values ( for example A and B). If A is selected the report will appear as normal based on a set value. If B is selected I would like another parameter to appear prompting the user to enter another value. Is this possible? i.e. Is it possible to...

Hi All, Is it possible to get CR to write a flag back to a table after (or during) a report is printed. I need to set up a Crystal Report which prints an invoice, but changes a 'flag' in the Invoice table to 'Printed?' = 'Y'. I would be very grateful for any help....this is very important for...

Hi LB This works a treat....fantastic....and from memory!! I very much appreciate your help on this and it's got me fired up to learn more programming too. Thanks once again... Best Regards Roger.

Hi LB, Almost there.... I get an error message "This array must be subscripted. For example: Array[i]". The text 'z + {?Client Code(s)} + ", "' is highlighted. Thanks for your help, bye the way, LB. This is very much appreciated. Roger.

Hi LB, The first formula is in the detail and checks fine. I have put the second in the footer as you say and substituted the parameter name with the one I am using. When I check the formula I get the message "The ) is missing" and the 'then' from 'if not(x[i] in y then z....'is highlighted...

Hi All, I want to be able to show codes which a parameter cannot find in a table, but I can't figure out the formula to do it. Example: In a table under the CODE column are 6 codes AAA, BBB, CCC, DDD, EEE & FFF. In my report I have a parameter promting for codes to search for. When prompted I...