Search results for query: *

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.

...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 didn't work either. Any insight you can provide...

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

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

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

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

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

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