Search results for query: *

I have a report with formula fields.. the size of the formula field is set to 10 ARIAL. When exported it is exporting with arial 9 font size. This is so weird. Any idea why it is happening?

There are some alternatives like Upgrade management (only for admin), Promotion management (creates .lcmbiar file).. but none of these creates .biar file. Any options in BOBJ 4.1?

Hi, I have a text "Construction Report" in Report header. When i export it to excel i want it to be top aligned. How to accomplish it..? Thanks

Hi, I have a report with construction details.. it has below fields Transaction# - Datatype Number(10) Construction_company - Datatype Varchar2(15) Amount - Datatype Number(20) Now the changes are made to the size of these fields in database. The field names are same. Transaction# - Datatype...

I have a report and i have page N of M special field on page footer. It doesnt display how many pages are there like 'Page 1 of 50', instead it displays 'Page 1 of 5('. The other '0' part in '50' is getting truncated. The field have more than enough space on report. I used formula field, text...

Hi, I have a need to create a checkbox on report, it displays correctly when exported to Excel (displays Checkbox) but doesnt display correctly when exported to PDF (displays 2 dotted line _ _). Below is forumula used If {table.field}='true' Then CHR(254) Else CHR(168) The font is set to...

Hi, I have a group on {ACCNT_NMBR} field. There is a page header which i want to display just once per account number. And want to suppress this page header on last page. How to do that..? Any help would be greatly appreciated. Thanks

Hi, I have a report. It is grouped by {org} and has details as {acct.acct_nb}. Below is more detail. I want the distinct count of ORGUS as 2, i want to exclude 0 and include the distinct values of non zero account. Similarly i want the distinct count of ORGCAN as 4. ORGUS - 23412 -...

Hi, I am exporting a report to pdf but when i do, the font size is decreasing. Any solution to keep the same font size while exporting to pdf from crystal reports? Quick reply would be greatly appreciated. Thanks

Hi, I am grouping a report based on account type (A,C,X). I am calculating summaries of amounts (Sum({XYZ.Amount},{XYZ.ACTTYP})) for these accounts. A 100 C 200 X 150 In the report footer i want to display details like For Type A: Amount = 100 For Type C: Amount = 200 For Type X...

Hi, I have a group on account, i've two group header sections of this group. I want to display one group header A (GHA) only once but want to display group header B (GHB) on every page. Any logic would be greatly appreciated. Thanks

I have values in the field {Acct.Code}as below A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 Now when i group on this field i am expecting it to be in sequence like A1 A2 A3 A4.... But it is grouping as A1 A10 A11 A2 A3 A4... What is the fix for this..?

Hi, i have one text object on my report, when i am exporting it to excel it is not appearing as bottom aligned. Is there any way to make a text object as bottom aligned when exporting to Excel..?

I have a field {AllBoxDet} that has the details of all the boxes. The value would be like, "Prod/Manf/Supp/Groc", "Guc/MXD/AAX/CDX On the report i need to have each boxes in different columns like, Branch Box1 Box2 Box3 Box4 1 Prod Manf Supp Groc 2 Guc MXD AAX CDX I...

Hi, I want to repeat report footer section in multiple pages. I have a report that has a group on field {ACNT.ACCNT_NMBR} and showing the details of that account and also summary of all accounts. The requirement was to have the details of account and also summary of all accounts without using...

I have a text object and enabled 'can grow' option. When i exported to excel the text object field is growing upto 3 lines maximum, i have to again stretch the cell in excel to see the complete data. I double checked to see if some line limit is given in 'can grow' option, but its not its...

Hi, I have a cross tab in report footer section, below are the fields used on the cross tab. Row Fields: 1 - Company 2 - Account Summary: 1 - Account (Count) 2 - Account_amount (Sum) Now the problem is the first row is not getting repeated for every Account. The report is getting generated...

Hi, I have a number field, i want it to grow/wrap automatically as text objects does in crystal. When i right click the number field the 'can grow' option is grayed out, its disabled. Is there any way to do this..? I know we can use CStr() formula to change change the datatype to text and...

Hi, I need to sort cross tab based on the parameter value passed. The parameter is "{?STRORDER}" I used the below formulae for doing "Group Sort" - "For All" in cross tab. For Account number ascending, {@Acct_Asc} ============== If Instr({?STRORDER},'ACCT.ACCOUNT_NUMBER ASC')>0 Then...

Hi, I have a report (Detail and Summary). The detail report is the first half of the report and the summary report is second half (Cross tab in Report Footer). I have a cross tab in report footer which is used for summary report. The headers of the cross tab report are different that that of...