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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by aztech

  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...
See more

Part and Inventory Search

Back
Top