Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tonygr
  • Content: Threads
  • Order by date
  1. tonygr

    Is This Possible? using Formula in parameter

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

    help pulling data for 1st or 15th every month ???

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

    Dynamic Data not visible???

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

    help with datagridview row to new detail form

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

    Creating a search button on a form

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

    unmatched records from two tables help

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

    problem crystal 11 dynamic parameters/prompts not working vb.net 2005

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

    inserting selection into another table from a dropdownlist

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

    problem populating a field in another table from a dropdown list

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

    Drop down box troubles

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

    importing csv datetime problems! Please Help

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

    Help with date of birth field

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

    Is This Possible,

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

    counting all records using a formular or sql

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

    frontpage changing the urls madness

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

    auto drive mapping

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

Part and Inventory Search

Back
Top