Search results for query: *

Using CR 11.0.0.1282. Right Click on toolbar. Select last option Toolbars... At the bottom of the dialog that comes up it has a section Visual Theme and there is a tick box available for Large Buttons. This makes the icons about 9mm square. Am looking for same option in CR2008 as I use a 24"...

Thanks lbass Once again your answer I guess I 100%. After I posted I did try calculating member ages at start and end of the range and filtered where age_start < age_finish i.e. their age went up in that period. It seemed to work but your approach seems more straightforward. Thanks once...

Hi again Have data basically as follows: id age ddob day month month_mmm 124729 18 28/12/1991 28 12 December 27174 24 28/12/1985 28 12 December 42755 20 29/12/1989 29 12 December 23671 23 29/12/1986 29 12 December 172089 25 30/12/1984 30 12 December 34833 27 31/12/1982 31 12...

My thanks to both Turkbear and lbass. I will try it both way and see how it goes. I am brushing up on my SQL skills on my linux box at home using psql. I must say that this is the most helpful and informative forum that I have found on the net when in comes to Crystal Reports. Thanks to one...

Turkbear Sorry for delay in reply as I have been off work with ongoing health issues. I don't have direct access to the database to create a view and am meeting resistance to change from the powers that be. However I think I found a way around it. I have created an SQL (PostgreSQL 8.4)...

Hi Turkbear Thanks for your prompt reply. I am using Crystal Reports XI. the field tformation is the name of a branch of our Scouting Association ie "Western Rivers Scout Group" and is memo type. I am trying to create a parameter in my report that will allow user to use drop down box to select...

Hello I am wanting to use a field (formation.tformation) as a dynamic parameter in my report. However as this field is "memo" type it does not appear in the drop down list in parameter dialog. I have searched the net and have read about using SQL. But I can't seem to see how to do this as in...

Hi Not a super technical question but a very frustrating one. When in Preview if I select a field in the Data section of the report, or just refresh the report, I get a flickering effect over that column, it looks as if it is continually scrolling over that column with the purple colour that is...

Thanks for the prompt replies. I tried the group selection as lbass suggested and it does exactly what I wanted thank you. Just one other question. The report now look like below: personid fullname recordid applicationdate issueddate expiredate 4 Joe Blow 22729 10/06/2008 11/07/2008...

Hi Reasonably new to CR. I have a report that is grouped by a PersonID displaying transactions sorted by the date descending. What I want to do is have the report display the 2 records with the most recent date. In Cyberquery you could put in a counter (sort of like a running count) and have...