Search results for query: *

no problem....i found out the solution!

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...

thx for the answer ..i have crystal rep X and SQL server 2000. I made my view and i linked it in crystal. I will try with Left outer join...

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...

Thanks a lot..it works!!!!!!!!!!!!!!!!

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...

thx a lot...now it works

i created the same parameters in the subreport, but i cannot link these parameters to the main report's parameters...i dont see the subreport's parameters in the linking screen....

I have only one group..I orderde it by ID and then by MTD, i used the grouonumber function....but it gave me wrong numbers...for example i have only 2 records and the formula (where is the groupnumber) gives me 95 and 105..!!!!!

i tried it...but i think it doesn't work....do u have some code to post?

yes, but i would like to show the rank to the user...

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

this is the record selection in subreport: month({vDW_KPI_SALES_INSTANT_OBJ.OBJDATE})<=int({?Pm-@MonthToNumber}) and year({vDW_KPI_SALES_INSTANT_OBJ.OBJDATE})=int(tonumber({?Pm-?Year})) and {vDW_KPI_SALES_INSTANT_OBJ.SALESREP_ID}={?Pm-?SalesRep}

the problem is (i think) related to this if I leave in the selection record (in the subreport) the links to the parameters of the main report, then i get 0 for the shared var.

hi, thx for the answer ..but it doesn't work.... I placed the shared var in the main report in the report footer and in the subreport in the report header....but i get always 0....

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...

It doesnt work... or i get the correct CustomerID and but not the correct Discount filter....:-(

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...

if i link the parameters CR asks to the user 2 times the same parameter...