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

    Crystal 8.5 Hyperlink to URL not working

    I apologize for not explaining myself clearly. We use Crystal 8.5 for report development. We are not using Crystal Enterprise at this time. This report, like others, was prepared for the web using ReCrystallize. This is a project management website that requires login. The report provides...
  2. macrane

    Crystal 8.5 Hyperlink to URL not working

    I have a report that has a conditional hyperlink that looks like this: if dbfield.name = "No" then "http://urlname.com?variablename="+dbfieldname else "http://differenturlname.com?variablename="+dbfieldname (NOTE: the quotes are included in the formula) When I run the report in Crystal 8.5...
  3. macrane

    Update field using stored procedure

    I am writing to my database from an Active Server Page on our website using a stored procedure. All values are being written to the database successully. However, I have a comments field that is a varchar 2500 that I need to maintain the existing value and then add any new value that is...
  4. macrane

    Crystal Reports vs. Crystal Enterprise

    We currently use ReCrystallize to put our crystal reports on our website. They are read only and there is no customization. We have not had any problems with concurrent users. However, we have more reports that are going to have more users accessing them - probably 25 - 50 users. Do we...
  5. macrane

    Getting Files From Mapped Drive

    I have a DTS package that runs on my SQL Server that is supposed to get csv formatted files from a mapped network drive (R:). The files are there every morning, but the job is bombing as if the files are not there. I understand that the SQL Server Agent does not use the same drive mapping as...
  6. macrane

    Access & SQL

    I have an Access application with 81 tables behind it. I need to find a way to make this accessible via the web. My plan is to transfer the database to MS SQL, but I want to use the existing Access frontend via the web. Is there a way to separate the application from the Access database? thanks
  7. macrane

    Rows to Columns in Excel

    Oh my gosh! Thank you so much! You have saved me to much time. Thank you, Thank you Again!
  8. macrane

    Rows to Columns in Excel

    Is there a way to take the information from a row e.g. row1 and make it into one column e.g. columnA row one contains: 12345 123455 1122345 112223234 I would like to move this information to column A: 12345 123455 1122345 112223234 If anyone knows how to do this (short of...
  9. macrane

    Internet Explorer

    I need to create a shortcut on user's desktops with a specially created icon to a specific URL. What would be the best way to code this so that I can send the shortcut to the users via email. Will I need to use an installation package? Thanks
  10. macrane

    Variables and Remedy Database

    I am using Crystal 8.5 Developer on Winnt 4.0 and creating a report from a Remedy Database. I have 6 date/time fields: PersonA.TimeStamp, PersonB.TimeStamp, etc. These are populated every time the Assigned to Individual field is populated with the corresponding name. For instance, if the...

Part and Inventory Search

Back
Top