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...
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...
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...
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...
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) <...
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...
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...
Using Frontpage 2000 and publishing on our intranet. I go in to the site and add some hyperlinks to Word and Excel docs, save the page and close it. When I view it in my browser, my Themes and Shared Borders will be gone. Sometimes they will be gone on pages that I've worked on, and sometimes...
I am using Frontpage 2000 to design my web site. Occasionally, when I open up my web files to work on them, some of my themes and shared borders are lost after I save and close the pages. I've installed the Office 2000 SR1 patch. Any help or suggestions would be greatly appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.