Hi, a new problem with subreport
I have a main report, where the user can select the SALESREPs.In the main report there is a Parameter Field that link to a Table-field "SALESREP", and i added the "*ALL" to let the user to select all the salesrep without picking every salesrep.
The problem is...
I have a Cross tab with Product (1 level) and Models (2level) in Columns and Sales Reps in Rows.Amount Sales as Measures
For all the SalesReps i dont have Amounts for some Models (ex.MOD3)...I would like to have anyway a place holder for these Models, eventually to show 0 as Amount.
Any idea...
Hi,
my problem is...
i have a group "sales rep" and i want to show each element of the group in separate page.So i added in section expert/ new page after/x+2 the formula:
if {?PageBreak}="Y" then
true
else
false
the problem is...if i have Grand Totals....then they go in a new page....i...
Is it possible in CrystalRep 10 to rank a group (example i have salesreps and their sales amount ..i want to rank the salesreps depending on their MTD sales and rank on their YTD sales)...?
thx
Hi,
i am having this problem with shared variables:
1.Main report in the report footer GrandTotal of MTD Sales (i need to pass this to subreport)
2.subreport in the repor theader Sum(MTDGoals) (if i put this in other section of the report header i get 0)
Main report (define the shared var)...
Does someone know how to suppress just only one column in a CrossTab (depending on a condition)?
I have this CrossTab (products on column, models on columns, salesrep on row)
Prod1 Prod2
Mod1 Mod2 Mod3 Mod4
salesrep1 10 12 4 5
salesrep2 7 4...
Someone can tall me why my selection formula does not work?(it means the dealer ID filter works, but the discount filter doesnt work, i got always all discounts, even i select the filter "59")
{vDW_KPI_SALES_MASTER.SHIPPED_DATE}>={?Start Date} and
{vDW_KPI_SALES_MASTER.SHIPPED_DATE}<={?End...
Does someone know if it is possible to do :
sum(sum(amount, salesrep), product)
or sum(max(goals, salesrep), product)?
I tried but CR says that is not possible to summarize ....even i use whileprintingrecords....
thx
How to pass parameter fields from Main report to the subreport?I tried with shared variables, but it does not work....
Main report
Formula: @shMonth
shared numvervar shMonth;
shMonth={?Month};
subreport:
Formula @shMonth
shared numvervar shMonth;
Hi all
my problem with Crystal ReportX:
I do NOT want to use a CrossTab, because i have too many measures to include (MTD, YTD, % etc) and i need to have the difference beetween the grand totals (the crosstab doesnt let me to do that).
So i created 2 groups Products (1st group) and Sales Rep(2nd...
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.