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 Mike Lewis 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. aztech

    Blank Page at End of Report

    Does anyone have any idea how to fix this?
  2. aztech

    Blank Page at End of Report

    My report has a group that is grouped by date. I have to have each date on a new page, so in the Grouping and Sorting Properties window of the group, I checked the box "Page break at end". This works perfectly except I get a blank page at the end of the report. How can I omit this blank page...
  3. aztech

    SSRS - Input string was not in a correct format

    After playing around with different expressions, I finally came up with one that worked. The REVVAL fields are part of a "SWITCH" expression called "RebateAmt", where if the property name is this, then use this REVVAL field. With that in mind, I created this expression and it works...
  4. aztech

    SSRS - Input string was not in a correct format

    I am trying to hide rows in my report where a certain field may be blank. I entered the following formula in the expression of the "Hidden" properties of the details row in layout: =Iif(Fields!REVVAL3.Value="",TRUE, Iif(Fields!REVVAL5.Value="",TRUE, Iif(Fields!REVVAL6.Value="",TRUE...
  5. aztech

    Formatting a date to show just the month

    Thanks DaveInIowa, your solution worked. Also, thanks to mstrmage1768 for your response. The field was coming over as a DATETIME field, but numeric instead of alpha. I was just trying to get it to convert to alpha.
  6. aztech

    Formatting a date to show just the month

    I also tried =MonthName(Fields!ArrivalDate.Value), but that didn't work either.
  7. aztech

    Formatting a date to show just the month

    I am trying to format a date to display just the month name spelled out. Currently, it is just returning it as the number. I tried the following, but instead of the month name, it returns "MMMM". =Format(Fields!Month.Value, "MMMM") I should also mention that this is a calculated field...
  8. aztech

    Using wildcards in filter expressions

    Thank you! That worked perfectly.
  9. aztech

    Using wildcards in filter expressions

    I have a database of account names where I need to filter out any account name that begins with the 4-letter abbreviation of our hotels. Here's what I'm using (which is not working): NOT LIKE N'*DCBH*' OR NOT LIKE N'*DCBR*' OR NOT LIKE N'*LANP*' I tried the % sign instead of *, but that...
  10. aztech

    SSRS Percent Calculation Formula

    Thank you! That worked perfect. I'm new to SSRS, so your help is greatly appreciated.
  11. aztech

    SSRS Percent Calculation Formula

    I am trying to calculate the percentage of attrition for our group business and I only need to see the ones that did not pick up their contracted room nights. Here's what I have: =IIf(Fields!PickedUpGuestrooms.Value) <...
  12. aztech

    Formula help with phone number field

    Thank you! That worked perfectly.
  13. aztech

    Formula help with phone number field

    It's not working. Everything is coming up under "unknown". Our phone number format is xxx-xxx-xxxx
  14. aztech

    Formula help with phone number field

    I need to create 3 groups based on specific area codes in California. For example, Group 1, will be called Northern California and will contain data based on area codes 707, 530, 916, 209. Group 2 will be called Los Angeles area and contain data based on area codes 805, 213, 323, 818, 562, 714...
  15. aztech

    Publisher 2003 - Saving on a Netware 4.0 server

    When trying to save a publisher file on our Netware server, I keep getting this error: "Folder is marked as 'read only'", but when checking the folder attributes, it is not marked as "read only". I can save the file locally and onto a Windows server, but it won't save on my Netware file server...
  16. aztech

    Printing multiple sheets in excel 97

    Sorry, I misunderstood your question. There's no way that I know of where Excel will just automatically combine pages when printing. You can do a couple of things, both of which are time-consuming and require creating a new worksheet. But when it's done, it's done...it will save you time and...
  17. aztech

    Printing multiple sheets in excel 97

    Make sure the correct print area is defined on each worksheet, then go to File --> Print --> and in the print box, under Print What, select &quot;Entire Workbook&quot;.
  18. aztech

    Windows 98 License problem

    I purchased 6 PC's from a company that was going out of business. All of the PC's have Win98SE, but the company could not locate the licenses. So I purchased the licenses from a company on-line. How can I insert the correct license numbers on the PC's without having to format the disk and reload...
  19. aztech

    last nimda patch

    I don't know if this will help or not, but there is a NIMDA removal tool on symantec's website: http://www.symantec.com/avcenter/tools.list.html
  20. aztech

    Themes and Shared Borders disappear

    Thanks for the great suggestions. I checked and I only have the one home page (default.htm) and I do have Shared Borders turned on, on all pages. I am also stopping the http server when making my changes. This seems to help as I've had no problems the last 2 days, but I will be adding some new...

Part and Inventory Search

Back
Top