team2005
asked on
Create data warehouse report
Hi!
Have this icluded picture i must make for my client.
Have a table, that have all the data i need
Have this query:
One field that i miss here is the field called Brand
And how to get a +/- sign on the report ?
Realy need some help, to how to solve this..
I am using visual studio 2008 to make this report.
kr2.gif
Have this icluded picture i must make for my client.
Have a table, that have all the data i need
Have this query:
SELECT Måned, Kundenavn, ItemName,SUM(AntFaktEnheter) AS Verdier
FROM SALG_STATISTIKKNEW2
WHERE (År = 2012 OR År=2011) AND Måned=1
GROUP BY ROLLUP(Måned, Kundenavn, ItemName)One field that i miss here is the field called Brand
And how to get a +/- sign on the report ?
Realy need some help, to how to solve this..
I am using visual studio 2008 to make this report.
kr2.gif
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
Thanks for big help...
I must use report services....
Is there a example of only build this in report services only ?
Do i need to build a privot table first ?
I am very new to this things, so i be very happy if you can give me example
of how to build this report from scratsh... Using report services only
Thanks