Search results for query: *

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

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

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

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

Hello there. I must be having one of those "brainfart" days. But I need a formula in which will yield me a percent increase from the previous fiscal year. Here is what I have. Grp: Fiscal Year - 2003 Dtl: Hourly Rate - 12.00 Grp: Fiscal Year - 2004 Dtl: Hourly Rate - 15.00 This is...

Hi there. I have a report in which I need a summary of all data to date. But the report itself is limited by a selection criteria as follows: if {?pStart_Dt} = "Default Value" then {Report_Dt} >= {@Fiscal_Start_Dt} and {Report_Dt} <= {@Fiscal_End_Dt} else {Report_Dt} >=...

Hi there. I have a report in which there will be many columns. I don't want to squish them all into one page as they would have to be very tiny. Is there a way to have columns continue onto the next page?

Hi there. I have a report in which it was scheduled to run yesterday (Aug.23). Now when I go and print it out today, the PrintDate still says "Aug.23". Isn't it supposed to spit out "Aug.24"? If not, is there a way around this? Thanks

Using DB2 v8 and CR9 I am having trouble displaying a BigInt field. The values range from 1 to an 11 digit number. It will only display approx. up to the 1.8 million point and nothing larger. Would this be a formula problem or an actual driver issue with CR9? Please advise. Thanks.

Hello there. I am using CR9 and I have a field from DB2 in that has a date/time format of 2004-04-20-11.42.06.991822 (yyyy-MM-dd-hh.mm.ss.ms). How do I get crystal to display the whole field and not just up to the ss part?

Hi there. I have a report in which I need counts of fiscal years at the end of the report. eg. ORG_NO ORG_NM FISCAL_YR 100 abc 2002 100 abc 2003 300 efg 2003 400 mno 2003 400 mno 2004 Total ORG_NO's in 2002: 1...

Hi there. I looked at one of the threads below that is similar to my problem, tried it, and to no avail. Anyway, I have a database that looks like this: PartNo Type Price Date Address ... etc. 1002 A 20 1/1/04 Here ... 1002 B 5 3/3/04 Here ... . . ...

Hello there. I have a question about scheduling reports for version 9. Previously we were using Seagate Info 7 and CR7 and the process was as follows: - create report and save to xdrive - grab the report from the xdrive and drag into SI7 (if the report existed, you would overwrite it. -...

Hi there. I have 2 dates (start and end). Basically they are the start dates and end dates of the quarters (April 1 - June 30, etc.). I have a formula that displays the 2 dates: totext(datetime({FAC_GRANT_DTL.START_DT}),&quot;MMMM dd&quot;)+&quot;-&quot;+...

Hi there. I couldn't find a forum for this anywhere on the web so I thought I would try here. Anyway, it's for Adobe/Accelio Output Designer v4.5.1. If anybody knows anything about this please post or let me know where I could get some help. Anyway, I can't seem to get my details section to...

Hi there. I do normally post Crystal related questions but today I have to find out something about Jetforms (specifically Accelio Present Output Designer v5.4.1). I'm posting this in hopes someone could point me in the right direction. I searched this site to no avail. Thanks

I may be missing something really easy here (blanking out maybe), but how do you display the previous month as text? So I want to somehow turn this: month(currentdate)-1 (which equals 6.00) to: June

I went to the help and looked this up. It says that it will convert a date-time field from Microsoft Access to string, date or date-time. So does this mean that it will not work for a DB2 database?

Hi there. I have a report (CR7) in which I want to report on the duplicate values using the 'mid' function. That is, for example I have the following: ... ABCD1234AB ABCD1278AB ABCD1278CD ABCT3458TD ... etc. The data above is what is contained in the field called {My_Field}. Now looking at...

Hi there. I have a report that groups by {@Month} descending which looks like this: totext({MY_DATE}, &quot;yyyy/MM/dd&quot;) My question is, when I preview the report, how do I get the left side bar to show &quot;January&quot;, &quot;February&quot;, &quot;March&quot;, etc. instead of...