email notification

Hi All,
We need to email RS reports to various sales persons within a branch.
Sales persons are only allowed to see their own report. Therefor a report
will be executed for the amount of sales persons, passing thru the
salesperson's ID as a parameter. We do not want to schedule a report for each
sales person
Any ideas on how we would be able to email the report to the various sales
persons once the report has been executed for a specific sales person before
executing for the next sales person. We will have a salesperson's table that
contains fields like: ID, SALES_NAME,EMAIL
Any ideas appreciatedA data-driven subscription can accomplish this. One schedule to
service all sales persons, with the Salesperson's ID and their email
address as two of the parms you'll need to supply to the DDS.
HTH
Matt A|||Hi Matt,
Thanks for the reply..I got it working with data-driven subscription
Cheers

else 0 in a table

Hi,
Is it possible to display 0 in a table?
i have a table that drills down into Region and say for instance when
a region has no sales for that day i would like it to show as 0 not
not show on the report in crystal i would simply use a else 0 anynow
know how to achieve this in SQL reporting?
cheersOn Jun 12, 9:52 am, blueboy <matt_me...@.hotmail.com> wrote:
> Hi,
> Is it possible to display 0 in a table?
> i have a table that drills down into Region and say for instance when
> a region has no sales for that day i would like it to show as 0 not
> not show on the report in crystal i would simply use a else 0 anynow
> know how to achieve this in SQL reporting?
> cheers
If I am understanding you correctly, you should be able to include an
'if' statement as the expression for the cell/column you want to show
zero. Something like this should work:
=iif(Fields!Sales.Value is nothing or Len(CStr(Fields!Sales.Value)) <
1, 0, Fields!Sales.Value)
This basically says: if Sales is null/blank, return 0, else return the
Sales value.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Many thanks will give this a shot right now :-)|||Enrique
in my detail Row i have
Region Sales
=count(Fields!Region.Value) =SUM(Fields!Sales.Value)
i have 4 regions 1-4 what i want is it to show regions 1-4 even when
no sales have been done for that day. I have tried the above but it
doesnt seem to work and just returns the same value for the 2 regions
that have done sales and nothing for the 2 that have not.
i have used different variations of below in the column expression and
the detail expression
=iif(count(Fields!ARN.Value) is nothing or Len(CStr(count(Fields!
ARN.Value))) <
1, 0, Fields!ARN.Value)
Please can you point out where im going wrong?
Many Many thanks in advance