Displaying months with no data

Hi all,
Does anyone have any thoughts on hard coding values into a result set
displayed in a grid? I have a dataset that I've built a bunch of grids
from in RS 2005. One of the reports I need to create always needs to
have all of the months of 2006 displayed regardless of whether there's
data. If there's no data for say July 2006, I get the following:
-Thanks!
Completed Programs
January 2006 1
February 2006 2
October 2006 3
November 2006 4
December 2006 233
I need
Completed Programs
January 2006 1
February 2006 2
March 2006 0
April 2006 0
May 2006 0
June 2006 0
July 2006 0
August 2006 0
September 2006 0
October 2006 3
November 2006 4
December 2006 233Hi,
What ever you want to display through report see that you bring it through
query first. if then try command from reporting server. In your case, from
query you can easily bring 0 value for the month which has no data. If not
then try in your grid
=IIF(<month> Is nothing, 0, month) some thing like this.
Regards
Amarnath
"bassunddrum@.gmail.com" wrote:
> Hi all,
> Does anyone have any thoughts on hard coding values into a result set
> displayed in a grid? I have a dataset that I've built a bunch of grids
> from in RS 2005. One of the reports I need to create always needs to
> have all of the months of 2006 displayed regardless of whether there's
> data. If there's no data for say July 2006, I get the following:
> -Thanks!
> Completed Programs
> January 2006 1
> February 2006 2
> October 2006 3
> November 2006 4
> December 2006 233
> I need
> Completed Programs
> January 2006 1
> February 2006 2
> March 2006 0
> April 2006 0
> May 2006 0
> June 2006 0
> July 2006 0
> August 2006 0
> September 2006 0
> October 2006 3
> November 2006 4
> December 2006 233
>|||You need to have the values in the dataset somehow, so if you can I would
create a Month table in the database which you can join to to provide the
complete list. If you can't do that then see if you can do a Stored
Procedure, then you can populate a memory table and return that instead.
Craig
<bassunddrum@.gmail.com> wrote in message
news:1140151459.214316.219040@.o13g2000cwo.googlegroups.com...
> Hi all,
> Does anyone have any thoughts on hard coding values into a result set
> displayed in a grid? I have a dataset that I've built a bunch of grids
> from in RS 2005. One of the reports I need to create always needs to
> have all of the months of 2006 displayed regardless of whether there's
> data. If there's no data for say July 2006, I get the following:
> -Thanks!
> Completed Programs
> January 2006 1
> February 2006 2
> October 2006 3
> November 2006 4
> December 2006 233
> I need
> Completed Programs
> January 2006 1
> February 2006 2
> March 2006 0
> April 2006 0
> May 2006 0
> June 2006 0
> July 2006 0
> August 2006 0
> September 2006 0
> October 2006 3
> November 2006 4
> December 2006 233
>|||If your completely stuck give me your SQL statement and I can add in to it
the extra months using unions.
Craig
"Craig" <craigm_richardson@.hotmail.com> wrote in message
news:%23tHX4u4MGHA.916@.TK2MSFTNGP10.phx.gbl...
> You need to have the values in the dataset somehow, so if you can I would
> create a Month table in the database which you can join to to provide the
> complete list. If you can't do that then see if you can do a Stored
> Procedure, then you can populate a memory table and return that instead.
> Craig
> <bassunddrum@.gmail.com> wrote in message
> news:1140151459.214316.219040@.o13g2000cwo.googlegroups.com...
>> Hi all,
>> Does anyone have any thoughts on hard coding values into a result set
>> displayed in a grid? I have a dataset that I've built a bunch of grids
>> from in RS 2005. One of the reports I need to create always needs to
>> have all of the months of 2006 displayed regardless of whether there's
>> data. If there's no data for say July 2006, I get the following:
>> -Thanks!
>> Completed Programs
>> January 2006 1
>> February 2006 2
>> October 2006 3
>> November 2006 4
>> December 2006 233
>> I need
>> Completed Programs
>> January 2006 1
>> February 2006 2
>> March 2006 0
>> April 2006 0
>> May 2006 0
>> June 2006 0
>> July 2006 0
>> August 2006 0
>> September 2006 0
>> October 2006 3
>> November 2006 4
>> December 2006 233
>

Displaying first instance of data

Hi,

I'm having some trouble with a report I'm trying to generate. It is essentially activity status of a bunch of users that are on the system. The raw data displays the date and time, user, what state they are currently in and what state they changed to and duration.

My problem is I only need the first and last instance for each day. Since a user can go through many states in a day, the data is quite long and to have to filter through the data by hand is quite cumbersome.

Is there a way display the data but just show only the first instance for that date and last instance for the date assuming i have a parameter that is a date range?

ThanksSelect top 1 [fieldnames ...] from [Tablename] .... Order by Primary key desc

delievers the first and

Select top 1 [fieldnames ...] from [Tablename] .... Order by [Primary key] asc

delievers the last entry.|||I'm not quite sure where to put this:

Here is more information on the problem.

I have 3 group names. First is Name, second is time (Day MM/DD/YY), third is time (H:MM)

What I would like to do is for each day, calculate the maximum and minimum of the time

However when I do Minimum (Date) I get the minimum of ALL the days, and not just for that particular date.

For example, my data has 8 users, and has data for about 30 days on each user. Each day a user can have multiple activities, ranging from 8am to 6pm. All I want to calculate or see, is the first time and the last time for that particular day

Any ideas? I'm trying to create a formula using the minimum function but to no avail.|||What is the database you are using?
Post table structures, sample data and the result you want

displaying different reports based on a parameter

Hi,

I have bunch of reports that take same set of parameters. I am trying parametrize the report type so that depending on the report type selected, body should display that report when user hits "View report" button. How can I do this? Pardon me if there is an obvious solution as I am pretty new to the joys of MS Reporting Services.

Thanks a bunch.

add a subreport control and then set the sub report name using an expression