Microsoft Excel

“——————————————————————————————————————————————————
Support machine translation: http://amzn.to/1Z7d5oc
——————————————————————————————————————————————————
Crystal Reports Online Help
Microsoft Excel
Column Width
The options in this area let you define the width of the columns in your output Excel worksheet based on a width determined by objects in various sections of your Crystal report or a point width (a constant width).
Note: Selecting “”Whole Report”” does not necessarily emulate the layout of your Crystal report. Rather, the Excel cell width is based on objects found in any section of your report. Likewise, for example, selecting “”Details”” creates cell widths based on the objects found only in the report’s Details section.
Export page headers and page footers
You can choose to export your report’s page headers and footers once for the entire report or repeatedly for each page in the report. If you choose Once Per Report, the header appears once at the top of your spreadsheet and the footer appears once at the bottom. If you choose On Each Page, the header and footer appear repeatedly throughout the spreadsheet in relation to the pagination of your report’s data. If you choose None, page headers and footers are withheld.
Create page breaks for each page
Choose this option to maintain page breaks from your report that you can see in Excel’s Page Break Preview. If this option is not selected, Excel dictates the location of page breaks.
Note: Selecting this option does not guarantee absolute alignment with the page breaks Excel creates in the Page Break Preview.
Convert date values to strings
Choose this option to convert date fields in your report to string fields in Excel. This can be useful if you don’t want Excel to change the formatting of your report’s date information.
This options also address Excel’s inability to handle dates prior to January 1, 1900 (or 1904). If your report contains dates prior to this, Excel displays an error and shows invalid values in the date cell.
Show Gridlines
Choose this option to see gridlines in Excel. Otherwise, the grid will be invisible in your Excel spreadsheet.
Page range
Use the options in this area to limit the number of report pages that you want to export.
——————————————————————————–

Previous page Next page
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/


“————————————————– ————————————————– ————————————————–
Appoġġ ta ‘traduzzjoni awtomatika: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–
Rapporti Crystal Online Għajnuna
Microsoft Excel
Wisa kolonna
L-għażliet f’dan il-qasam tavżak tiddefinixxi l-wisa ‘tal-kolonni fil-produzzjoni tiegħek Excel worksheet bbażati fuq wisa determinat mill-oġġetti fis-sezzjonijiet varji ta’ rapport Crystal tiegħek jew wisa ‘punt (a wisa’ kostanti).
Nota: Għażla “”Rapport Sħiħ”” mhux bilfors jimitaw il-format tar-rapport Crystal tiegħek. Pjuttost, il-wisa ċellula Excel hija bbażata fuq oġġetti li jinstabu fi kwalunkwe taqsima tar-rapport tiegħek. Bl-istess mod, per eżempju, l-għażla “”Dettalji”” toħloq wisgħat ċelloli bbażati fuq l-oġġetti misjuba biss fl-artikolu Dettalji tar-rapport.
headers paġna esportazzjoni u footers paġna
Tista ‘jagħżel li jesporta headers paġna rapport tiegħek u footers darba għar-rapport kollu jew ripetutament għal kull paġna fir-rapport. Jekk inti tagħżel Ladarba Rapport Per, l-header tidher darba fil-quċċata ta ‘spreadsheet tiegħek u l-footer jidher darba fil-qiegħ. Jekk inti tagħżel fuq kull paġna, l-header u footer jidhru ripetutament matul l-ispreadsheet fir-rigward tal-numerazzjoni tad jirrappurtaw data tiegħek. Jekk inti tagħżel Xejn, headers paġna u footers huma miżmuma.
Oħloq pawżi paġna għal kull paġna
Agħżel din l-għażla li jżommu waqfiet paġna minn rapport tiegħek li inti tista ‘tara fil-paġna Break Preview Excel. Jekk din l-għażla ma tkunx magħżula, Excel tiddetta il-post ta ‘interruzzjonijiet paġna.
Nota: Għażla din l-għażla ma tiggarantix l-allinjament assoluta mal-paġna pawżi Excel joħloq fir Page Break Preview.
Ikkonverti valuri data li kordi
Agħżel din l-għażla li jikkonvertu oqsma data fir-rapport tiegħek għal oqsma string fl-Excel. Dan jista ‘jkun utli jekk inti ma tridx Excel li jibdlu l-ifformattjar tar-rapport tiegħek informazzjoni aġġornata.
Dan l-għażliet jindirizzaw ukoll l-inkapaċità Excel biex jimmaniġġaw id-dati qabel Jannar 1, 1900 (jew 1904). Jekk ir-rapport tiegħek fih id-dati qabel dan, Excel displays żball u turi l-valuri invalidi fil-ċellula data.
gridlines Uri
Agħżel din l-għażla biex tara gridlines fl-Excel. Inkella, il-grilja se jkun inviżibbli fil Excel spreadsheet tiegħek.
Page medda
Uża l-għażliet f’dan il-qasam biex jillimitaw l-għadd ta ‘paġni rapport li inti tixtieq li l-esportazzjoni.
————————————————– ——————————

