c# pdf to image conversion : Convert pdf to editable form control application platform web page azure winforms web browser Business_Objects_Desktop_Intelligence_Guide27-part1916

Why?Theinputcontextrequiredtodisplayrevenuefor1998isYear,
whereastheoutputcontextofthebreakfooterisResort.Tofixthiserror,
youaddYeartotheoutputcontextusingtheForEachoperator:
=(If (<Year>="FY1998") Then <Revenue>) ForEach <Year>
Finally,youaddMax(orMin)toreturnthesinglevalueyouneed:
=Max((If (<Year>="FY95") Then <Revenue>) ForEach <Year>)
DesktopIntelligencenowdisplaysRevenuefor1998inthebreakfooter.
Solutionfor#COMPUTATIONinanon-aggregateformula
1. Edittheformulasothattheoutputcontextisincludedintheinputcontext,
asdescribedintheexampleabove.
2. AddMaxorMintothebeginningoftheformula,followedbyanopening
parenthesis.
3. Addaclosingparenthesisattheendoftheformula,thenpressEnter.
#MULTIVALUE
Thissectionprovidesdescriptions,examplesandsolutionsfor#MULTIVALUE
inDesktopIntelligence:
• #MULTIVALUEinaggregationsonpage272suchasmaximumrevenue
peryear
• #MULTIVALUEinbreakheadersandfootersonpage274
DesktopIntelligenceAccessandAnalysisGuide
271
17
CalculationTroubleshooting
#MULTIVALUE
Convert pdf to editable form - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF
Online C# Tutorial to Insert, Delete and Update Fields in PDF Document
cannot save pdf form; pdf create fillable form
Convert pdf to editable form - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF
How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code
change text size pdf form; create a form in pdf
#MULTIVALUE inaggregations
Theexpression"aggregations"referstoanycalculationcontainingan
aggregatefunctionsuchasSum,Count,Min,Maxetc.Inreports,
aggregationsletyouanswerquestionssuchas"Whatistheminimumrevenue
percityforeachregion?".
Thissectionprovidesadescriptionofwhy#MULTIVALUEoccursin
aggregations,withanexample,andoffersasolution.
Note:
TheinformationpresentedhererequiresthatyouunderstandDesktop
Intelligenceextendedsyntax,whichisdescribedin"CalculationContexts
andExtendedSyntax."
Descriptionof#MULTIVALUEinanaggregation
#MULTIVALUEoccursinaggregationsbecause
Example:#MULTIVALUEinanaggregation
Lookatthefollowingtable:
Thedesiredresultintheright-handcolumnisrevenueforadimensionthat
isnotpresentinthetable,forexample,Year.Theformula
=<Revenue> In <Year>
returns#MULTIVALUEbecauseYearisspecifiedastheoutputcontextbut
itisnotpresentinthelocalcontext(thetable).
272
DesktopIntelligenceAccessandAnalysisGuide
CalculationTroubleshooting
17
#MULTIVALUE
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
RasterEdge PDF document conversion SDK provides reliable and effective .NET solution for Visual C# developers to convert PDF document to editable & searchable
change font size pdf form reader; build pdf forms
C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
hardly edit PDF document. Under this situation, you need to convert PDF document to some easily editable files like Word document.
adding text fields to pdf acrobat; adding a signature to a pdf form
Note:
Theformulainthisexampledoesnotbeginwithanaggregatefunction(Min,
Max,etc.).Ifyouomitthefunctioninthisway,DesktopIntelligencecalculates
asumbydefault.However,ifyouhadspecifySumoranotheraggregatefunction
intheformulaabove,forexample
=Sum(<Revenue>) In <Year>
DesktopIntelligencereturns#COMPUTATION.
IftheYeardimensionisavailableinthedocument,youcan,usingextended
syntax,calculaterevenueperyearwithoutdisplayingYearinthetable.To
dothis,youmustdefineaformulawithaninputandanoutputcontext,like
this:
=Sum(<Revenue> In (<Region>,<City>,<Year>) In <Year>)
Solutionfor#MULTIVALUEinanaggregation
Toavoid#MULTIVALUEinanaggregation,theoutputcontextmustbe
includedinthelocalcontext,whichmeansthatthedimension(s)specified
ontherightoftheformulaafterInorForEachmustbepresent.
Tofixyourformula:
1. DisplaytheFormulaBar(FormulaBarcommand,Viewmenu),thenclick
thecellcontainingtheformula.
2. Lookforthefollowing:
• Doestheoutputcontextcontaindimensionsthatarenotintheblock
orsectioninwhichtheformulaisinserted?Forexample,ifthefollowing
formulaappearsinablockthatdoesnotcontainYear,you'llgeta
#MULTIVALUE:
=Min(<Revenue>)In(<Year>)
• Doestheoutputcontextcontainmoredimensionsthanthelocal
context?
• Forexample
=Min(<Revenue>) In(<Region>,<City>)
DesktopIntelligenceAccessandAnalysisGuide
273
17
CalculationTroubleshooting
#MULTIVALUE
C# Create PDF Library SDK to convert PDF from other file formats
file. Create and save editable PDF with a blank page, bookmarks, links, signatures, etc. Create fillable PDF document with fields.
pdf add signature field; change font in pdf form
VB.NET PDF Convert to Word SDK: Convert PDF to Word library in vb.
Convert PDF document to DOC and DOCX formats in Visual Basic control to export Word from multiple PDF files in Create editable Word file online without email.
pdf fillable form creator; add signature field to pdf
• returns#MULTIVALUEinatablecontainingonlyoneofthese
dimensions.
3. EdittheformulaintheFormulaBar,thenpressEnter.
#MULTIVALUE inbreakheaders andfooters
#MULTIVALUEcanoccurwhenyouinsertavariableinabreakheaderor
footerinatableorcrosstab.
Descriptionof#MULTIVALUEinabreakheaderorfooter
Abreaksplitsupthevaluesofavariableandthusenablesyoutomake
calculations.
Abreakfooterisacellatthebottomofeachvalueofthebreak.Users
typicallydisplaytextorcalculationssuchasrunningtotalsinbreakfooters.
#MULTIVALUEoccursinabreakheaderorfooter:
And...
ThenYou...
IfYou...
Thesetwovariables
havea1:1relationship,
asisthecasewithCus-
tomerandAge.
Insertasecondvariable
inthebreakfooter
Setabreakonavari-
able
Here'sanexample.
Example:#MULTIVALUEinabreakfooter
Thetablebelowshowstherunningtotalrevenuefortwocustomers.When
youinsertAgeinthebreakfooter,DesktopIntelligencereturns
#MULTIVALUE.
274
DesktopIntelligenceAccessandAnalysisGuide
CalculationTroubleshooting
17
#MULTIVALUE
VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net
to editable & searchable text formats. Support .NET WinForms, ASP.NET MVC in IIS, ASP.NET Ajax, Azure cloud service, DNN (DotNetNuke), SharePoint. Convert PDF
allow users to save pdf form; can save pdf form data
VB.NET Create PDF from PowerPoint Library to convert pptx, ppt to
Link: Edit URL. Bookmark: Edit Bookmark. Metadata: Edit, Delete Metadata. Form Process. Convert multiple pages PowerPoint to fillable and editable PDF documents.
add text field to pdf acrobat; create a form in pdf from word
Thiserroroccursbecausevariableswitha1:1relationship,(Customerand
Age),areinsertedatthesamebreaklevel.Bydefault,abreakisbasedon
onevariableonly.
Solutionfor#MULTIVALUEinabreakheaderorfooter
Youfixthisproblembyincludingthevariablefromtheheaderorfooterin
thebreakdefinition.
1. Clickinsidethetableorcrosstabcontainingthebreak,thenselectclick
BreaksontheFormatmenu.
TheBreaksdialogboxappears.
2. Clicktheiconofthebreakconcerned,thenclickEdit.
3. Adialogboxlistingallthevariablesinthereportappears.
4. Clickthecheckboxnexttothevariableyouwanttodisplayinthebreak
footer(Ageinthepreviousexample),thenclickOK.
5. ClickOKintheBreaksdialogbox.
DesktopIntelligencedisplaysthevariableinthebreakfooter.
DesktopIntelligenceAccessandAnalysisGuide
275
17
CalculationTroubleshooting
#MULTIVALUE
VB.NET Create PDF from Word Library to convert docx, doc to PDF in
Link: Edit URL. Bookmark: Edit Bookmark. Metadata: Edit, Delete Metadata. Form Process. Convert multiple pages Word to fillable and editable PDF documents.
add forms to pdf; change font size in fillable pdf form
VB.NET Create PDF from Excel Library to convert xlsx, xls to PDF
Create fillable and editable PDF documents from Excel in Create searchable and scanned PDF files from Excel in VB Convert to PDF with embedded fonts or without
add jpg to pdf form; adding image to pdf form
#MULTIVALUEinacellatthesectionlevel
Areportsectiondisplaysdatainamastercellandinablockorblocks.Ifyou
usetwovariablesatthesectionlevel,#MULTIVALUEcanoccur.Here'san
example.
Example:#MULTIVALUEinasectioncontainingnameandaddress
Youwanttodisplaycustomernamesandaddressesinasection,andthe
customers'revenuedetailsinatable.YoubuildatablecontainingCustomer,
Address,InvoiceDateandRevenue,thendragCustomeroutoftheblock
tocreateasection.
276
DesktopIntelligenceAccessandAnalysisGuide
CalculationTroubleshooting
17
#MULTIVALUE
C# Create PDF from Excel Library to convert xlsx, xls to PDF in C#
Create fillable and editable PDF documents from Excel in both .NET WinForms and ASP.NET. Create searchable and scanned PDF files from Excel. Convert to PDF with
change pdf to fillable form; adding text to a pdf form
ThenextstepistodragAddressoutoftheblock,anddropitnextto
Customer.Here'swhatyouget:
Why?Becausebydefault,thereisonlyonemastervariablepersection.
Solution#1for#MULTIVALUEatthesectionlevel
Thewayaroundthisproblemistoturnthevariablethatreturnstheerrorinto
ameasure.
1. Clickthecellcontainingthe#MULTIVALUEerror.
2. ClickVariablesontheDatamenu.
TheVariablesdialogboxappears:
3. Inthedialogbox,clickthevariablethatreturnstheerror.
4. Thenextstepdependsonthetypeofvariableyoujustclicked:
DesktopIntelligenceAccessandAnalysisGuide
277
17
CalculationTroubleshooting
#MULTIVALUE
IftheEditbuttonisavailable
IftheEditbuttonisgrayed
Youcanchangethevariableintoa
measure.
Thismeansthatthevariableyou
needtoturnintoameasurecomes
fromaqueryonauniverse.
Youcannoteditvariablesthatcome
fromqueriesonuniverses,soyou
havetocreateanewvariablein-
stead.
ClickEdit.
TheVariableEditorappears.
IntheQualificationbox,clickMea-
sure,thenclickOK.
ClickAdd.
TheVariableEditorappears.
IntheDefinitiontab,typeaname
forthenewvariable.
IntheQualificationbox,clickMea-
sure.
ClicktheFormulatab.
IntheVariablesbox,double-click
thenameofthevariablethatre-
turnedtheerror.Forexampleifyou
arecreatinganewvariabletore-
placeAddress,double-clickAd-
dressintheVariablesbox.
ClickOK.
5. IntheVariablesdialogbox,clickReplace.
Youreplacetheerroneousvariablewiththeoneyouhavejusteither
createdormodified.Thedataappearsinsteadoftheerror.
278
DesktopIntelligenceAccessandAnalysisGuide
CalculationTroubleshooting
17
#MULTIVALUE
Solution#2for#MULTIVALUEatthesectionlevel
Youcanalsofix#MULTIVALUEatthesectionlevelbyapplyingtheMinor
Maxfunction,whichforcesDesktopIntelligencetodisplayonlyonevalue.
Thissolutionworksformastervariableswitha1:1relationship,suchas
CustomerandAddress(unlessyourcustomershavemorethanoneaddress).
Ifthevariablereturning#MULTIVALUEcontainsmorethantwovalues,you
willonlybeabletodisplaythefirstandlastofthesebyapplyingMinorMax.
1. Clickthemastercelldisplaying#MULTIVALUE.
2. IntheFormulaBar,typeMinorMaxafter(=),thenaddparentheses,like
this=Min(<Address>)
3. PressEnter.
#######
Thecellisnotwideenoughtodisplaythedataitcontainsinfull.
Solution:double-clickthecell'srightborder.DesktopIntelligencewidensthe
celltoautofitthedata.
#ALERTER
Thiserroroccurswhenanalertercontainsamissingvariable.Forexample,
ifthedefinitionofthealertercontainstheRevenuevariable,#ALERTER
appearsifRevenuedoesnotexistinthereport.
Thedefinitionofthealerteritselfmayalsobethecauseofthiserror.For
example,ifyoutrytocompareameasurewithadimension(Revenuegreater
thanCountry),#ALERTERisreturned.
Solution:
Youcan:
Obtainthemissingdatabyaddingthecorrespondingobjecttothequery
(EditDataProvidercommand,Datamenu)
Editthealertersothatitsdefinitioncontainsonlyavailabledata(Alerters
command,Formatmenu)
DesktopIntelligenceAccessandAnalysisGuide
279
17
CalculationTroubleshooting
#######
Deactivatethealerter(Alerterscommand,Formatmenu,thenuncheckthe
alerterinthedialogbox).
Checkthatthedefinitionofthealerterdoesnotcontainacomparisonsuch
asthatofameasurewithadimension.
Tip:TousetheAlerterscommandontheFormatmenu,firstclickanycell
containingdata.
#DICT.ERROR
InDesktopIntelligence,youcanformatareportbyapplyingatemplate.You
dothisbychoosingReport,thenclickingApplyTemplateontheFormat
menu.TheApplyTemplatedialogboxappears.
Atemplatecontainsasetofvariables,alsoreferredtoasthevariable
dictionary.Thereportyouwishtoformatalsocontainsavariabledictionary.
Whenyouapplyatemplate,unlessyouclickOptionsbuttonintheApply
Templatedialogboxinordertospecifythecorrespondencebetweenthetwo
variabledictionaries,DesktopIntelligenceautomaticallyreplacesthevariables
inthetemplatewiththevariablesinthereport.Insomecases,Desktop
Intelligencecannotmatchthevariabledictionariesandreturns
#DICT.ERROR.
Tofixthis problem:
1. Clickthecellcontaining#DICT.ERROR,thenclickVariablesontheData
menu.
The Variables dialog box appears.
2. Clickthevariableorformulathatyouwanttodisplayintheselectedcell.
3. ClickReplace.
TheVariablesdialogboxcloses,andthevariableorformulaappearsin
thereport.
280
DesktopIntelligenceAccessandAnalysisGuide
CalculationTroubleshooting
17
#DICT.ERROR
Documents you may be interested
Documents you may be interested