Search results for query: *

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

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

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

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

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 table1.centre when the user makes a selection from the drop down list I would like the value selected to go into...

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 table1.centre when using this I would like the value selected to go into table2.centre. I can get the list of values to...

Hi All, I am Having Problems Importing a csv file. I have tried importing to an existing table, and import to a newtable. At the moment it seems to error on date field. the date data held in the csv is like this: "01.01.2006 15:45" The default datetime size is "8" in the existing table, but I...

Hi All, Can Anybody help? I would like to do analysis using date of birth, i.e. Group totals within age groups. for example: 0 - 16 years 17 - 34 years 35 - 60 years 61 years and over. The data is stored in a sql date field 01/01/1920 I am using CRxi. I would also like to use the formula in a...

I have a report with a select statement which brings up records defind by user i.e. dates. this report is often used as a monthly report so :1/1/06 to 31/1/06. What I would like to do is to be able to show in another graph the same infomation but for a longer date period i.e. 1/1/03 to...

Hi all, I have a report which uses the following {UsageTickets.Centre} = "EE" and {UsageTickets.DATE} = {?Start Date & End Date} and {UsageTickets.HEAD} like ["MCARD", "PCARD", "SCARD"] and not ({ticketdescription.usage_catagory} like ["12", "24", "25", "26", "27", "28", "MISC"]) and...

Hi Can anybody help, I have created a page with links to an external website, the current web uses a application, When I want a user to log out I need to tell the application to do this here is an example. <a href="lfbook.asp?wci=logon&wce=logto&url=http://www.google.com/">google</a> when i...

Hi All, i have 2 servers, 1 shutsdown(A) on a nightly basis and the other server(B) stays switched on 24/7. i have a mapped drive on the server(A), shortcut to mapped drive is on server(B). Server(B) is not refreshing the link when server(A) comes back online i.e. it has the red x over the...