SSRS2008 Samples

[Database Administrator]

I have ran the MSI for SQL2008 for SQL2008.AdventureworksLT and would like to
test report samples. When I ran the first report, company sales.rdl, and
review the Sales dataset, I do not see the Production table. Which
database/MSI from codeplex should I download. I have also downloaded the
Adventureworks database and I now have both Adventureworks and
AdventureworksLT. Please help, I am pulling my hair.

Thanks

Alex

[Database Administrator]

Hi Alex,

This is Mark, a SQL Server engineer. I'm glad to assist you with the issue.

Based on the description, it seems that the adventureworksLT is installed
and attached to the SQL Server instance successfully. Your current concern
is there is no Production table in the sales dataset of the first
report(commany sales.rdl)
Is it correct? if I misunderstand anything, please let me know. That will
help us to resolve the issue quickly.

To better understand the issue, please help confirm/collect the following:
1 tell me where did you download the the MSI for SQL2008.AdventureworksLT.
P. If it is convenient to you, please send the address and the MSI name to
me. I would like to re-produce the issue

2 How do you find there is no Production table in the sales dataset ? For
example, we find that in query desginer.

To address your concern, I would like to share my experience with you.
Based on my experience, there are 2 main reasons for the issue.
one is the data resource of the report (company.rdl) is not the database
AdventureworksLT.

another is in the data set(sales), the data is not retrived from Production
table

Hope the above helpful. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

[Database Administrator]

Hank,

Thanks for your feedback. The source of the MSI was SQL.Adventureworks DB
Scripts V2008*86 msi from codeplex.
(1) I ran it and it installed to C:/Program files/Microsoft SQL
Server/100/Tools/Adventureworks OLTP/. Then I ran the the
RestoreAdventureworks.sql file making necessary changes to the path. It ran
successfully. The problem is this the right database to drive the SSRS2008
samples. In the sql server object explorer: I have AdventureWorksLT.
(2)I am testing out the first report company sales.rdl and for the sales
dataset, this is the query: The question is I cannot see the production table
referenced and get this error message: "Query execution failed for dataset
sales, Invalid Production.ProductSubcategory. What is right database to use.
See data set query
below.


--DECLARE @StartDate datetime
--DECLARE @EndDate datetime

--SET @StartDate = '20020101'
--SET @EndDate = '20031231'
--SET DATEFORMAT mdy

SELECT
PC.Name AS Category, PS.Name AS Subcategory,
DATEPART(yy, SOH.OrderDate) AS Year,
'Q' + DATENAME(qq, SOH.OrderDate) AS Qtr,
SUM(DET.UnitPrice * DET.OrderQty) AS Sales
FROM Production.ProductSubcategory PS INNER JOIN
Sales.SalesOrderHeader SOH INNER JOIN
Sales.SalesOrderDetail DET ON SOH.SalesOrderID = DET.SalesOrderID
INNER JOIN
Production.Product P ON DET.ProductID = P.ProductID
ON PS.ProductSubcategoryID = P.ProductSubcategoryID INNER JOIN
Production.ProductCategory PC ON PS.ProductCategoryID =
PC.ProductCategoryID
WHERE (SOH.OrderDate BETWEEN (@StartDate) AND (@EndDate))
GROUP BY DATEPART(yy, SOH.OrderDate), PC.Name, PS.Name,
'Q' + DATENAME(qq, SOH.OrderDate), PS.ProductSubcategoryID

"Alex. O. Koranteng" wrote:

> I have ran the MSI for SQL2008 for SQL2008.AdventureworksLT and would like to
> test report samples. When I ran the first report, company sales.rdl, and
> review the Sales dataset, I do not see the Production table. Which
> database/MSI from codeplex should I download. I have also downloaded the
> Adventureworks database and I now have both Adventureworks and
> AdventureworksLT. Please help, I am pulling my hair.
>
> Thanks
>
> Alex

[Database Administrator]

Hi Alex,

I'm Mark. Thank you for the update.

in order to resolve the issue, I would like to explain the following.
1 Based on the query from the data set, it is confirmed that the
reproting(company sales) is not pointing to the database AdventureWorksLT.
It is because in the database AdventureWorksLT, there is no schema
Production.

