Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Create data warehouse report

Posted on 2012-09-06
4
Medium Priority
?
646 Views
Last Modified: 2012-09-11
Hi!

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)

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.
kr2.gif
0
Comment
Question by:team2005
  • 2
4 Comments
 
LVL 18

Assisted Solution

by:vasto
vasto earned 800 total points
ID: 38372841
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.
0
 
LVL 2

Author Comment

by:team2005
ID: 38375363
Hi!

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
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 1200 total points
ID: 38382097
0
 
LVL 2

Author Closing Comment

by:team2005
ID: 38388693
Thanks
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

575 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