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!

  • Congratulations gkittelson 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: *

  1. iamdavidlee

    including javascript variable value in xml string

    thank you for the reply... i will try it out, if it doesnt work i will try and use PHP...
  2. iamdavidlee

    including javascript variable value in xml string

    Hi I have a html pages which has some querystring vales... http://www.example.com/test.htm?category=games I am now trying to get the querysting using javascript and pass it to an XML parser but i dont know how to do that. The XML parser should look like this... <xml id="cdcat"...
  3. iamdavidlee

    Subreport totals

    try this ... http://support.crystaldecisions.com/library/kbase/articles/c2007600.asp
  4. iamdavidlee

    Hi I have a formula which goes i

    hope the explanation is understable.... PLEASE HELP.... Thanks
  5. iamdavidlee

    Using SQL command within a formula field

    hi I have two tables. House Rent table HouseID RentID StarDate EndDate Amout 1 1 1/11/03 30/11/03 100.00 1 2 1/12/03 31/11/03 200.00 Basically this table has house rent details for different periods. From the above data there is a house which chrages...
  6. iamdavidlee

    Hi I have a formula which goes i

    hi I have two tables. House Rent table HouseID RentID StarDate EndDate Amout 1 1 1/11/03 30/11/03 100.00 1 2 1/12/03 31/11/03 200.00 Basically this table has house rent details for different periods. From the above data there is a house which chrages...
  7. iamdavidlee

    Hi I have a formula which goes i

    oops forgot to put the subject name... Also is it possible to use a variable used in forula field in the SQL Expressions field. Thanks
  8. iamdavidlee

    Hi I have a formula which goes i

    Hi I have a formula which goes in a loop to find the number of ppl in a house for a period of time. eg from 1st to 10th. In the formula field i am going in a loop from start date to end date. For each day i want to check another table to see if customer was in the property on that day (using...
  9. iamdavidlee

    Using SQL command within a formula field

    hi thanks for the reply... i am using the following code Dim tempdate As Date Dim x As Number tempdate = {house.MovingInDate} x =0 While tempdate <= {house.MovingOutDate} tempdate=tempdate+1 wend formula =x What I need to do is to count how many ppl are in the house during each day for the...
  10. iamdavidlee

    Using SQL command within a formula field

    hi I am using Basic syntax to write the formula. I am basically going through some dates eg from 1st to 5th using a while loop. For each date i want to run a SQL count records query to get a total number of record for the period. But i am not sure how to add an SQL query inside a formula...
  11. iamdavidlee

    Crystal Report Enterprise on Tomcat

    Hi I am running Crystal report on Jakarta tomcat server and not sure how to get Report Application Server Launchpad running. When I run a jsp file after going through the installation process for crystal reports (enterpreise) I get an error message which basically says that tomcat cannot find...
  12. iamdavidlee

    installing crystal reports for Tomcat

    Hi When I run a jsp file after going through the installation process for crystal reports (enterpreise) I get an error message which basically says that tomcat cannot find any of the class files in the COM directory which should be part of crystal reports ras sdk. Where can I find the COM...
  13. iamdavidlee

    SQL Command and Parameter

    how would i go about creating a record formula... thanks
  14. iamdavidlee

    SQL Command and Parameter

    Hi I am new to Crystal Reports I am using Crystal reports 9. When i use the standard report creation wizard. I can create the database connection and when i try to enter the following SQL command it gives me an error. select * from table1 where name={param} I have created a parameter called...

Part and Inventory Search

Back
Top