2 Based on my experience, the report should point to database
AdventureWorks2008

So please restore/attach the database AdventureWorks2008 and open the
reporting again.

If anything is unclear, please tell me.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

[Database Administrator]

Mark,

Please point me to to which MSI file at codeplex to download to install
Adventureworks 2008. Right now I have AdventureworksDW2008 and AdventureWorks
installed. It is confusing to know what to install from codeplex. Maybe you
can email me the zipped file

Thanks

"Mark Han[MSFT]" wrote:

> Hi Alex,
>
> I'm Mark. Thank you for the update.
>
> in order to resolve the issue, I would like to explain the following.
> 1 Based on the query from the data set, it is confirmed that the
> reproting(company sales) is not pointing to the database AdventureWorksLT.
> It is because in the database AdventureWorksLT, there is no schema
> Production.
>
> 2 Based on my experience, the report should point to database
> AdventureWorks2008
>
> So please restore/attach the database AdventureWorks2008 and open the
> reporting again.
>
> If anything is unclear, please tell me.
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> ================================================== =======
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@microsoft.com.
> ================================================== =======
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== =======
>
>

[Database Administrator]

Hi Alex,

Thank you for the update.

Please download the SQL Server 2008 Samples via the following:
http://www.codeplex.com/MSFTDBProdSa...ses.aspx?Relea
seId=18407
For 32-bit :SQL2008.AdventureWorks_All_Databases.x86.msi

Besides, Before installing the MSI, please make sure the following:
1 Enable FILESTREAM. There is an article to share with
you:http://msdn.microsoft.com/en-us/library/cc645923.aspx
(http://msdn.microsoft.com/en-us/library/cc645923.aspx)

2 make sure the full-text service is enable.

Hope the above is helpful.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

[Database Administrator]

Mark,

I was able to download the MSI as recommended and ran the first report
CompanySales.rdl. I am very thankful to you. However, when I ran the second
report, Employee sales summary 2008.rdl, I get this error:"Query execution
failed for dataset salesemployee:Invalid coumnname BisinessEntityID" When I
when I look at this dataset from ReportData I see this field. Any
suggesstions. I ran into a similar problem with product line sales 2008 and
other report.

"Mark Han[MSFT]" wrote:

> Hi Alex,
>
> Thank you for the update.
>
> Please download the SQL Server 2008 Samples via the following:
> http://www.codeplex.com/MSFTDBProdSa...ses.aspx?Relea
> seId=18407
> For 32-bit :SQL2008.AdventureWorks_All_Databases.x86.msi
>
> Besides, Before installing the MSI, please make sure the following:
> 1 Enable FILESTREAM. There is an article to share with
> you:http://msdn.microsoft.com/en-us/library/cc645923.aspx
> (http://msdn.microsoft.com/en-us/library/cc645923.aspx)
>
> 2 make sure the full-text service is enable.
>
> Hope the above is helpful.
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> ================================================== =======
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@microsoft.com.
> ================================================== =======
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== =======
>
>

[Database Administrator]

Hi Alex,

Thank you for the update and confirmation. I'm glad my suggestion help to
resolve the issue related to report CompanySales.rdl.

Besides, I would like to share some important information with you. In
order to ensure that the right support professional can work with you to
analyze and solve the technical issue in more timely and efficient manner,
generally, we only focus on one issue per post. Since the first issue
related to report CompanySales.rdl have been resolved and the second issue
related other report is not related to the first one. It is better for you
to submit another post here

For your convenience, I would like to explain my understanding about the
issue here.
1 Based on the error message:"Invalid column name BisinessEntityID". it
seems that the dataset doesn't has the column BisinessEntityID.

2 After checking the dataset, you have found the field BisinessEntityID. So
the cause of the issue might be that the datasource table doesn't has the
colum BisinessEntityID. Please check the datasource table. the detail steps
are below
a) open dataset to find the table name (it should be in "from..")
b) Use SSMS to open the database to check if the column BisinessEntityID
in the table.

Hope the above helpful.
Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and c

[Database Administrator]

Hi Alex,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======