Search results for query: *

Field Codes: PAGE

I have a 2003 doc that has page numbers within a footer that is linked to the table of contents. The format of the page number is 'A-1', A-2', etc. When I open up that same doc in 2007 the page numbers in the table of contents are still 'A-1', etc. But on the actual footer/page it only...

Still not working (both methods)... From the above data, the only record that would show on the report would be 88888 -900 2006-07-30 I'm thinking that a view may have to be created. Something I am trying to avoid. Thanks

Hello there. I have deficit report in which I have to select facilities that have deficits, but, if updated without a deficit, not show up on the report. I'm running CR9 and data is from DB2. Here is what the data would look like from DB2: FAC_NO AMT LST_CHG_DT 12345 5000...

No. The report designer in CE9 shows the data. Once the report is scheduled and viewed through the viewer however, it is gone.

Could it be that the report viewer (CE9) does not like running totals?

Hello there. First of all, I had no idea where to post this question so feel free to move it where ever. But anyway, I have a CR9 report running off of DB2 and scheduled on CE9. The formulas for my report are as follows: @Apr_Jun: if isnull({#Apr_Jun_Tot}) or {#Apr_Jun_Tot} = 0 or...

I'm pretty sure that will work. Now the question is do the end users have the ability to refresh? Thanks!

lbass, That's the thing, my report does not require any date limitations. Therefore there are no date fields in my table. The @Monthly_Heading is only an indication as to when the report was run/scheduled. Could I maybe use the printdate?

I actually have a similar problem. I'm running CR9, CE9 and DB2. In my report I have a formula @Monthly_Heading in the report header that looks like this: "FOR THE MONTH ENDING: " + totext(currentdate - 1, "MMMM dd, yyyy") The report is a month end report scheduled to run on the first day of...

Update: The first issue is fixed. Now I've be notified that the left nav numbers are in 123,345,678 format. I've checked the live (web) report and sure enough that is the format. Developing the report on my local desktop the report looks normal. That is, the numbers are in the correct...

I got it. I had to use an SQL Expression and group on that. Int("RSRVD_PRMT"."NUMBER")

The "cheat" didn't work either. Any other ideas?

vampire: Yes, I don't want the decimals. I've tried the formatting of the field as well as the report options and that didn't do it. I'll have to give your "cheat" a try but for some reason that looks like a really familiar formula. I think I may have even tried that. I'll keep you...

Hello there. I am running CR9 and DB2. The issue I have is that I have a report that consists of a field called {RSRVD_PRMT.NUMBER} that comes in from DB2 as a string. I have to group on this field but I also have to order by ascending. To do this I created a formula called @ToNumNumber that...

Any ideas?

Chiming in with another related question here. How would you go about it if your values in the field were undetermined? eg. {table.field} = 12 12 12 16 16 88 88 4 And from this sum the distinct values.(this field would be in the details by the way) eg. 12 + 16 + 88 + 4 = 120

lbass. Thanks for all your help! The "higher-ups" here decided that the % increase will now be calculated using Excel. They also change or add to the report requirements more than most people change underwear. Anyway, the main comparison was to find out what the % increase was in the hourly...

I created my own running totals as I need the count of the totals that are zero or null so that they are not included in the average calculations. For some reason I put the Fiscal Year group in #3. Here is the current version. I'm still looking for the % increase from the previous year...

No, the report is not really that straight forward. Here is what it's like. GrpHdr: Category GrpHdr2: Region GrpHdr3: Fiscal Year Dtl:(suppressed) Hourly Rate GrpFtr2: Avg. Hourly Rate eg. Category: School Region: North Fiscal Year: 2003 Avg.Hrly Rt: 12.50...