paġna ta ‘qabel paġna li jmiss
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
servizzi ta ‘appoġġ
http://service.sap.com/bosap-support/
Dokumentazzjoni prodott fuq il-Web
http://help.sap.com/

“————————————————– ————————————————– ————————————————–
Ondersteuning masjien vertaling: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–
Crystal Reports Online Hulp
Microsoft Excel
Kolomwydte
Die opsies in hierdie gebied laat die breedte van die kolomme definieer in jou uitset Excel werkblad wat gebaseer is op ‘n breedte bepaal deur voorwerpe in verskillende dele van jou Crystal verslag of ‘n punt breedte ( ‘n konstante wydte).
Nota: Die keuse van “”hele verslag”” nie noodwendig na te boots die uitleg van jou Crystal verslag. Inteendeel, is die Excel sel breedte gebaseer op voorwerpe wat in enige deel van die verslag. Net so, byvoorbeeld, kies “”Besonderhede”” skep sel breedtes gebaseer op die voorwerpe wat net in besonderhede artikel van die verslag.
Uitvoer bladsy kop en bladsy voet
Jy kan kies om jou verslag bladsy kop-en voet een keer uitvoer vir die hele verslag of herhaaldelik vir elke bladsy in die verslag. As jy kies een maal per Verslag, verskyn die kop een keer aan die bokant van jou spreadsheet en die voet verskyn een keer aan die onderkant. As jy kies op elke bladsy, die kop-en voet verskyn herhaaldelik in die sigblad met betrekking tot die paginering van data jou verslag. As jy kies een, is bladsy kop-en voet weerhou.
Skep bladsy breek vir elke bladsy
Kies hierdie opsie na bladsy breek in stand te hou van jou verslag wat jy kan sien in Excel se Page Break Voorskou. As hierdie opsie nie gekies is, Excel dikteer die ligging van bladsy breek.
Let wel: hierdie opsie kies nie waarborg absolute ooreenstemming met die bladsy breek Excel skep in die Page Break Voorskou.
Skakel datum waardes te snare
Kies hierdie opsie om op datum velde omskep in jou verslag te string velde in Excel. Dit kan nuttig wees as jy nie wil hê dat Excel om die uitleg van die jongste inligting van jou verslag te verander.
Dit opsies ook aan te spreek Excel se onvermoë om datums te hanteer voor 1 Januarie 1900 (of 1904). As jou verslag voor hierdie bevat datums, Excel vertoon ‘n fout en toon ongeldig waardes in die datum sel.
Wys roosterlyne
Kies hierdie opsie om raster sien in Excel. Andersins, sal die rooster onsigbare in jou Excel sigblad wees.
Page reeks
Gebruik die opsies in hierdie gebied om die aantal verslag bladsye wat jy wil uit te voer te beperk.
————————————————– ——————————