Create data warehouse report

Posted on 2012-09-06
Last Modified: 2012-09-11

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.
Question by:team2005
    LVL 18

    Assisted Solution

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

    Author Comment


    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

    LVL 21

    Accepted Solution

    LVL 2

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now