Recent content by aztech

Does anyone have any idea how to fix this?

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

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

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

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.

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

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

Thank you! That worked perfectly.

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

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

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) <...

Thank you! That worked perfectly.

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

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

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