Hi gurus.
I have the following challenge:
Let's imagine you have a report containing a table/list of salespeople from
one table, their sales per year from another table, and thirdly for instance
the salesperson's zip code.
If a given salesperson have sales in 2003, 2004, 2005 and 2006, he will have
3 rows returned in the list, and the same zip code listed 4 times.
What you do not want for the report is that the total for the zip coded
column is summed up, so it shows 4 times the zip code. You just want the
single zip code returned on the summary line.
Is there an easy way to achieve this?
Kind Regards,
Torkild HagenYou can use First(Fields!fieldname.value) instead of Sum.
daw
"thagen" wrote:
> Hi gurus.
> I have the following challenge:
> Let's imagine you have a report containing a table/list of salespeople from
> one table, their sales per year from another table, and thirdly for instance
> the salesperson's zip code.
> If a given salesperson have sales in 2003, 2004, 2005 and 2006, he will have
> 3 rows returned in the list, and the same zip code listed 4 times.
> What you do not want for the report is that the total for the zip coded
> column is summed up, so it shows 4 times the zip code. You just want the
> single zip code returned on the summary line.
> Is there an easy way to achieve this?
> Kind Regards,
> Torkild Hagen
Showing posts with label sales. Show all posts
Showing posts with label sales. Show all posts
Friday, March 30, 2012
Tuesday, March 20, 2012
Report Builder field calculate problem
Hi,
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/
Friday, March 9, 2012
Report Builder - unable to open report sample
I have deployed the AdventureWorks report model to the report server and published the sample reports (RDLs - Customer Purchases, Product Sales by Year, and Sales by Territory). When I attempt to open the RDL in Report Builder, I unable to open the report and the following error is reported "This report cannot be opened in Report Builder." Any ideas?
Clay BOnly reports that were authored in Report Builder can be opened in Report Builder. All of the sample reports were authored in Report Designer, not Report Builder.
Report Builder - unable to open report sample
I have deployed the AdventureWorks report model to the report server and published the sample reports (RDLs - Customer Purchases, Product Sales by Year, and Sales by Territory). When I attempt to open the RDL in Report Builder, I unable to open the report and the following error is reported "This report cannot be opened in Report Builder." Any ideas?
Clay BOnly reports that were authored in Report Builder can be opened in Report Builder. All of the sample reports were authored in Report Designer, not Report Builder.
Subscribe to:
Posts (Atom)