List availables tables: February 2012

Friday, February 24, 2012

List of al lindexes and their properties for a db

sp_helpindex gives information for a single table. Is there a way of getting the same information for all user tables in a database?You may want to use the sys.indexes catalog view.

List of accessible databases on a server

Hi All
I once saw this app that allowed you to pick a SQL server and provided your
signon details; it then displayeda list of DBs on that server which you had
access to with the provided signon.
Does anybody know how they did this? How they got the list of databases off
the server?
ThanksHi
EXEC sp_MSForEachDB "use ? select '?' as dbname, name as username from
sysusers where islogin = 1 and hasdbaccess = 1"
"Chan" <Chan@.discussions.microsoft.com> wrote in message
news:B87B3DDC-4F51-4810-959A-96CFB27E93BD@.microsoft.com...
> Hi All
> I once saw this app that allowed you to pick a SQL server and provided
> your
> signon details; it then displayeda list of DBs on that server which you
> had
> access to with the provided signon.
> Does anybody know how they did this? How they got the list of databases
> off
> the server?
> Thanks|||You could start with:
SELECT name FROM master..sysdatabases
"Chan" <Chan@.discussions.microsoft.com> wrote in message
news:B87B3DDC-4F51-4810-959A-96CFB27E93BD@.microsoft.com...
> Hi All
> I once saw this app that allowed you to pick a SQL server and provided
> your
> signon details; it then displayeda list of DBs on that server which you
> had
> access to with the provided signon.
> Does anybody know how they did this? How they got the list of databases
> off
> the server?
> Thanks

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....
One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....
|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager
|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

List NT-User-Names in Active Directory (for SQL-Logins creation)

Hi there
I got - maybe a simple problem. A customer runs Active Directory Structure,
I've to implement a Application internal Security. That for, I have to list
all NT-Accounts of the Domain for the Adminstrator to select as a SQL Login.
In the SQL-Enterprise Mana
ger, if you add a new Login a dialog box appears, in which you can choose th
e Domain and the listed -NT-User (Group or User). Exactly this Dialog box I'
ve to rebuilt in the App. To find the Domain wasn't any problem, but to list
all Users and Groups, I do
n't figured out yet. Does anybody know how-to? Or is there a SP or FN wich I
didn't know ?
Many thanks for your helpSetup a linked server and use openquery, see if this link helps -
http://msdn.microsoft.com/library/d...r />
_94fn.asp
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Bruno" <anonymous@.discussions.microsoft.com> wrote in message
news:77CAFCCF-5A89-4757-8310-2A004C58D60A@.microsoft.com...
> Hi there
> I got - maybe a simple problem. A customer runs Active Directory
Structure, I've to implement a Application internal Security. That for, I
have to list all NT-Accounts of the Domain for the Adminstrator to select as
a SQL Login. In the SQL-Enterprise Manager, if you add a new Login a dialog
box appears, in which you can choose the Domain and the listed -NT-User
(Group or User). Exactly this Dialog box I've to rebuilt in the App. To find
the Domain wasn't any problem, but to list all Users and Groups, I don't
figured out yet. Does anybody know how-to? Or is there a SP or FN wich I
didn't know ?
> Many thanks for your help|||Dear Ray
Many thanks for your hint. It was not exactly what I searched for (cause OU'
s are here very dynamic, and I've to have all Users) but it gives the necess
ary hint to succeeed in my investigations.
Best Regards,
Bruno

List inside a List...

I need to create a List inside a List in the designer, but I am runninginto a lot of issues. The main problem is that I dont know what Imdoing and I dont have any kind of tutorial or model to follow. Doesanybody know of any links to any tutorials on creating lists and listsinside lists in Reporting Services? I am consulting Google as well...
Hi,
Why don't you use subreports. I believe it will be easier.
Eralper

|||

I have used Lists in Lists for a bunch of reports, and used them for drill down and grouping and everything, its GREAT! Just drag out a list control, hook it up to a dataset, edit the details grouping and there ya have it, a list grouped on an expression, like dates or usernames, then open that list up a bit, drag a new list inside, set its properties, maybe edit the detail grouping, making sure to name it something different than list1_details_group or whatever, then you can control through the properties the visibility of the list to give you a drill down feel, it should be fairly simple. If you want an example I could send you a little something.

List in order

Say I have a table with the following files in them but not sorted and I
wanted to sort them in order like these based on the timestamp part of it.
How can I do so ?
DB1_tlog_200503122235.TRN
DB1_tlog_200503122240.TRN
DB1_tlog_200503122245.TRN
DB1_tlog_200503122250.TRN
DB1_tlog_200503122255.TRN
DB1_tlog_200503122300.TRN
DB1_tlog_200503122305.TRN
DB1_tlog_200503122310.TRN
DB1_tlog_200503122315.TRN
I think we need to find the datetime portion and that would be before the
".trn" and after the "_tlog_"
And then be able to sort the string "200503122235" which represents
2005-03-12 22:35 .. How can I do this ?
ThanksHassan
drop table #tEST
CREATE TABLE #Test
(
col VARCHAR(50) NOT NULL
)
INSERT INTO #Test VALUES ('200503122235')
INSERT INTO #Test VALUES ('200503122138')
INSERT INTO #Test VALUES ('200503121845')
INSERT INTO #Test VALUES ('200503122125')
INSERT INTO #Test VALUES ('200503122030')
INSERT INTO #Test VALUES ('200503122430')
SELECT *
FROM #Test
ORDER BY CONVERT(DATETIME,LEFT(col,4)+SUBSTRING(c
ol,5,2)+
SUBSTRING(col,8,2)+'
'+REPLACE(SUBSTRING(col,9,2),'24','00')+
':'+SUBSTRING(col,11,2) ,112)
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u1$UWDGKFHA.2796@.tk2msftngp13.phx.gbl...
> Say I have a table with the following files in them but not sorted and I
> wanted to sort them in order like these based on the timestamp part of it.
> How can I do so ?
> DB1_tlog_200503122235.TRN
> DB1_tlog_200503122240.TRN
> DB1_tlog_200503122245.TRN
> DB1_tlog_200503122250.TRN
> DB1_tlog_200503122255.TRN
> DB1_tlog_200503122300.TRN
> DB1_tlog_200503122305.TRN
> DB1_tlog_200503122310.TRN
> DB1_tlog_200503122315.TRN
> I think we need to find the datetime portion and that would be before the
> ".trn" and after the "_tlog_"
> And then be able to sort the string "200503122235" which represents
> 2005-03-12 22:35 .. How can I do this ?
> Thanks
>|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u1$UWDGKFHA.2796@.tk2msftngp13.phx.gbl...
> Say I have a table with the following files in them but not sorted and I
> wanted to sort them in order like these based on the timestamp part of it.
> How can I do so ?
> DB1_tlog_200503122235.TRN
> DB1_tlog_200503122240.TRN
> DB1_tlog_200503122245.TRN
> DB1_tlog_200503122250.TRN
> DB1_tlog_200503122255.TRN
> DB1_tlog_200503122300.TRN
> DB1_tlog_200503122305.TRN
> DB1_tlog_200503122310.TRN
> DB1_tlog_200503122315.TRN
> I think we need to find the datetime portion and that would be before the
> ".trn" and after the "_tlog_"
> And then be able to sort the string "200503122235" which represents
> 2005-03-12 22:35 .. How can I do this ?
If all of the filenames have the same prefix and extension, and all use the
above format for the date/time part, then it's simply a case of ordering the
results by that column. The date/time formatting is already fine for
sorting, so there's no need to convert it to a real date/time.
Dan

List in list?

Hello everybody,

I am new to the whole reporting World and I was wondering if their is a solution for my problem. I searched for one and a half hour and I am getting desperate.

I need to repeat a report. So I thought: I can use a list for that. But when I placed all my objects in that list and linked it to a data source it gives an error at every object. I had this problem before and I made a work around so I did not solve it. I need a list in a list or a matrix in a list. I get the following errors:

Error 1 [rsDataRegionInDetailList] The list ‘list3’ is in a list that has no group expressions defined for it. To use a data region in a list, the list must have group expressions. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0

Error 2 [rsFieldReference] The Value expression for the textbox ‘textbox16’ refers to the field ‘USERNAME’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0

I hope you can help me, thanks in advance!

Yours,

Stef

I found the soluition!

I had to use a subreport

List Header on every page

Hi gurus

I have a detail list and group is made on State field what i want to do is to repeat state name on every page. I cant use table i have to do it with with the list control. i have tried placing state name in page header by referencing the field in list but it doesnt show up if group spans multiple pages.

In short how could i repeat list group element on every page. I know in tables group headers have property Repeat On New Page but its not the case with list control. guys please help me out.

Thanx in advance

Quick reply is appreciated

Regards Saud

I just saw this post on Chris Hays's weblog and I think it may describe what you are looking for:

http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx

- Eva

List grouping

I am needed assistance with getting multiple datasets data in one LIST.
I have 1 parent table with 2 child tables.
The parent table contains the primary key for the 2 child tables.
This is a 1 to many relationship to both the child tables where 1 child
table could have 5 records and the other could have 15.
I need data from the parent as well.
I am having a hard time getting this data grouped on the ID when trying to
nest a list inside a list. It does not seem to work.
Any suggestions?
--
<moojjoo/>Hi
I am not sure I understand the requirement but if it is grouping you
are after , why not use a stored procedure to shape your dataset so
that the parent and child ids are returned together. That way you will
not need multiple lists.
Cheers
Shai
On Nov 30, 1:25 am, Moojjoo <Mooj...@.discussions.microsoft.com> wrote:
> I am needed assistance with getting multiple datasets data in one LIST.
> I have 1 parent table with 2 child tables.
> The parent table contains the primary key for the 2 child tables.
> This is a 1 to many relationship to both the child tables where 1 child
> table could have 5 records and the other could have 15.
> I need data from the parent as well.
> I am having a hard time getting this data grouped on the ID when trying to
> nest a list inside a list. It does not seem to work.
> Any suggestions?
> --
> <moojjoo/>|||Shaikat,
I got it to work using Subreports. Pretty cool solution and I believe that
is the right way to do it, but remember there is always more then one way to
skin a cat. Or program as we all know.
I basically had an ID = RaID (Parent) in table "Risk Assessment"
With two other child tables called - "Control Gap" and "Mitigation Control"
both with the foreign key of RaID.
Now there could have been 20 Control Gaps and 2 Mitigation Controls related
to that RaID foreign key plus i was pulling data from the parent table hence
using joins to return all the data, but as you kow repeating rows were be
returned.
So to solve the problem I basically passed the RaID from the SSRS LIST to 2
sub reports as parameters to only return the data based on the RaId and that
way the data would return properly. I read a number of articles and learned
this was the best way to do this since the control gap data and mitigating
data were both sub data of the Parent table.
I am what you would call a high novice to SQL Server and walking with
Reporting services.
I was wondering are there issues with having numerous datasets for reports.
I have yet to see a performance issue. I have based all my datasets from
stored proces and every thing is running great.
My training - reading books and hacking away for 10 years with Microsoft
Products. Thank you Microsoft for helping me earn a pay check. Maybe one
day I will make it as an MVP.
--
<moojjoo/>
"shaikat.das@.gmail.com" wrote:
> Hi
> I am not sure I understand the requirement but if it is grouping you
> are after , why not use a stored procedure to shape your dataset so
> that the parent and child ids are returned together. That way you will
> not need multiple lists.
> Cheers
> Shai
> On Nov 30, 1:25 am, Moojjoo <Mooj...@.discussions.microsoft.com> wrote:
> > I am needed assistance with getting multiple datasets data in one LIST.
> >
> > I have 1 parent table with 2 child tables.
> >
> > The parent table contains the primary key for the 2 child tables.
> >
> > This is a 1 to many relationship to both the child tables where 1 child
> > table could have 5 records and the other could have 15.
> >
> > I need data from the parent as well.
> >
> > I am having a hard time getting this data grouped on the ID when trying to
> > nest a list inside a list. It does not seem to work.
> >
> > Any suggestions?
> >
> > --
> > <moojjoo/>
>|||Glad to see you found a solution :-)
Cheers
Shai

