Is such a report possible using SSRS 2005 Report Builder?

I have RS 2005 SP1. I have a report model developed and deployed.

I have a scenario and I am not sure if it is possible to create a report for this scenario using the report builder. Let's say I have a customers entity and address entity that is related to the customer's entity as a 1-many relationship. I have the effective date on the address that specifies the date from which the address is effective. A customer will have multiple records in address with the latest effective date as the latest address of the customer.

Suppose, I need to create a report using the report builder to get the list of latest address for customers, how can I do it? I know it can be done using the report designer using a query that uses the group by clause. But can it be done using report builder?

Thanks in advance.

can someone help? Thanks.|||you can just do that in the SQL query in the data set:

Code Snippet

select [customer_name], [Address1],[Address2]
from customer_table ct
inner join (

select customerID,

max(effective_date) as max_date

from address_table

where effective_date < getdate()) as TopAddress

inner join address_table at
on ct.customerID = at.customerID

and at.customerID = TopAddress.CustomerID

and at.effective_date = TopAddress.max_date

This will return all customers with their latest address, excluding any addresses with a future effective date.

There are other ways, eg with embedded sub reports but then, why add the complexity?|||

Thanks for your response.

I know this can be done and I can build a report using this query with the report designer. I wanted to know if a report with the same output can be built using the report builder?

|||My mistake - mixed up the report builder/designer.

Report builder is very very basic compared to the designer and is really meant for end users with some basic technical knowledge.

Expand your report model to add the data functionality you require

Use report builder to determine how to display that data.

Is such a report possible using SSRS 2005 Report Builder?

I have RS 2005 SP1. I have a report model developed and deployed.

I have a scenario and I am not sure if it is possible to create a report for this scenario using the report builder. Let's say I have a customers entity and address entity that is related to the customer's entity as a 1-many relationship. I have the effective date on the address that specifies the date from which the address is effective. A customer will have multiple records in address with the latest effective date as the latest address of the customer.

Suppose, I need to create a report using the report builder to get the list of latest address for customers, how can I do it? I know it can be done using the report designer using a query that uses the group by clause. But can it be done using report builder?

Thanks in advance.

can someone help? Thanks.|||you can just do that in the SQL query in the data set:

Code Snippet

select [customer_name], [Address1],[Address2]
from customer_table ct
inner join (

select customerID,

max(effective_date) as max_date

from address_table

where effective_date < getdate()) as TopAddress

inner join address_table at
on ct.customerID = at.customerID

and at.customerID = TopAddress.CustomerID

and at.effective_date = TopAddress.max_date

This will return all customers with their latest address, excluding any addresses with a future effective date.

There are other ways, eg with embedded sub reports but then, why add the complexity?|||

Thanks for your response.

I know this can be done and I can build a report using this query with the report designer. I wanted to know if a report with the same output can be built using the report builder?

|||My mistake - mixed up the report builder/designer.

Report builder is very very basic compared to the designer and is really meant for end users with some basic technical knowledge.

Expand your report model to add the data functionality you require

Use report builder to determine how to display that data.

Is MSDE what I need?

We are developing a fairly simple database to be deployed on the
internet. It consists of an artist's works (approx 2600 of them) based
on references to books from which his ideas came. Relative fields will
be fairly few, data related to the books, a pic of his initial sketch,
and a pic of the final painting. Searches will be provided and probably
a feedback form. The plan is for this database to be used by students
when studying myths of the world (and other interested parties, of course).
i am in the beginning stages using Access 2002 and Jet. We just
purchased and installed Visual Studio .net (academic version), but i
haven't actually used it yet. The install mentions MSDE. However, even
after reading about MSDE on MS's site, i still can't determine my course.
For our web application, what should i use? MSDE or Jet? ADO or is DAO
(i am familiar with DAO but not ADO)?
i need a plan, a course of action to follow for this, as it is new
ground for me. i'm not asking for details, just general direction. i'm
basically self-taught and there is no one here who knows any more about
this.
Any guidance is appreciated.
--e
If you're creating an internet application using ASP.NET, the home
page would be a good place to start doing research --
http://www.asp.net/Default.aspx. Jet isn't generally recommended for
Internet applications, although it is being used for small
applications with few concurrent users.You'll be using ADO.NET for
data access, not DAO or ADO. You'll need to do some research to
determine the best fit for your budget and needs. You can get more
information on using MSDE for a web application at
http://msdn.microsoft.com/library/?u...2000webapp.asp
and http://www.microsoft.com/sql/howtobuy/default.asp.
--mary
On Wed, 05 May 2004 11:04:24 -0700, elizabeth baker
<baker_eliz@.yahoo.com> wrote:

>We are developing a fairly simple database to be deployed on the
>internet. It consists of an artist's works (approx 2600 of them) based
>on references to books from which his ideas came. Relative fields will
>be fairly few, data related to the books, a pic of his initial sketch,
>and a pic of the final painting. Searches will be provided and probably
>a feedback form. The plan is for this database to be used by students
>when studying myths of the world (and other interested parties, of course).
>i am in the beginning stages using Access 2002 and Jet. We just
>purchased and installed Visual Studio .net (academic version), but i
>haven't actually used it yet. The install mentions MSDE. However, even
>after reading about MSDE on MS's site, i still can't determine my course.
>For our web application, what should i use? MSDE or Jet? ADO or is DAO
>(i am familiar with DAO but not ADO)?
>i need a plan, a course of action to follow for this, as it is new
>ground for me. i'm not asking for details, just general direction. i'm
>basically self-taught and there is no one here who knows any more about
>this.
>Any guidance is appreciated.
>--e