Search results for query: *

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...

Hi Can Any body help, I have a few crystal 11 reports which use dynamic prompts to get the required select. I have started building a small app in visual studio 2005 / vb.net. the data is stored in a couple of tables in sql2000. When the reports are run wihin crystal developer the paramatised...

Hi All, Sorry to reserect this thread. I am still having problem with the date(s) (above mentioned) has anybody got any further, in there knowlege of ssis that can help with this one. proving to be a real pain. Thanks Again Tony

can anybody help me with a insert command? Thanks in advance Tony

p.s. I should have added this related info + code. on the form in design view the when the combo is highlighted it produces a arrow top right, click into this then tick databinding mode Data Source = centredescriptionbindingsource Display Member = centre_description Value member =...

Hi All, I originally posted the below in the vb.net forum, but it may be more relevent in this forum, please help. Hi All, Can Anybody help, I have a sql_2000 db which has two tables, I am using vs.net2005 (VB.net) as a front end. I have a form with a drop down box on it, populated from...