I am using CR 2008 for development and using the Central Management Console to deploy to users to view with Business Objects Infoview.
I created a report specifically for exporting to Excel and it works fine in my client version of CR 2008. But when I deploy it for the users to Infoview, the...
Yes, I use CurrentDate to calculate the start & end dates for the record selection. I thought that might be part of the issue after reading through some other posts. But I'm not sure if I can get around using that.
The report is designed to select data for the previous 2 months, along with...
HI all,
I am having a strange issue. I used CR2008 to develop my report on my desktop client. Once I publish it to the Central Management Console for user access I noticed something weird I have never seen before.
After the report returns the results, when I click on the arrow to go to...
Thanks so much, this is exactly what I was trying to do. I guess I had the wrong syntax for the hasvalue when I tried it before. Thanks again for you quick response and expert help.
I'm using Crystal 2008 with Oracle DB
I have an optional number parm that can accept multiple entries. I want to print this in the header or "All" if they didn't enter anything.
This formula works fine if something is entered in the parm but gives me an error when nothing is entered. The...
Hi all, using CR11 - Oracle DB
Report Looks like this:
Group 1...
Group 2...
Group 3
.... Issue 25.00
.... Sale 10.00
.... Issue 11.00
.... Entry 5.00
.... Sale 30.00
.... Sale 1.00
I need to add count & sum subtotals in my...
Hi, I am using Crystal XI with Oracle DB
I have a DB field on the report that I want to put 'N/A' if it doesn't exist. This field comes from a secondary table that is linked to the primary table. So it only contains data when there is a match to the primary table.
The report shows blanks when...
Hi all,
I am fairly new at this. I'm using CR XI using an Oracle DB. I have an account table I'm reporting on with data such as:
ACCT ID NAME ADDRESS ZIP
0000220 COLBERT 234 XYZ LANE 20705
0009990 STATE 0000005 ZZZZZ 20943
0000005 UNION 1500 RED ST 21190
0009991...
I will try this method.
For clarification my groups are:
Group 1: - Sorted by Service Type
Group 2: - Sorted based on User entered parm (@sort)
Group 3: - Sorted by sales description
So Group 2 is the only group that should change sort order based the parm entered.
I'm sorry, @sum amt is actually @total.
global numbervar total := total + {VENDOR_SALES.AMT_SOLD}
Yes, I have a current group sorted on @sort with the following formula:
If {?Sort Field} = '1' then
crDescendingOrder
else
crAscendingOrder
The user enters a parameter (?Sort Field) to pick which way he wants to sort.
?Sort Field = 1(Dollar) or 2(Zip) or 3(cust name) or 4(cust #)
@sort- formula:
if {?Sort Field} = '1' then
totext({@sum amt}) else
if {?Sort Field} = '2' then
{VENDOR_ACCOUNT.ZIP_BASE} &...
Hello All,
I am using CR XI. I'm totally new to CR. I am creating a Sales report with many different parameter and sort options for the user to select from. One of the sort options is descending by total $ sold per customer. Because of CR's multi-pass processing I cannot sort on a running...
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.