New to this...

Stephane

unread,

Dec 29, 2009, 10:59:01 AM12/29/09

to

Hello all,

Well I have a question for you, I am starting with Reporting Services. I
have this simple Query :
SELECT DISTINCT Name AS Category FROM Production.ProductCategory

The result when Preview the report is a ComboBox name Category with 4
different choices (Accessories, Bikes, Clothing and Components) now this is
my question.
How can I add a new choice (Skates) in the ComboBox so I can have 5
different choices.

Thanks in advance

An How-to URL will be appreciated !!!

Andrew Karcher [SQL MVP]

unread,

Dec 29, 2009, 2:21:10 PM12/29/09

to

Stephanie,

This is a Database question more than an SSRS question.
To add a new item to that list you would just need to add a new category to
the ProductCategory Table.

So you would just insert a record into that table. Depending on which
version of Adventure Works you are using. This is for 2008

INSERT INTO [AdventureWorks2008].[Production].[ProductCategory]
([Name] ,[rowguid] ,[ModifiedDate])
VALUES('Skates' ,NEWID ,CURRENT_TIMESTAMP)

That being said that will add it to the combo box, but the Adventure Works
does not have sales for that ProductCategory so no data will be returned
unless you create that data.

HTH,
Andrew Karcher
SQL Server MVP

"Stephane" <Step...@discussions.microsoft.com> wrote in message
news:81E211D3-5E3B-4338...@microsoft.com...

Stephane

unread,

Dec 30, 2009, 10:10:01 AM12/30/09

to

Good day Andrew

Thank you very much for your reply...May I ask after this how to create data
for the new ProductCategory item.

Best regards
Stef

> .
>

Stephane

unread,

Dec 30, 2009, 11:40:01 AM12/30/09

to

Hey,

Forget my last post...I did download SQL 2008 Documentation with tutorial

Regards,

Stephen

unread,

Jan 5, 2010, 4:52:53 PM1/5/10

to

Hello all,

I know i'm not in the good forum...but please read the following.
I hope you are doing great so as you can see I am new to this, and I hope
that Andrew Karcher is reading...

So from my first post I tried to insert a Category into AdventureWorks with
the help of Andrew..it works, so I can see the new Category on the "dropdown
menu".
Now as Andrew said...sales for that ProductCategory so no data will be
returned unless you create that data and he is right.
What I did is from the Dataset Parameters,I insert the Category in available
value the one that I want, and it's from a non-queried sources.
Now when I try to View report see what error message I get:

***Invalid attempt to read when no data is present***

Like Andrew said...please can anyone help me on this, or at least give me
hint to make this thing works

Thanks in advance

Best regards to all of you

Stef

"Stephane" <Step...@discussions.microsoft.com> a �crit dans le message de
news: 287010B1-5759-4400...@microsoft.com...

Andrew Karcher [SQL MVP]

unread,

Jan 6, 2010, 5:32:05 PM1/6/10

to

Stephane,

So I am confused with what you are trying to accomplish here.

If are trying to learn more about parameters, if you have not already you
might want to work through the Tutorial for Parameters.

http://msdn.microsoft.com/en-us/library/aa337432.aspx

Andrew

"Stephen" <stephan...@hotmail.com> wrote in message
news:#xwZwFlj...@TK2MSFTNGP02.phx.gbl...