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 wOOdy-Soft 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: SmileyFace
  • Content: Threads
  • Order by date
  1. SmileyFace

    PLEASE HELP(URGENT): Remove Item from Lisbox

    Hi everyone! I have spent hours trying to figure out whats wrong here. My patience is running out, it seems so simple but there is still a problem somewhere! I am basically using an add button to transfer dates selected in a calendar control to a listbox using.net. I also have a 'remove' button...
  2. SmileyFace

    Urgent: Problem with data from Previous month

    I am trying to retrieve data for the previous month...since it is Jan right now, the formula Month(CurrentDate)-1 generates a '0' which gives an error: "A month number must be between 1 and 12". To bypass this the following code was written, but doesn't seem to work...please note what is...
  3. SmileyFace

    URGENT (Please help) - Problem with Previous Month

    I am trying to retrieve data for the previous month...since it is Jan right now, the formula Month(CurrentDate)-1 generates a '0' which gives an error: "A month number must be between 1 and 12". To bypass this the following code was written, but doesn't seem to work...please note what is...
  4. SmileyFace

    [b]URGENT..PLEASE HELP[/b]...attach a final page to end of report!

    Would really appreciate some help here....I have a report that is a Sales Order Acknowledgement....it is printed in 'landscape' format. I need to print out a separate 'Terms & Conditions of Sales' page after the entire report prints out...and I do not want any of the information from the report...
  5. SmileyFace

    PLEASE HELP - Create XML on the fly in asp page

    Hey everyone! I am very new to xml and really need some urgent help with this. I have an asp page which processes data and returns a resultset. I want to be able to write this to an xml file which can be opened and read by another asp page. Here is some of the code.... Response.Buffer = True...
  6. SmileyFace

    Please HELP: Error with editing SQL query in report

    Need some help with this people! I edited my query in the 'Show SQL Query' window, added one more criteria to the where clause. Was getting a 'Database DLL Error'. When I checked on the Crystal support page it said that if a change is made in the show query window, Crystal cannot handle that...
  7. SmileyFace

    URGENT: Help with function call

    Someone please help! This is very frustrating. I am trying to call a vbscript function using a link on my page. This function basically posts a form action. But for some reason it won't execute. Please tell me what I am doing wrong. This is the link: <A class=mainmenu...
  8. SmileyFace

    IMP. QUEST: Pass textbox value but not for record selection

    I have always used my asp pages to pass the record selection formula to the report as parameters. IS IT POSSIBLE TO JUST PASS A VALUE TO A CRYSTAL REPORT FROM AN ASP PAGE (LIKE A FORM TEXTBOX VALUE) BUT NOT USE IT FOR RECORD SELECTION? Basically I want to pass it to the report to print on the...
  9. SmileyFace

    Please help: Error with moving from Verison 8.5 to 9

    Would appreciate some help with this. I designed my reports in Crystal version 8.5 on a server called say X. Now we have moved the reports to another server Y which has Crystal 9 installed on it. After that my reports won't open. The message I get is 'Physical Database Not found'. I haven't...
  10. SmileyFace

    URGENT!- Help with Group Footer exceeding allowable length

    Someone please help!! All my information is in Group Header, Detail and Group Footer. I have put some notes for the group in the group footer to be printed out after the Details section. Problem is these notes sometimes are very lengthy and exceed the allowed length for the footer. Hence the...
  11. SmileyFace

    UREGENT! - Group footer problems!!

    Someone please help!! All my information is in Group Header, Detail and Group Footer. I have put some notes for the group in the group footer to be printed out after the Details section. Problem is these notes sometimes are very lengthy and exceed the allowed length for the footer. Hence the...
  12. SmileyFace

    PLEASE HELP: Repeat Group Header On Each Page option doesn't work!

    Hey! If someone could please tell me why this is happening to my report, I would really appreciate it! I have a report which basically pulls out all invoices for a particular order. So I have grouped it by Invoice Number. If I want to print just one invoice right now I just double click on the...
  13. SmileyFace

    HELP: Repeat Group Header on every page doesn't work!

    Hey! If someone could please tell me why this is happening to my report, I would really appreciate it! I have a report which basically pulls out all invoices for a particular order. So I have grouped it by Invoice Number. If I want to print just one invoice right now I just double click on the...
  14. SmileyFace

    Need help handling quotation marks in SQL insert

    Hey Guys. Really need your help with this one. I am inserting data into an SQL server table from my asp page but need a function to handle the single quotation marks. I basically need to read the string being inserted into the table field and replace any single quotation marks (') with double...
  15. SmileyFace

    HELP!! Handling quotation marks in SQL insert

    Hey Guys. Really need your help with this one. I am inserting data into an SQL server table from my asp page but need a function to handle the single quotation marks. I basically need to read the string being inserted into the table field and replace any single quotation marks (') with double...
  16. SmileyFace

    Handling Quotation marks for SQL Insert

    Hey Guys. Really need your help with this one. I am inserting data into an SQL server table from my asp page but need a function to handle the single quotation marks. I basically need to read the string being inserted into the table field and replace any single quotation marks (') with double...
  17. SmileyFace

    PLEASE HELP! Passing a date range to a report

    I am having problems passing a date range to a report. Please help. I have to pass a shipnumber called custshp to the report along with the report name in this case ship5.rpt and a date range. When passing it I am getting the error message: Error Reading Records: A date-time is required here...
  18. SmileyFace

    HELP!! - Passing a date range parameter to a report

    I am having problems passing a date range to a report. Please help. I have to pass a shipnumber called custshp to the report along with the report name in this case ship5.rpt and a date range. When passing it I am getting the error message: Error Reading Records: A date-time is required here...
  19. SmileyFace

    Problem with a simple 'IF' statement!

    I need help!! This isn't making sense! I am trying to use an 'If' statement to open a report and it won't work....if I write the same code without the 'If' it works fine....here is what works.....the following code passes an ordernum=soeno to a report called soa.rpt. ReportName =...
  20. SmileyFace

    HELP needed with using Select statement to pass parameters to Crystal

    Hey guys! Need some help with this...might be simple but I must be overlooking something here coz it doesn't work! I have 2 Crystal reports which I need to pass parameters to from an asp page. Both of them accept the same parameter, so I have a select statement in the Runreport page which picks...

Part and Inventory Search

Back
Top