Drill Down Reports?

[former_member275969]

Hi Friends

I need to know about drill down crystal reports for sap b1.,

is any one did this reports plz send me shamples formats to my mail id plz do needful, i need sales related drill down reports for Area wise,branch wise,Sale employee wise sales selection purpose please if u have send me to my mail id

sravanthi217@gmail.com

[kothandaraman_nagarajan]

Hi,

Use standard Business One report for sales employee report. For branch wise and area wise you have write query first and then  add those query in crystal reports.

Try to modify existing sale analysis report as per your requirement.

Thank you

[Former Member]

Hi Friends

I also need that Sales Analysis report , query for sale employee wise please help meout

do needful.

Regards

Smiley

[KennedyT21]

Have you gone through the above post..

Rgds

[KennedyT21]

Tr this query for sales

SELECT [CustName] as CustName, isnull([1],0) as Jan, isnull([2],0) as Feb, [3] as Mar, isnull([4],0) as Apr,  isnull([5],0) as May, isnull([6],0) as june, isnull([7],0) as July, isnull([8],0) as Aug, isnull([9],0) as Sept, isnull([10],0) as Oct, isnull([11],0) as Nov, isnull([12],0) as Dec

from
(SELECT T0.[CardName] as CustName, sum(T1.[LineTotal]) as Total, month(T0.[DocDate]) as month FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE year(T0.[DocDate]) = 2012 and T0.[CardCode] = 'cvet01' GROUP BY T0.[CardName],T0.[DocDate]

union all
(SELECT T0.[CardName] as CustName, -sum(T1.[LineTotal]) as Total, month(T0.[DocDate]) as month FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry WHERE year(T0.[DocDate]) = 2012 and T0.[CardCode] = 'cvet01'  GROUP BY T0.[CardName],T0.[DocDate]

union all

(SELECT T0.[CardName] as CustName, -sum(T1.[LineTotal]) as Total, month(T0.[DocDate]) as month FROM ORDN T0 INNER JOIN RDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE year(T0.[DocDate]) = 2012 and T0.[CardCode] = 'cvet01'  GROUP BY T0.[CardName],T0.[DocDate]))) S

Pivot
(sum(S.total) For  Month IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) P

Rgds

[KennedyT21]

Hi Sravanthi...

Check the video

Create an advanced report for SAP Business One 8.8 - YouTube

Rgds

Kennedy