List from three tables

HI I have three tables as here:

inventory
isbn, status, status_date, quantity

authors
id, first_name, family_name

books
isbn, category, title, num_pages, price, copyright, author1, author2, author3

How can I list title and author name of the book that is most in stock?

My another problem to

Listing names of authors who have not written ay books

Thanks folks!!!these are homework questions, and we do not do homework on this site

however, we would be happy to help you if you have any difficulty

try the queries yourself, and show us the results or any error messages|||No this is not HW question...

I have just simplified my problem to get help faster but seems like wasnt the right way to do it.

Anyways thank you.|||well, if it is not a homework question, then you won't mind trying the queries yourself and showing us what you came up with, right?|||In any case, read the sticky at the top of the board, and post what it asks for...I'm tired of typing

List Filtering NOT Working

I have a Report where i want to show in a DataList only those values Filtered by one of the fields of my dataset. I want to show a Date value ONLY if another column value in that row in my dataset = "IN".

But nothing seems to happen here. No records are shown. It's like the condition is never true.

Steps:

1. I drag a DataList

2. I drag a DatasetField inside the DataList (automatically creates a textbox)

3. Right Click on the Datalist, Properties, then Filter Tab

I use the following statement on the Filter tab

=Cstr(Fields!TransactionType.Value) Like "IN"

=Cstr(Fields!TransactionType.Value) = "IN"

it doesnt work at all.

Does anyone knows what's going on?

Thanks

Jose

I've noticed that in filtering sometimes, in fact in most cases, I have to explicitly cast each side to the correct data type. So in your case

Expression: Operator: Value:

=Cstr(Fields!TransactionType.Value) = = Cstr("IN")

Hope this helps.

|||

PERFECTLY FINE

THANK YOU

list existing replication's settings

