Recent content by tonygr

Excellent, Thanks again LB Works a treat! TG

Hi LB, Thanks again for your input, would the above work if I had other parameters included in the record selection? please see below original record selection based on your first solution: ==================================================== {viewDaysLastVisit.EXPIRY} >= currentdate() and...

Yes! Tonyg

Sorry LB, I did correct as per your previous post and noticed my newbieness (Silly me!!!) Thanks for spotting it. I also added the "[1]" to make the below work, in case anyone else finds this thread of some use. select {?Age}[1] case "0 to 4" : {@age} < 5 case "5 to 10" : {@age} < 11 case "11...

Hi LB, Thanks for your response, who are we to question customers requirements :) I said the same thing about the groupings strange I know. Many Thanks Problem Solved

Hi All, I am using crxi2 R3 to SQL2000 DB I have a report that uses a dynamic prompt for selecting first a place then dynamic brings up list of values to select from that. I would like to add an additional parameter based (not dynamic) but referencing a formular which in turn references...

Thanks Madawc, Works a treat:) Regards Tonygr

Hi All, I am using crxi11 developer, sql2000 server. I am having trouble pulling all data for the 1st of every month or 15th of every month, ignoring month and year. The date field is held in datetime type, any help greatly appreciated. tonygr

Thanks for the pointers. I have found some code see below, that does something along the lines of what I am after. 'DataGridView Form Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim frm As New DetailForm 'This assumes...

Hi All, I am running crxi dev, vs2005 vb.net, sqlserver2000 A strange thing has happend for no apparent reason, When I run a report with dynamic parameters non of the data is present that used to be there when I browse at the data tables in data explorer window I can see the data fine. These...

Hi all, Sorry for asking such a newbie question, I am using vs2005 and sql 2005 server I have a form with a datagridview, and I want to double click a row and open a detail form. Can anyone point me in the right direction for this. Thanks in advance Tony

Hi TipGiver Thanks for the reply. Unfortnatley as stated above complete novice! is there any sample code available that you could point me to? all I have done is to place the textbox, and button along side the datagridview on the form. any help or tips on where to search for a tutorial would...

Hi all, I am using vs 2005, sql server 2000. Firstly sorry for the newbie question I have created a form with a datagridview from a table called tblMembers. when the form opens it displays the data from the table. I would like to search for a record using a textbox & button. If possible also...

Thanks Ver Much! synapsevampire I took your advise and spoke to a friend who then helped me create a view on the SQL server for the first part. It looks at the customer visits and datediff to the last visit.I have then used crystal to group into months, using a simple formular. This shows...

Hi all, I am Using Crystal Developer xi, SQL server 2000 I am trying to show unmatched records from two tables, but the selection criteria is based on both tables. I have a left outer join from table2(Visits) to table1(Members) linked via the member number fields the following works...