Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts

Monday, March 12, 2012

Maximum page width in Crystal Reports 8

Hi. I'm new to the forum. I apologize if this is the wrong place to pose such a question, or if it's been answered in another thread. I searched and did not find anything.

I don't want to bog everyone down in the details, but I want to give at least a little background as to the problem.

We use Crystal Reports 8.0.1 in conjunction with PeopleSoft Financials 8 to produce positive pay files out of our pay cycle process-which creates checks for vendors. The positive pay file includes basic check information-check number, date, etc. The pay cycle uses the Crystal Report definition, and creates a .txt positive pay file.

Due to new bank requirements, we now have to add several new fields to the file. The Crystal report designer doesn't seem capable of letting me go any further to the right than I already am. On print setup, I changed the layout to landscape, and the paper type to tabloid, and this definitely gave me some extra room. However, I still need about another 100 characters or so.

Does anyone know of any way to expand the page width further than I already have?

Help is much appreciated!Hi

I faced the same problem.. you can try to create a new custom paper size for your printer and change the designer printer setup paper size..
I failed to create a new paper size..
i would like to change the page header of the report also.. can anyone help?

Wednesday, March 7, 2012

Maximum date calculation for all records

For Crystal Reports version 8.5, I need a report for last year's amounts and this year's amounts. My raw data looks like: fund-type, fund-id, customer-id, check amount, check date, last year's beginning date, last year's ending date, this year's beginning date, and this year's ending date. The beginning and ending dates are subject to change. Also, out of the 2,000 records in the raw data, about 5 of the records have the beginning and ending dates attached. I have used the summary calculation of Maximum to find the beginning and ending dates. My problem is that I cannot use the Maximum function in the formula fields to determine if a check is for last year or this year. I also need totals for a customer's checks (last year and this year), fund-id amounts (this year and last year), and fund-type (last year and this year). When I try to create running-totals, I receive the error message that the summary/running totals cannot be created. Is there a way to create this report?
Thank you for any and all help and advice,
TracySHCCreate a formula having the code

If year(datecol)<year(currentdate) then
1
else
2
Place it in details section
Now group the report by this formula and use summary accordingly