Hi experts,
I wish to document the replication settings on our
environment, is there a good way to list the settings on
the system ?
regards,
Diana.
Diana,
there are loads of sps to help with documentation:
sp_helpdistpublisher
sp_helpdistributor
sp_helppublication
sp_helpsubscription
to name but a few. Many of them take parameters, so you can't run them
without first configuring.
I personally do things in a less sophisticated way - I right-click the
replication folder and select "Generate SQL script..." which is then placed
in Sourcesafe.
You could also do this in SQLDMO, but IMO the simplest and quickest way
would be to have EM create the script as above.
HTH,
Paul Ibison
|||sp_helppublication provides much of the information you are looking for.
I also find it helpful to script out my replication jobs. Here is an example
of such a script.
set objServer=CreateObject("SQLDMO.SQLServer")
objServer.LoginSecure=True
objServer.Connect "Publisher"
objServer.Replication.Script 1024,"c:\sqlout.sql"
set objServer=Nothing
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Diana" <yuendiana@.sinaman.com> wrote in message
news:261301c47dfb$d68d8a40$a301280a@.phx.gbl...
> Hi experts,
> I wish to document the replication settings on our
> environment, is there a good way to list the settings on
> the system ?
> regards,
> Diana.

List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system table
Hi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>

List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system tableHi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>

List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system tableHi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>

List Dates Between Min & Max Dates

I'm trying to find a way to list the dates (XXXX-XX-XX) between a Min & Max
Dates
Example.
Min Date: 1/1/2005
Max Date: 5/1/2005
Dates between would be 2/1/2005,3/1/2005,4/1/2005
Please advise and thanks for your help.
GalahadThat's an interesting call. Here is my solution.
The idea is to get a list of sequential numbers: 1, 2, 3, ... To generate r
ows, I choose sys.all_columns view because it has probably the most number o
f rows (5000+ in a small database). This could be a weak point, but should s
atisfy normal business requirements.
select top(datediff(d,'2/1/2006','2/10/2006')+1)
cast('2/1/2006' as datetime)+
(select count(*) from sys.all_columns b where b.object_id*cast(1000 as bigin
t)+b.column_id<=a.object_id*cast(1000 as bigint)+a.column_id) - 1 val
from sys.all_columns a order by object_id, column_id
If you want only the first day of the month, it shouldn't be hard to accompl
ish with the same idea.
To get a comma delimited list, use the list() function I discussed about in
another thread:
select dbo.list(convert(char(10),val,101)) from ([The SQL Above]) tbl
"Galahad" <Galahad@.discussions.microsoft.com> wrote in message news:4339C758-529D-415C-BD23
-9C0F70EE1366@.microsoft.com...
> I'm trying to find a way to list the dates (XXXX-XX-XX) between a Min & Ma
x
> Dates
>
> Example.
>
> Min Date: 1/1/2005
> Max Date: 5/1/2005
>
> Dates between would be 2/1/2005,3/1/2005,4/1/2005
>
> Please advise and thanks for your help.
>
> Galahad|||http://www.aspfaq.com/show.asp?id=2519
"Galahad" <Galahad@.discussions.microsoft.com> wrote in message
news:4339C758-529D-415C-BD23-9C0F70EE1366@.microsoft.com...
> I'm trying to find a way to list the dates (XXXX-XX-XX) between a Min &
> Max
> Dates
> Example.
> Min Date: 1/1/2005
> Max Date: 5/1/2005
> Dates between would be 2/1/2005,3/1/2005,4/1/2005
> Please advise and thanks for your help.
> Galahad|||The callendar table is a brilliant solution:
http://www.aspfaq.com/show.asp?id=2519
Of course datatime is not the only data type that can be used.
Don't forget to thank the guys at aspfaq (http://www.aspfaq.com/credits.asp)
.
ML
http://milambda.blogspot.com/

List databases and size of an instance or sql server

Hi all
I looking the way to list the all the databases in a server and get other
properites such the size of each one.
The list of the databases of are in the master databaes, select name from
sysdatabases, but the other properties are inside on each databes (size,
last backup...) How i can use the select like a variable to connect to the
rest of the databases in the server o instance?
Best Regards
FernandoHi,
Execute the below system procedure from query analyzer:-
sp_helpdb
Thanks
Hari
SQL Server mvp
"Nano" <Nano@.discussions.microsoft.com> wrote in message
news:86D15A09-972A-4D12-8893-D3FE79C4FCFC@.microsoft.com...
> Hi all
> I looking the way to list the all the databases in a server and get other
> properites such the size of each one.
> The list of the databases of are in the master databaes, select name from
> sysdatabases, but the other properties are inside on each databes (size,
> last backup...) How i can use the select like a variable to connect to the
> rest of the databases in the server o instance?
> Best Regards
> Fernando

List database users & login

In SQL Server 2000, we can expand the console to "Database
\<database_name>\Users" and view the db user and the associated login
(detail view). But in SQL Server 2005, expanding the console "Database
\<database_name>\Security\Users", we can only see the db users and the
created date (detail view). I have to view the properties of user in
order to see the login associated to it.
Is that any way to list down all the database users and the associated
login for a particular database?
Thanks.
wodoy.peter
Hello,
For SQL 2005, In the SQL Server Management Studio -- Expand Security --
Logins --In the Right side pane--
Double clieck the login and choose user mapping. This will show the database
user mapping for all databases.
Thanks
Hari
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegrou ps.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>
|||You can say exec <dbname>.dbo.sp_helpuser from query analyser for any
database.
thks,
Manikanth S
MCDBA
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegrou ps.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>

List database users & login

In SQL Server 2000, we can expand the console to "Database
\<database_name>\Users" and view the db user and the associated login
(detail view). But in SQL Server 2005, expanding the console "Database
\<database_name>\Security\Users", we can only see the db users and the
created date (detail view). I have to view the properties of user in
order to see the login associated to it.
Is that any way to list down all the database users and the associated
login for a particular database?
Thanks.
wodoy.peterHello,
For SQL 2005, In the SQL Server Management Studio -- Expand Security --
Logins --In the Right side pane--
Double clieck the login and choose user mapping. This will show the database
user mapping for all databases.
Thanks
Hari
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegroups.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>|||You can say exec <dbname>.dbo.sp_helpuser from query analyser for any
database.
thks,
Manikanth S
MCDBA
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegroups.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>

List database users & login

In SQL Server 2000, we can expand the console to "Database
\<database_name>\Users" and view the db user and the associated login
(detail view). But in SQL Server 2005, expanding the console "Database
\<database_name>\Security\Users", we can only see the db users and the
created date (detail view). I have to view the properties of user in
order to see the login associated to it.
Is that any way to list down all the database users and the associated
login for a particular database?
Thanks.
wodoy.peterHello,
For SQL 2005, In the SQL Server Management Studio -- Expand Security --
Logins --In the Right side pane--
Double clieck the login and choose user mapping. This will show the database
user mapping for all databases.
Thanks
Hari
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegroups.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>|||You can say exec <dbname>.dbo.sp_helpuser from query analyser for any
database.
thks,
Manikanth S
MCDBA
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1169999657.108525.46980@.h3g2000cwc.googlegroups.com...
> In SQL Server 2000, we can expand the console to "Database
> \<database_name>\Users" and view the db user and the associated login
> (detail view). But in SQL Server 2005, expanding the console "Database
> \<database_name>\Security\Users", we can only see the db users and the
> created date (detail view). I have to view the properties of user in
> order to see the login associated to it.
> Is that any way to list down all the database users and the associated
> login for a particular database?
> Thanks.
>
> wodoy.peter
>

List Database ownership

Is there a way to list the owners of all databases? Right clicking in Ent
Manager and selecting properites is TOO time consuming!
select name,suser_sname(sid) as 'owner'
from master.dbo.sysdatabases
However, if databases are restored/attached you might not get a match for
suser_sname(sid)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
> Is there a way to list the owners of all databases? Right clicking in Ent
> Manager and selecting properites is TOO time consuming!
|||Thank you Jasper!
"Jasper Smith" wrote:

