Report Parameter Selection aid fir user.

Hi,
Am curious, have a report paramater the user selects from a pull down
list that is smart enough to go to the record containing the first letter the
user types in. Is there any more intelligence we can add to this ? For
example expanding the record selection to perhaps two or three characters the
user types in.
Thanks, Steve.You can write your own custom toolbar using ASP.NET. However, you would
lose some interactive functionality like zoom.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"saustin99" <saustin99@.discussions.microsoft.com> wrote in message
news:BC425483-8FCB-4DD1-91FE-C1FF6535FC3F@.microsoft.com...
> Hi,
> Am curious, have a report paramater the user selects from a pull down
> list that is smart enough to go to the record containing the first letter
> the
> user types in. Is there any more intelligence we can add to this ? For
> example expanding the record selection to perhaps two or three characters
> the
> user types in.
> Thanks, Steve.|||Thanks for the reply Jeff ! Sounds like for this purpose it might be
overkill. Steve.
"Jeff A. Stucker" wrote:
> You can write your own custom toolbar using ASP.NET. However, you would
> lose some interactive functionality like zoom.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "saustin99" <saustin99@.discussions.microsoft.com> wrote in message
> news:BC425483-8FCB-4DD1-91FE-C1FF6535FC3F@.microsoft.com...
> > Hi,
> > Am curious, have a report paramater the user selects from a pull down
> > list that is smart enough to go to the record containing the first letter
> > the
> > user types in. Is there any more intelligence we can add to this ? For
> > example expanding the record selection to perhaps two or three characters
> > the
> > user types in.
> >
> > Thanks, Steve.
>
>

Report only showing a single record

I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
records in Table. However, the report only shows a single record/page. I
placed the fields on the report in the "Body". What am I missing here?Nevermind... Got it. It's the List item.
"Dan" wrote:
> I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?|||When you place the fields on the blank layout surface you are not using any
of the controls that know about multiple rows. You need to place either a
table control or a list control and then drag and drop onto them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:7F61EA6A-DB25-43FC-9117-84A2E7E037AA@.microsoft.com...
>I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?sql

Report Hit Counts

This is gonna be simple - but not for me!!
I need to record the number of hits each report gets from users. As a bonus,
also the parameter values passed would be usefull also.
What would be the simplist and most efficient way of achieving the above
please.
Thanks and Happy New Year
TonyThe report server automatically logs all Report Executions. Look at the
Execution Log table. More info can be found here:
http://msdn2.microsoft.com/en-us/library/ms155836.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Scott" <TonyScott@.discussions.microsoft.com> wrote in message
news:43FF9683-CA87-414F-890A-5D1F310F8E5B@.microsoft.com...
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a
> bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony|||More than what Daniel has said, there is a sample package with reports, and
SSIS package which parses the logs, moves the data into a table, and provides
about 6 reports against them... It is exactly what you need.
Look for it in the samples for SQL..
(The reports are really nice!>)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Tony Scott" wrote:
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony

Report from prcedure that return multiple recordsets

Hi there,

I am creating a report from a stored procedure that returns

multiples record sets. For an example, my stored procedure is as follows

CREATE PROCEDURE MYPROCEDURE
AS

BEGIN
SELECT * FROM TABLE1
SELECT * FROM TABLE2
SELECT * FROM TABLE3
END

Now lets say I want to create a report that will display the

result of the query no 2 (which is SELECT * FROM TABLE2 in this example). How

can I do this? Is there any way to bind the second record set to the report

dataset with out changing the stored procedure?
I will appreciate any kind of suggestions on this

Thanks
Moim

yes,

you can do this in ur procedure itself. based upon what criteria you decide which query to run, pass that criteria to procedure as a parameter, and then use if condition to run the query

|||Suresh,
Thanks for your reply. But I am sorry I dont have a chance to modify the Stored procesdure. Those are written for a legacy software and they are running good for couple of years.
So can you or any one else find me an alternate to do this?

Anyway, thanks shuresh.

Thanks
Moim|||

Moim,

Unfortunately, SSRS doesn't support multiple recordsets being returned from a stored procedure. It will use the first resultset returned only.

Can you break up your master stored proc into 3 smaller stored procs, each called by separate reports with it's own resultset?

Jarret

|||Hmmm..seems I have to do that Jarret. Anyway thanks for your reply.|||

Can you mark this one as answered so others can see that multiple recordsets aren't supported?

Thanks.

Jarret

|||Sure. Thanks|||

Thanks Jarret for the answer. I did that earlier , but couldn't get my procedure to work by passing parameters to get the resulting resultset. Insted I have created different procedures and made it to work.

I didn't know that this is a constraint with SSRS.