I would like that my cross-tab when it doesn't fit on a page, that goes to the next page in order to keep it together.
Any help is REALLY appreciated.
Thanks,
Ron
CR XI Rel.2
Business Objects Enterprise XI Release 2
Windows Server 2003
Interner Explorer 7
Oracle 9.2
InfoView ActiveX viewer
The report runs for 4 minutes, and when it finishes it doesn't show on the screen, unless I click on next page.
Any ideas on how to fix that?
Thanks,
Ron
I don’t know if anyone realized that, but there is no more “NO SORT” order option in the parameters.
That it is a MAJOR problem in upgrading to XI.
Please let me know if anyone has any input on that.
THANK YOU IN ADVANCE!
Ron
Does anybody have an example on how to use the "While ... Do" operator?
I have a count of 100, and for each record I need to capture it in a variable, and then move to the next record and capture it to another variable, and keep on doing that until I get to the record number 100.
CR9 and Oracle9i
I created a shared variable from subreport A:
WhilePrintingRecords;
Shared NumberVar reportA := {#RunningTotal1}
I placed that variable in report B:
WhilePrintingRecords;
Shared NumberVar reportA
The value on both subreports are in GF1.
In subreport A that value is:
100
150...
GROUP Region (East)
GROUP REP Product A $100 X 5% commission (formula) = $5
GROUP REP Product B $50 X 10% commission (formula) = $5
SUBTOTAL GROUP Region (East) $10
GROUP Region (West)
GROUP REP Product A $100 X 5% commission (formula) = $5
GROUP REP Product...
I have a formula that evaluates for every Group Footer.
How can I summarize the results of that formula on the Report Footer?
I tried everything I know with no success.
Please help!!!
Roni
Oracle 8i
Info 7
I have to use the format Date(2003,2,12) from the parameter in Info to pass the correct date into the report.
Is that a way that I can use the format 2/12/03 from Info?
Thanks,
Ron
Oracle 8i
Info 7
I have to use the format Date(2003,2,12) from the parameter in Info to pass the correct date into the report.
Is that a way that I can use the format 2/12/03 from Info?
Thanks,
Ron
How can I show the Parameter's Description (NOT THE VALUES) on the report?
The JOIN({?Parameter}, ', ') function will only show the Values.
CR 8.5 and MSSQL2000
Thanks,
Ron
I have the following Join() function:
Join( [if {?Parameter} = 'A' then 'Letter A', if {?Parameter} = 'B' then 'Letter B'], ', ')
But if {?Parameter} is only 'A' then I will get 'Letter A,'.
What do I need to do to only get 'Letter A' (without the ',')?
I have CR8.5 and MSSQL2000.
Any help...
How can I group in blocks of 5 years?
Like 1998-2002, 1993-1997, ...
Of course the group will change for next year e.g. 1999-2003, and so on.
CR8 SQL2000
Any help is appreciated.
Ron
I need to show on every page the first letter of the customer.
On the 1st page I have first customer ABC and last customer CLT, and I need to show on the top of the 1st page
"A-C" ... and so on.
Any help is appreciated.
CR8.5 and SQL2000.
Thanks,
Ron
I would like to reset the background color for a new Group.
I used the "If Remainder(RecordNumber,2)=0 Then Silver Else NoColor", and it works find ... but
If the last detail section of the previous group end with background, the new detail section for the new group will not have any...
I have a Cross Tab that whenever a column has all the rows with zeros or nulls, that column is not displayed.
I need to see all the columns, and I am not supressing any rows or columns with zeros.
That is on CR 8 and the database is Oracle.
Thanks in advance for any help.
Ron
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.