> select name,suser_sname(sid) as 'owner'
> from master.dbo.sysdatabases
> However, if databases are restored/attached you might not get a match for
> suser_sname(sid)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
> news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
>
>

List Database ownership

Is there a way to list the owners of all databases? Right clicking in Ent
Manager and selecting properites is TOO time consuming!select name,suser_sname(sid) as 'owner'
from master.dbo.sysdatabases
However, if databases are restored/attached you might not get a match for
suser_sname(sid)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
> Is there a way to list the owners of all databases? Right clicking in Ent
> Manager and selecting properites is TOO time consuming!|||Thank you Jasper!
"Jasper Smith" wrote:

> select name,suser_sname(sid) as 'owner'
> from master.dbo.sysdatabases
> However, if databases are restored/attached you might not get a match for
> suser_sname(sid)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
> news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
>
>

List Database ownership

Is there a way to list the owners of all databases? Right clicking in Ent
Manager and selecting properites is TOO time consuming!select name,suser_sname(sid) as 'owner'
from master.dbo.sysdatabases
However, if databases are restored/attached you might not get a match for
suser_sname(sid)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
> Is there a way to list the owners of all databases? Right clicking in Ent
> Manager and selecting properites is TOO time consuming!|||Thank you Jasper!
"Jasper Smith" wrote:
> select name,suser_sname(sid) as 'owner'
> from master.dbo.sysdatabases
> However, if databases are restored/attached you might not get a match for
> suser_sname(sid)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jay Griffin" <JayGriffin@.discussions.microsoft.com> wrote in message
> news:EC0435CD-9517-47E2-89F6-C98435AA815E@.microsoft.com...
> > Is there a way to list the owners of all databases? Right clicking in Ent
> > Manager and selecting properites is TOO time consuming!
>
>

List CRM entity attributes and data types

Hi,

I am using CRM 3.0 and have a requirement to list all the the tables, attributes names and display names and datatypes. Is there any easy way to export this information from the CRM tool or prepare a SQL query that will list the information?

