• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 670
  • Last Modified:

Create data warehouse report


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
WHERE (År = 2012 OR År=2011) AND Måned=1
GROUP BY ROLLUP(Måned, Kundenavn, ItemName)

Open in new window

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.
  • 2
2 Solutions
I guess the screenshot shows a pivot table in Excel. You can create a file in Excel and prepare the pivot table there, but you should make sure that your client will refresh the data after opening the file.

Another way is to prepare this kind of report is to use a reporting engine like SSRS or Crystal reports.

Check this video  http://www.r-tag.com/Pages/Preview_Demo.aspx .
It shows 3 ways to create this kind of reports
 1. Crystal Reports
 2. SSRS
 3. Direct SQL which is presented as a pivot table - no reporting engine is required.

Disclaimer: I am linked to R-Tag
If you have fewer than 6 reports you can use the free version.
team2005Author Commented:

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

Alpesh PatelAssistant ConsultantCommented:
team2005Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now