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

    crystal reports text fields getting cut off

    Before checking the 'no printer' option the report is already in landscape view. When clicking the 'no printer' option it goes to the potrait view and you can't change it back to landscape. The textbox issue is that it'll wrap the text to the next row, but at the right margin of the textbox...
  2. hamking11

    crystal reports text fields getting cut off

    My crystal reports in asp.net pages are getting the text cut off and the carriage returns. I've set the text properties as 'can grow' but it's still getting cut off. I've also tried unchecking the 'No printer' option in the report's 'print setup' menu. but then it shows the report in...
  3. hamking11

    ASP.NET / IIS Security Question

    I'm running into the same issue. Following is a link describing why it wasn't working, http://support.microsoft.com/kb/891031. The method suggested doesn't work for me though, as with <identity impersonate="true" userName="test" password="pass" /> would have all requests impersonate with this...
  4. hamking11

    Convert a Web site to Spanish

    A portion of my site has an English/Spanish requirement. It's mostly web forms used for collecting data, so the translations were mostly labels and not content. I used the resource (.resx) files for the translations and didn't have to create separate pages. Even if your site is mostly...
  5. hamking11

    Help Using the Trace funtionality

    Look in the locals window of visual studio while stepping through debug mode.
  6. hamking11

    Trying to send email w/ home machine IIS/SMTP server

    Make sure to open port 25 on your anti-virus/firewall software.
  7. hamking11

    Image co-ordinates

    An image map would still do the job. You would just use a combination of the polygons, circles, and rectangles to cover an area but they would all point to the same link. For examples if you had a map of the United States and wanted to map the state of Texas. You would use a rectangle to...
  8. hamking11

    Can't join on date field due to nulls

    Thanks guys. Got it working over the weekend with the following query: select orderqty, orderdt, exrate, isnull(exrate, (select exrate from exrate as e1 where exdate = (select max(e1.exdate) from exrate as e1 where e1.exdate < orderdt))) from orders o left join exrate e on o.orderdt =...
  9. hamking11

    Can't join on date field due to nulls

    That'll always return the same rate when a date is null. But I need to return the previous rate. For example on the Currency table: 1/1/06 35.11 1/2/06 36.48 1/3/06 NULL 1/4/06 34.35 1/5/06 NULL If order table has 1/3/06, I need to return 36.48 and if 1/5/06, 34.35 will be...
  10. hamking11

    Can't join on date field due to nulls

    at first i joined on the dates, until i noticed that not all date existed for the currency table. basic idea is i need to join on the date, but if date doesn't exist for currency table get the rate of previous existing date.
  11. hamking11

    Can't join on date field due to nulls

    I have to tables in the following layout: Order Table: quantity currency date Currency Table: rate date Is there a way to get the the following is a one select statement w/out using a temp table: Get the 'quantity', 'rate', 'quantity X rate' based on the date in the order table if the...

Part and Inventory Search

Back
Top