You are kind of in the wrong neck of the woods, but I will try to give you a bit of help (there is a page here to go to the Microsoft Dynamics newsgroups http://www.microsoft.com/dynamics/community/newsgrouplanding.mspx)

Most of this information is available in the METABASE database in the entity and attribute tables. Not 100% sure if the display names are exactly right. They might actually be maintained in an ugly XML document.

|||Use CRM Meta Webservices. You can use the CRM SDK to get info on methods that would do this.

List control visible

I want my list control only be visible if there is data. So, in my report I
have several list controls, one of the list controls shows alias data for a
customer. If the customer has no alias data then I don't want the alias list
control to show. In the alias list control I have several textboxes.
In the list properties, visibility tab, I set the expression to
"=IIf(Fields!IndAliasID.Value > 0, true, false)" but the list control always
shows, even if the IndAliasID is null or zero.Hello Mike,
Based on my test, I was not able to reproduce the issue. Please note when
the expression is =true, the list item is hidden. When it is =false, it is
shown. You may test to see if it make any difference
=IIf(Fields!IndAliasID.Value = 0 or Fields!IndAliasID.Value is nothing,
true, false)
Also, the visiblity is for the item of list. If there is any item in the
list are >0, the list shall be visible with the items.
If you have any update, please feel free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I figured it out on my own. This post is no longer required.
Thank you for responding.
"Peter Yang [MSFT]" wrote:
> Hello Mike,
> Based on my test, I was not able to reproduce the issue. Please note when
> the expression is =true, the list item is hidden. When it is =false, it is
> shown. You may test to see if it make any difference
> =IIf(Fields!IndAliasID.Value = 0 or Fields!IndAliasID.Value is nothing,
> true, false)
> Also, the visiblity is for the item of list. If there is any item in the
> list are >0, the list shall be visible with the items.
> If you have any update, please feel free to let's know. Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

List Control Properties

I saw this posting below, and I just want to be clear. I have a data
set with one Column, but many rows. I would like the data to display
horizontaly, then wrap to the next line. My data is actually displayed
in through Image controls. Im pulling the images from an external
path, on the web (http://hostname/images/image.jpg)
Am I understanding correctly, I cannot do that? Is there another
control that I can use instead? If there is can someone point me in
the direction on the properties I need to use?
Thanks,
rwiethorn
*************************************************************
From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
Subject: Re: List Control Shortcomings?
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Date: 2004-05-31 12:29:15 PST
No. You can make the entire report multiple columns but you can't make
a
list repeat horizontally.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> I have a data set bound to a list control. Is there any way to configure the list control to output horizontally aswell as vertially?
>
> e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5 in
another column.
----http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0407301045.6cd21b18@.posting.google.com...
> I saw this posting below, and I just want to be clear. I have a data
> set with one Column, but many rows. I would like the data to display
> horizontaly, then wrap to the next line. My data is actually displayed
> in through Image controls. Im pulling the images from an external
> path, on the web (http://hostname/images/image.jpg)
> Am I understanding correctly, I cannot do that? Is there another
> control that I can use instead? If there is can someone point me in
> the direction on the properties I need to use?
> Thanks,
> rwiethorn
> *************************************************************
> From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
> Subject: Re: List Control Shortcomings?
> View: Complete Thread (2 articles)
> Original Format
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Date: 2004-05-31 12:29:15 PST
>
> No. You can make the entire report multiple columns but you can't make
> a
> list repeat horizontally.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Mark" <anonymous@.discussions.microsoft.com> wrote in message
> news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> > I have a data set bound to a list control. Is there any way to configure
the list control to output horizontally aswell as vertially?
> >
> > e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5
in
> another column.
>
> ----
--

List control and pdf export issues

I have created a report that contained a subreport that was databound inside a table but I was getting errors when I export to excel - "Subreports within table/matrix cells are ignored".

So I changed my report to bind the subreport to a list control instead of a table and it exports to excel fine but I now have new issues:

1) When I export to pdf it seems to ignore width and height properties, creating a blank page every other page (because it thinks the list control is wider than the page), and it also overlaps other elements below the list control.

2) I also seems to have lost the paging in the viewer control that is handled by setting the interactive height property.

Are these known limitations of the list control and pdf or do I have something wrong in the way I have set-up the report. I can provide .rdlc file samples if necessary.

Thank you

Lee Whitney

For your first issue, I guess the width of your subreport (in designer) is more than the width of the subreport control in your main report. For example, if you had used 8 inches in your subreport designer and if the width of the subreport control in your main report is only 7 inches, it will be spilled to the next page.

Hopefully this will solve your other issues as well.

Shyam

|||

I already made sure that my sub report width is less than the control width, in fact if I use the table control rather than the list control (and the widths for both controls are the same) the table control exports just fine to pdf where the list control does not. The list control seems to add a colspan=2 to the raw html though I don't know why but this seems to be my culprit though I have no idea how to get rs not to render the html in this fashion.Thanks

List control - New Page

I'm a newbie to SRS and have an easy questsion. I have a list control with a
text box and want the values in that text box to appear on a new page. I've
tried all the page break options in the list properties but nothing will
work. I've also tried creating a details group on my text box and that does
not work either. Any help would be appreciated.Found the problem. Page was too wide, and it would not display correctly in
preview mode.
"jweesies" wrote:
> I'm a newbie to SRS and have an easy questsion. I have a list control with a
> text box and want the values in that text box to appear on a new page. I've
> tried all the page break options in the list properties but nothing will
> work. I've also tried creating a details group on my text box and that does
> not work either. Any help would be appreciated.

List Control - Group Header RS2000

I need to modify a report that has a list containing other controls,
subreports..etc that can span multiple pages. How can we show a "group
header" on each page rendered withing the list? We tried moving the list
contents into a table cell but the group headers won't repeat on each page.
ThanksI have a similar situation like yours.
Did you find an answer for the question you posted?
Thanks in advance
Narayanan
"gsi" wrote:
> I need to modify a report that has a list containing other controls,
> subreports..etc that can span multiple pages. How can we show a "group
> header" on each page rendered withing the list? We tried moving the list
> contents into a table cell but the group headers won't repeat on each page.
> Thanks
>
>|||Unfortunately no. It's a bit suprising, one would think this should be a
pretty straight foward task.
"Narayanan" <Narayanan@.discussions.microsoft.com> wrote in message
news:4F5DDF64-499D-4AD3-A03C-59DF4AB4E364@.microsoft.com...
>I have a similar situation like yours.
> Did you find an answer for the question you posted?
> Thanks in advance
> Narayanan
>
> "gsi" wrote:
>> I need to modify a report that has a list containing other controls,
>> subreports..etc that can span multiple pages. How can we show a "group
>> header" on each page rendered withing the list? We tried moving the list
>> contents into a table cell but the group headers won't repeat on each
>> page.
>> Thanks
>>|||Using RS2000...
I need to modify a report that has a list containing other controls,
subreports..etc that can span multiple pages. How can we show a "group
header" on each page rendered withing the list? We tried moving the list
contents into a table cell but the group headers won't repeat on each page.
Thanks

list constraints

how can i use query analyzer to list the constraints for a given table?hi
for this u can use sp_help <tablename>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_help_304w.asp
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"mcnewsxp" wrote:
> how can i use query analyzer to list the constraints for a given table?
>
>|||Hi,
You could also query the information schema system view.
Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
where table_name='tablename'
Thanks
Hari
SQL Server MVP
"mcnewsxp" <mcourter@.mindspring.com> wrote in message
news:utbw6EElFHA.2920@.TK2MSFTNGP14.phx.gbl...
> how can i use query analyzer to list the constraints for a given table?
>

list constraints

how can i use query analyzer to list the constraints for a given table?
hi
for this u can use sp_help <tablename>
http://msdn.microsoft.com/library/de..._help_304w.asp
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"mcnewsxp" wrote:

> how can i use query analyzer to list the constraints for a given table?
>
>
|||Hi,
You could also query the information schema system view.
Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
where table_name='tablename'
Thanks
Hari
SQL Server MVP
"mcnewsxp" <mcourter@.mindspring.com> wrote in message
news:utbw6EElFHA.2920@.TK2MSFTNGP14.phx.gbl...
> how can i use query analyzer to list the constraints for a given table?
>

list constraints

how can i use query analyzer to list the constraints for a given table?hi
for this u can use sp_help <tablename>
http://msdn.microsoft.com/library/d... />
p_304w.asp
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"mcnewsxp" wrote:

> how can i use query analyzer to list the constraints for a given table?
>
>|||Hi,
You could also query the information schema system view.
Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
where table_name='tablename'
Thanks
Hari
SQL Server MVP
"mcnewsxp" <mcourter@.mindspring.com> wrote in message
news:utbw6EElFHA.2920@.TK2MSFTNGP14.phx.gbl...
> how can i use query analyzer to list the constraints for a given table?
>

List box parameters

Can some one help me. I know you can create a drop down list box for
the user to select a value from and run a report on that value.
But Ineed my drop downlist to be mulit-select. ie the user must be able
to select one or more items in the list box
I have read that some people have managaged to make this work but the
only examples i could find did not infact work. Perhaps it is possible
to modify the xml code behind the report to make the drop down list
mulit-select. Again i was not able to find anyway of doing this.
building asn asp front end to call the report is not an option for me.
Thanks for the helpThere is no way with the Report Manager to have multi-select. This will be
supported with the next version (out this year).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<Josef.Szeliga@.nrm.qld.gov.au> wrote in message
news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
> Can some one help me. I know you can create a drop down list box for
> the user to select a value from and run a report on that value.
> But Ineed my drop downlist to be mulit-select. ie the user must be able
> to select one or more items in the list box
> I have read that some people have managaged to make this work but the
> only examples i could find did not infact work. Perhaps it is possible
> to modify the xml code behind the report to make the drop down list
> mulit-select. Again i was not able to find anyway of doing this.
> building asn asp front end to call the report is not an option for me.
> Thanks for the help
>|||If this is not supported with in the Report Manager, is it supported in a
different method? If so, can an example/link be provided? If it is not
supported, then why is the 'multi-value' allowed on prompts? (I am using
Visual Studio and the June CTP)
Thanks!
"Bruce L-C [MVP]" wrote:
> There is no way with the Report Manager to have multi-select. This will be
> supported with the next version (out this year).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
> > Can some one help me. I know you can create a drop down list box for
> > the user to select a value from and run a report on that value.
> > But Ineed my drop downlist to be mulit-select. ie the user must be able
> > to select one or more items in the list box
> >
> > I have read that some people have managaged to make this work but the
> > only examples i could find did not infact work. Perhaps it is possible
> > to modify the xml code behind the report to make the drop down list
> > mulit-select. Again i was not able to find anyway of doing this.
> > building asn asp front end to call the report is not an option for me.
> >
> > Thanks for the help
> >
>
>|||As I said, this is supported with next release (RS 2005). In the June CTP
(note that this is a beta and betas are not complete by definition) the
multi-select is not working.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
> If this is not supported with in the Report Manager, is it supported in a
> different method? If so, can an example/link be provided? If it is not
> supported, then why is the 'multi-value' allowed on prompts? (I am using
> Visual Studio and the June CTP)
> Thanks!
> "Bruce L-C [MVP]" wrote:
>> There is no way with the Report Manager to have multi-select. This will
>> be
>> supported with the next version (out this year).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> > Can some one help me. I know you can create a drop down list box for
>> > the user to select a value from and run a report on that value.
>> > But Ineed my drop downlist to be mulit-select. ie the user must be able
>> > to select one or more items in the list box
>> >
>> > I have read that some people have managaged to make this work but the
>> > only examples i could find did not infact work. Perhaps it is possible
>> > to modify the xml code behind the report to make the drop down list
>> > mulit-select. Again i was not able to find anyway of doing this.
>> > building asn asp front end to call the report is not an option for me.
>> >
>> > Thanks for the help
>> >
>>|||I was just looking at the same problem and found the following in the
documentation:
[Parameters with multiple values are specified by repeating the parameter
name; for example,
http://exampleWebServerName/reportserver?/foldercontainingreports/orders®ion=east®ion=west ]
This shows some promise as a workaround using the current version. I
haven't had a chance to look into it. Any insight would be appreciated..
Reid
"Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
> If this is not supported with in the Report Manager, is it supported in a
> different method? If so, can an example/link be provided? If it is not
> supported, then why is the 'multi-value' allowed on prompts? (I am using
> Visual Studio and the June CTP)
> Thanks!
> "Bruce L-C [MVP]" wrote:
>> There is no way with the Report Manager to have multi-select. This will
>> be
>> supported with the next version (out this year).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> > Can some one help me. I know you can create a drop down list box for
>> > the user to select a value from and run a report on that value.
>> > But Ineed my drop downlist to be mulit-select. ie the user must be able
>> > to select one or more items in the list box
>> >
>> > I have read that some people have managaged to make this work but the
>> > only examples i could find did not infact work. Perhaps it is possible
>> > to modify the xml code behind the report to make the drop down list
>> > mulit-select. Again i was not able to find anyway of doing this.
>> > building asn asp front end to call the report is not an option for me.
>> >
>> > Thanks for the help
>> >
>>|||What documentation did you find that. I know for sure that multi-select
parameters do not work in RS 2000.
It has been a big deal here and discussed many times.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Reid" <warrex@.cox.net> wrote in message
news:eXBJ$p2dFHA.720@.TK2MSFTNGP15.phx.gbl...
>I was just looking at the same problem and found the following in the
>documentation:
> [Parameters with multiple values are specified by repeating the parameter
> name; for example,
> http://exampleWebServerName/reportserver?/foldercontainingreports/orders®ion=east®ion=west ]
> This shows some promise as a workaround using the current version. I
> haven't had a chance to look into it. Any insight would be appreciated..
> Reid
> "Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
> news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
>> If this is not supported with in the Report Manager, is it supported in a
>> different method? If so, can an example/link be provided? If it is not
>> supported, then why is the 'multi-value' allowed on prompts? (I am using
>> Visual Studio and the June CTP)
>> Thanks!
>> "Bruce L-C [MVP]" wrote:
>> There is no way with the Report Manager to have multi-select. This will
>> be
>> supported with the next version (out this year).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> > Can some one help me. I know you can create a drop down list box for
>> > the user to select a value from and run a report on that value.
>> > But Ineed my drop downlist to be mulit-select. ie the user must be
>> > able
>> > to select one or more items in the list box
>> >
>> > I have read that some people have managaged to make this work but the
>> > only examples i could find did not infact work. Perhaps it is
>> > possible
>> > to modify the xml code behind the report to make the drop down list
>> > mulit-select. Again i was not able to find anyway of doing this.
>> > building asn asp front end to call the report is not an option for me.
>> >
>> > Thanks for the help
>> >
>>
>|||Reid,
Where did you find the original doc?
Thanks!
"Reid" wrote:
> I was just looking at the same problem and found the following in the
> documentation:
> [Parameters with multiple values are specified by repeating the parameter
> name; for example,
> http://exampleWebServerName/reportserver?/foldercontainingreports/ordersÂ®ion=eastÂ®ion=west ]
> This shows some promise as a workaround using the current version. I
> haven't had a chance to look into it. Any insight would be appreciated..
> Reid
> "Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
> news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
> > If this is not supported with in the Report Manager, is it supported in a
> > different method? If so, can an example/link be provided? If it is not
> > supported, then why is the 'multi-value' allowed on prompts? (I am using
> > Visual Studio and the June CTP)
> >
> > Thanks!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is no way with the Report Manager to have multi-select. This will
> >> be
> >> supported with the next version (out this year).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
> >> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
> >> > Can some one help me. I know you can create a drop down list box for
> >> > the user to select a value from and run a report on that value.
> >> > But Ineed my drop downlist to be mulit-select. ie the user must be able
> >> > to select one or more items in the list box
> >> >
> >> > I have read that some people have managaged to make this work but the
> >> > only examples i could find did not infact work. Perhaps it is possible
> >> > to modify the xml code behind the report to make the drop down list
> >> > mulit-select. Again i was not able to find anyway of doing this.
> >> > building asn asp front end to call the report is not an option for me.
> >> >
> >> > Thanks for the help
> >> >
> >>
> >>
> >>
>
>|||Reporting Services Books Online - Running a Parameterized Report
I did a search on "multiple values" (no quotes) and it came up 3rd in the
list.
I'm testing the feature, but it doesn't seem to work
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OBxGaz2dFHA.584@.TK2MSFTNGP15.phx.gbl...
> What documentation did you find that. I know for sure that multi-select
> parameters do not work in RS 2000.
> It has been a big deal here and discussed many times.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Reid" <warrex@.cox.net> wrote in message
> news:eXBJ$p2dFHA.720@.TK2MSFTNGP15.phx.gbl...
>>I was just looking at the same problem and found the following in the
>>documentation:
>> [Parameters with multiple values are specified by repeating the parameter
>> name; for example,
>> http://exampleWebServerName/reportserver?/foldercontainingreports/orders®ion=east®ion=west ]
>> This shows some promise as a workaround using the current version. I
>> haven't had a chance to look into it. Any insight would be appreciated..
>> Reid
>> "Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
>> news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
>> If this is not supported with in the Report Manager, is it supported in
>> a
>> different method? If so, can an example/link be provided? If it is not
>> supported, then why is the 'multi-value' allowed on prompts? (I am
>> using
>> Visual Studio and the June CTP)
>> Thanks!
>> "Bruce L-C [MVP]" wrote:
>> There is no way with the Report Manager to have multi-select. This will
>> be
>> supported with the next version (out this year).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> > Can some one help me. I know you can create a drop down list box for
>> > the user to select a value from and run a report on that value.
>> > But Ineed my drop downlist to be mulit-select. ie the user must be
>> > able
>> > to select one or more items in the list box
>> >
>> > I have read that some people have managaged to make this work but the
>> > only examples i could find did not infact work. Perhaps it is
>> > possible
>> > to modify the xml code behind the report to make the drop down list
>> > mulit-select. Again i was not able to find anyway of doing this.
>> > building asn asp front end to call the report is not an option for
>> > me.
>> >
>> > Thanks for the help
>> >
>>
>>
>|||Hmm. The books online (RS 2000) I have installed does not have anything like
that.
"Reid" <warrex@.cox.net> wrote in message
news:%2324J0W3dFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Reporting Services Books Online - Running a Parameterized Report
> I did a search on "multiple values" (no quotes) and it came up 3rd in the
> list.
> I'm testing the feature, but it doesn't seem to work
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OBxGaz2dFHA.584@.TK2MSFTNGP15.phx.gbl...
>> What documentation did you find that. I know for sure that multi-select
>> parameters do not work in RS 2000.
>> It has been a big deal here and discussed many times.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Reid" <warrex@.cox.net> wrote in message
>> news:eXBJ$p2dFHA.720@.TK2MSFTNGP15.phx.gbl...
>>I was just looking at the same problem and found the following in the
>>documentation:
>> [Parameters with multiple values are specified by repeating the
>> parameter name; for example,
>> http://exampleWebServerName/reportserver?/foldercontainingreports/orders®ion=east®ion=west ]
>> This shows some promise as a workaround using the current version. I
>> haven't had a chance to look into it. Any insight would be
>> appreciated..
>> Reid
>> "Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
>> news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
>> If this is not supported with in the Report Manager, is it supported in
>> a
>> different method? If so, can an example/link be provided? If it is
>> not
>> supported, then why is the 'multi-value' allowed on prompts? (I am
>> using
>> Visual Studio and the June CTP)
>> Thanks!
>> "Bruce L-C [MVP]" wrote:
>> There is no way with the Report Manager to have multi-select. This
>> will be
>> supported with the next version (out this year).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> > Can some one help me. I know you can create a drop down list box for
>> > the user to select a value from and run a report on that value.
>> > But Ineed my drop downlist to be mulit-select. ie the user must be
>> > able
>> > to select one or more items in the list box
>> >
>> > I have read that some people have managaged to make this work but
>> > the
>> > only examples i could find did not infact work. Perhaps it is
>> > possible
>> > to modify the xml code behind the report to make the drop down list
>> > mulit-select. Again i was not able to find anyway of doing this.
>> > building asn asp front end to call the report is not an option for
>> > me.
>> >
>> > Thanks for the help
>> >
>>
>>
>>
>|||I've been through several updates since last Summer, including the SP2 beta.
I don't know if that updated the help files or not. The only help file
version for books online I can find is on the about box, v8.01, but that's
probably the books online software, not the reporting services helpfile.
Also there are 35 help files in the MSSQL\Reporting Services\Help\1033
folder. The file version for the .hxs files (first 2 at least) is 9.0.0.1.
The feature doesn't seem to work yet. If there's a "sweet" combination of
parameter definitions and url syntax and sql query parameter specification
that works, I didn't stumble across it. I guess we'll have to wait for the
next release.
"Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
news:0841F61A-F513-4A32-A970-09E5213765DB@.microsoft.com...
> Reid,
> Where did you find the original doc?
> Thanks!
>
> "Reid" wrote:
>> I was just looking at the same problem and found the following in the
>> documentation:
>> [Parameters with multiple values are specified by repeating the parameter
>> name; for example,
>> http://exampleWebServerName/reportserver?/foldercontainingreports/orders®ion=east®ion=west ]
>> This shows some promise as a workaround using the current version. I
>> haven't had a chance to look into it. Any insight would be appreciated..
>> Reid
>> "Borris Clash" <BorrisClash@.discussions.microsoft.com> wrote in message
>> news:878012D9-AE3F-4BB4-BD3A-D9AA3B1C2F23@.microsoft.com...
>> > If this is not supported with in the Report Manager, is it supported in
>> > a
>> > different method? If so, can an example/link be provided? If it is
>> > not
>> > supported, then why is the 'multi-value' allowed on prompts? (I am
>> > using
>> > Visual Studio and the June CTP)
>> >
>> > Thanks!
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> There is no way with the Report Manager to have multi-select. This
>> >> will
>> >> be
>> >> supported with the next version (out this year).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <Josef.Szeliga@.nrm.qld.gov.au> wrote in message
>> >> news:1117695896.503904.161470@.g49g2000cwa.googlegroups.com...
>> >> > Can some one help me. I know you can create a drop down list box for
>> >> > the user to select a value from and run a report on that value.
>> >> > But Ineed my drop downlist to be mulit-select. ie the user must be
>> >> > able
>> >> > to select one or more items in the list box
>> >> >
>> >> > I have read that some people have managaged to make this work but
>> >> > the
>> >> > only examples i could find did not infact work. Perhaps it is
>> >> > possible
>> >> > to modify the xml code behind the report to make the drop down list
>> >> > mulit-select. Again i was not able to find anyway of doing this.
>> >> > building asn asp front end to call the report is not an option for
>> >> > me.
>> >> >
>> >> > Thanks for the help
>> >> >
>> >>
>> >>
>> >>
>>|||Hi,
I am new to RS and the very first project that I had to implement was to
enhance a report which was taking a single param into multi value(not
multiple parameters). I bought 3 books and all were useless. I designed the
application and it works absolutely marvellous..
I will be posting the details by COB today so that everybody can see how it
works..
"Josef.Szeliga@.nrm.qld.gov.au" wrote:
> Can some one help me. I know you can create a drop down list box for
> the user to select a value from and run a report on that value.
> But Ineed my drop downlist to be mulit-select. ie the user must be able
> to select one or more items in the list box
> I have read that some people have managaged to make this work but the
> only examples i could find did not infact work. Perhaps it is possible
> to modify the xml code behind the report to make the drop down list
> mulit-select. Again i was not able to find anyway of doing this.
> building asn asp front end to call the report is not an option for me.
> Thanks for the help
>

List Box Page Number

Hello,

I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".

I want to be able to place the list box number next to the question, so that I will see something like:

1. Name

2. Category

3. Age

Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.

Thanks,

Michael

Hi,

Are you using any Grouping inside the list? If you are, I believe you can get the number within each list using the following expression:

=RunningValue((<Your List Grouping Field>),CountDistinct,"DataSet1") where "DataSet1" would be the name of your dataset.

If you do not have any grouping for the list, you could try using 'question id' in the expression instead.

Hope it helps.

-Aayush

|||

Aayush,

Thank You! That was exactly what I needed! Worked like a charm!

Michael

List box page break

I have a report that I am working on that has a list box. The
properties of this list box are set to "insert a page break at the end
of this list". But it doesn't work. Also, I find that I can't put
"fields" in a page footer. I seem to remember that I can put a text
box in the footer referencing the value of a field in the body of the
report(i.e. the text box in the body references a database field and
the footer text box references the body text box value) Any
suggestions? Thanks in advance. RonI found the answer to both items. I had one field that was set to "can
grow..." I unchecked this item and set the field size to accomodate the text
that would appear. This caused my page breaks to work properly. I also found
the format to refer to a field in the report to wit:
ReportItems!textboxname.value
"Ron" wrote:
> I have a report that I am working on that has a list box. The
> properties of this list box are set to "insert a page break at the end
> of this list". But it doesn't work. Also, I find that I can't put
> "fields" in a page footer. I seem to remember that I can put a text
> box in the footer referencing the value of a field in the body of the
> report(i.e. the text box in the body references a database field and
> the footer text box references the body text box value) Any
> suggestions? Thanks in advance. Ron
>

list box is not displaying

I have a list box getting a filtered recordset from a stored procedure using ADO calling in VB6.
The recordset returns the two records with correct values. The problem is it is not displaying in the list box. Why? I tried using .additem property but it is not available in Access 2000. Can anyone help me with this?

Function ..
Dim rs_get_defect_desc As New ADODB.Recordset, lot_n as integer
Set lot_n = 4051

Rs_get_defect_desc.Open "EXEC spGet_desc_defect @.lot_n=" & lot_n, CurrentProject.Connection
Do While Not rs_get_defect_desc.EOF

lstbox.RowSource = rs_get_defect_desc(0) & " " & rs_get_defect_desc(1)
rs_get_defect_desc.MoveNext

LoopI am confused, - is it VB6 or Access?

List box and pagination issues rendering to .pdf

I have a report that is using lists. When previewed in reports services it
looks fine, but when exported to .pdf, I get extraneous unwanted blank pages.
It is NOT the margins or section sizes, I have checked all of that. It
appears to be related to the amount of data in one pas through a grouping in
the list. Yet, I have all the "keep together" options set to "false". How can
I get this report to render to .pdf properly'
thanks!Have you checked to see if any of your items are growing in width, and
pushing otherwise blank space off to the right? I'm wrestling with that on
a side-by-side matrix report right now.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>I have a report that is using lists. When previewed in reports services it
> looks fine, but when exported to .pdf, I get extraneous unwanted blank
> pages.
> It is NOT the margins or section sizes, I have checked all of that. It
> appears to be related to the amount of data in one pas through a grouping
> in
> the list. Yet, I have all the "keep together" options set to "false". How
> can
> I get this report to render to .pdf properly'
> thanks!
>|||Yes, I have checked for that. If I sort my list in a different order, I don't
have the issue so I know it has something to do with the amount of data in
one grouping of the list. None of the "keep together" options are marked
though so I can not figure out what else to look for - very frustrating!
Any other ideas anyone'
thanks!
"Jeff A. Stucker" wrote:
> Have you checked to see if any of your items are growing in width, and
> pushing otherwise blank space off to the right? I'm wrestling with that on
> a side-by-side matrix report right now.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
> >I have a report that is using lists. When previewed in reports services it
> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
> > pages.
> > It is NOT the margins or section sizes, I have checked all of that. It
> > appears to be related to the amount of data in one pas through a grouping
> > in
> > the list. Yet, I have all the "keep together" options set to "false". How
> > can
> > I get this report to render to .pdf properly'
> >
> > thanks!
> >
> >
>
>|||Are the extraneous pages at the end, or interleaved? If interleaved, then
it's from extra space on the right, otherwise from extra space at the
bottom.
If it's extra space at the bottom, I was able to hold together a couple of
items by putting them in the same rectangle or list. The pagination is a
bit squirrelly right now. I'm certainly looking forward to future
improvements!
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
> Yes, I have checked for that. If I sort my list in a different order, I
> don't
> have the issue so I know it has something to do with the amount of data in
> one grouping of the list. None of the "keep together" options are marked
> though so I can not figure out what else to look for - very frustrating!
> Any other ideas anyone'
> thanks!
>
> "Jeff A. Stucker" wrote:
>> Have you checked to see if any of your items are growing in width, and
>> pushing otherwise blank space off to the right? I'm wrestling with that
>> on
>> a side-by-side matrix report right now.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>> >I have a report that is using lists. When previewed in reports services
>> >it
>> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
>> > pages.
>> > It is NOT the margins or section sizes, I have checked all of that. It
>> > appears to be related to the amount of data in one pas through a
>> > grouping
>> > in
>> > the list. Yet, I have all the "keep together" options set to "false".
>> > How
>> > can
>> > I get this report to render to .pdf properly'
>> >
>> > thanks!
>> >
>> >
>>|||Jeff - the extra pages are "interleaved". As I mentioned, if I change the
sort order of the data, the position of the extra pages changes as well. This
is what leads me to believe that it is the amount of data in one grouping of
my list that is causing the issue and I have not been able to figure out how
to get it to fill the space and break on page size not data grouping - again,
any suggestions appreciated, my client is quite frustrated by the appearance
of some of their reports!
Martha
"Jeff A. Stucker" wrote:
> Are the extraneous pages at the end, or interleaved? If interleaved, then
> it's from extra space on the right, otherwise from extra space at the
> bottom.
> If it's extra space at the bottom, I was able to hold together a couple of
> items by putting them in the same rectangle or list. The pagination is a
> bit squirrelly right now. I'm certainly looking forward to future
> improvements!
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
> > Yes, I have checked for that. If I sort my list in a different order, I
> > don't
> > have the issue so I know it has something to do with the amount of data in
> > one grouping of the list. None of the "keep together" options are marked
> > though so I can not figure out what else to look for - very frustrating!
> >
> > Any other ideas anyone'
> >
> > thanks!
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Have you checked to see if any of your items are growing in width, and
> >> pushing otherwise blank space off to the right? I'm wrestling with that
> >> on
> >> a side-by-side matrix report right now.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> >> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
> >> >I have a report that is using lists. When previewed in reports services
> >> >it
> >> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
> >> > pages.
> >> > It is NOT the margins or section sizes, I have checked all of that. It
> >> > appears to be related to the amount of data in one pas through a
> >> > grouping
> >> > in
> >> > the list. Yet, I have all the "keep together" options set to "false".
> >> > How
> >> > can
> >> > I get this report to render to .pdf properly'
> >> >
> >> > thanks!
> >> >
> >> >
> >>
> >>
> >>
>
>|||What's happening is that some element has got extra white space that is
getting pushed off the page. If you tighten your margins at the bottom and
right of the elements, it should eliminate the page breaking. The problem
is that this will probably mess up your spacing between items on the same
page. Again, the only thing I can suggest is to find out exactly which text
box or list box or other item is causing the white space to bump off the
page, and then eliminate that space. Then, what I would do is regroup the
items that need to be on the same page inside some rectangle(s), and move
around the rectangle(s) relative to other items to fix the spacing.
Again, if you have matrixes, they may push things off to the right. Other
things may be pushing space off the bottom depending on the amount of data.
Happy sleuthing...
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:387C6CE2-B57E-40E5-A0A7-B7D82012A76B@.microsoft.com...
> Jeff - the extra pages are "interleaved". As I mentioned, if I change the
> sort order of the data, the position of the extra pages changes as well.
> This
> is what leads me to believe that it is the amount of data in one grouping
> of
> my list that is causing the issue and I have not been able to figure out
> how
> to get it to fill the space and break on page size not data grouping -
> again,
> any suggestions appreciated, my client is quite frustrated by the
> appearance
> of some of their reports!
> Martha
>
> "Jeff A. Stucker" wrote:
>> Are the extraneous pages at the end, or interleaved? If interleaved,
>> then
>> it's from extra space on the right, otherwise from extra space at the
>> bottom.
>> If it's extra space at the bottom, I was able to hold together a couple
>> of
>> items by putting them in the same rectangle or list. The pagination is
>> a
>> bit squirrelly right now. I'm certainly looking forward to future
>> improvements!
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
>> > Yes, I have checked for that. If I sort my list in a different order, I
>> > don't
>> > have the issue so I know it has something to do with the amount of data
>> > in
>> > one grouping of the list. None of the "keep together" options are
>> > marked
>> > though so I can not figure out what else to look for - very
>> > frustrating!
>> >
>> > Any other ideas anyone'
>> >
>> > thanks!
>> >
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> Have you checked to see if any of your items are growing in width, and
>> >> pushing otherwise blank space off to the right? I'm wrestling with
>> >> that
>> >> on
>> >> a side-by-side matrix report right now.
>> >>
>> >> --
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> >> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>> >> >I have a report that is using lists. When previewed in reports
>> >> >services
>> >> >it
>> >> > looks fine, but when exported to .pdf, I get extraneous unwanted
>> >> > blank
>> >> > pages.
>> >> > It is NOT the margins or section sizes, I have checked all of that.
>> >> > It
>> >> > appears to be related to the amount of data in one pas through a
>> >> > grouping
>> >> > in
>> >> > the list. Yet, I have all the "keep together" options set to
>> >> > "false".
>> >> > How
>> >> > can
>> >> > I get this report to render to .pdf properly'
>> >> >
>> >> > thanks!
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||I have the same issue with 2 reports that are using a list box. It
seems that the list box is at times trying to keep data
together...although I don't have the "fit on one page" option on. A
similar issue that I am having is that whole instances of the list box
are not showing up. I am not turning on or off the visible switch...and
the report is fine in a web page. The issue is really only when
rendering to a PDF.

Friday, February 24, 2012

Blog Archive

About Me