Showing posts with label services. Show all posts
Showing posts with label services. Show all posts

Friday, March 30, 2012

Load Balancing SSAS Servers

Hello,

We are trying to load balance a pair of SQL Server 2005 Analysis Services query servers using hardware load balancing (Foundry switches) but we don't seem to be able to get it to work.

The main problem as far as I can tell is that we can't get the SSAS instances to listen on the IP address of the loopback adapter which is configured on both servers.

The netstat -ano command shows that the SSAS instances are only listening on the IP address of the physical NIC in each machine.

We are using a custom port and I can see where this custom port is defined in the msmdsrv.ini file but I can't see anywhere where you can tell SSAS the IP addresses on which to listen.

Should SSAS listen on all available IP addresses when it starts up ? We have re-booted both boxes but this hasn't made any difference ?

Can anyone shed some light on this please ?

Regards,

Paul Lynch

Hi Paul, I have not done anything like this before, so this is a bit of a long shot. I was wondering if the security setting that you need to change in order to use application names might need to be changed. see http://support.microsoft.com/kb/888526 - this article is for AS2000, but I think the same approach still applies for AS2k5.

I think by default it checks that the name/ip address match each other, so this may help.

|||

Hi Darren,

Thanks for your reply.

We actually found the problem - the network guy had forgotten to configure something called Direct Server Return (DSR) on the Foundry so the traffic wasn't being forwarded properly to the SSAS boxes. When I looked into it again I realised that the SSAS process was actually listening on the loopback adapter address as well as the IP address of the physical NIC so the problem wasn't what I originally thought it was.

We are now able to connect to the VIP address on the port specified in SSAS and it appears to connect OK (I can connect from the front-end web server using SQL Management Studio so I'm assuming its working)

However, the KB article you posted has got me thinking that maybe we need to configure an application name for it to work - I'll need to speak to the DBA's because I'm out of my depth with this already - I'm just an IIS guy ;-)

Thanks again.

Paul

Wednesday, March 28, 2012

load balanced scale out deployment issues

Hello,
I have a scale out deployment of Reporting Services consisting of 2 Report
Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin
mode, and the report catalog db sits on on a separate sql server. We use a
vIP with a DNS name that hits the F5. The F5, in turn, is setup to "choose"
one of the 2 Report Servers using the machine name address. Note that this
is for an intranet.
We are not currently using HTTPS (SSL) in our environment, but eventually
we'll turn it on, so ignore that piece of the puzzle for this scenario.
When configuring the scale-out deployment, we followed the instructions on
the Books Online article "Configuring a Report Server Scale-out Deployment."
The last piece of this document instructs us to modify the
RSWebApplication.config file for all the servers in the scale out deployment,
setting the <ReportServerUrl> element to use the virtual server name (vIP
DNS, we assumed), instead of the machine name. However, this element did not
contain a value originally.
The next step was to modify the RSReportServer.config file, to set the
<UrlRoot> element with the virtual server name (again, vIP dns). UrlRoot's
original value as the url <servername>/reportserver.
Once this change was made, I reset IIS on both servers, and hit each
localhost's Report manager to fire up the applications. However, I received
the following error "ReportServerUrl Configuration element is not a valid
configuration..." on both Report Manager web apps.
Note that before we made the above change to ReportServerUrl and UrlRoot,
both servers worked fine. So, I went back in and removed the value from
ReportServerUrl, but left the UrlRoot with the vIP name. Reset IIS, and the
error went away!
I am a little confused as to what these two settings are used for, since the
original value of ReportServerUrl was blank (UrlRoot actually had the machine
name address).
Could someone explain the cause of this error, and suggest a best practice
for this scenario. I would like to use the most efficient configuration
between the Report Servers and the F5 load balancer, and what other changes
would we be looking at once we turn on SSL?
Thanks!
--
Regards,
Thiago Silvabtw, this is using SSRS 2005 (Enterprise Edition, of course, since it's a web
farm).
--
Regards,
"HC" wrote:
> Hello,
> I have a scale out deployment of Reporting Services consisting of 2 Report
> Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin
> mode, and the report catalog db sits on on a separate sql server. We use a
> vIP with a DNS name that hits the F5. The F5, in turn, is setup to "choose"
> one of the 2 Report Servers using the machine name address. Note that this
> is for an intranet.
> We are not currently using HTTPS (SSL) in our environment, but eventually
> we'll turn it on, so ignore that piece of the puzzle for this scenario.
> When configuring the scale-out deployment, we followed the instructions on
> the Books Online article "Configuring a Report Server Scale-out Deployment."
> The last piece of this document instructs us to modify the
> RSWebApplication.config file for all the servers in the scale out deployment,
> setting the <ReportServerUrl> element to use the virtual server name (vIP
> DNS, we assumed), instead of the machine name. However, this element did not
> contain a value originally.
> The next step was to modify the RSReportServer.config file, to set the
> <UrlRoot> element with the virtual server name (again, vIP dns). UrlRoot's
> original value as the url <servername>/reportserver.
> Once this change was made, I reset IIS on both servers, and hit each
> localhost's Report manager to fire up the applications. However, I received
> the following error "ReportServerUrl Configuration element is not a valid
> configuration..." on both Report Manager web apps.
> Note that before we made the above change to ReportServerUrl and UrlRoot,
> both servers worked fine. So, I went back in and removed the value from
> ReportServerUrl, but left the UrlRoot with the vIP name. Reset IIS, and the
> error went away!
> I am a little confused as to what these two settings are used for, since the
> original value of ReportServerUrl was blank (UrlRoot actually had the machine
> name address).
> Could someone explain the cause of this error, and suggest a best practice
> for this scenario. I would like to use the most efficient configuration
> between the Report Servers and the F5 load balancer, and what other changes
> would we be looking at once we turn on SSL?
> Thanks!
> --
> Regards,
> Thiago Silva

Monday, March 26, 2012

Load a bitmap image into Reporting services

After scanning a document, can one load the resultant bitmap image into
Reporting services and be able to edit it.
eg. lets say a portion of the document was
Name : _______________
Surname : _______________
ID No. : _______________
Now where the underlined parts are, can one then go and edit it and Add a
field from a dataset.
The reason I ask is that I have several 20 odd page documents to create in
reporting services.
We want to automate the process whereby the users capture the neccasary data
in our application and the report is generated from this.
Now it may take forever doing this manually because will have to worry about
whether each page fits properly,
formatting and as the report gets larger the response times in Visual studio
is horrendous.
So I was just wondering if this were possible.
Or if anyone else has any other suggestions. Am using VS2005.
Thanks
SanjeevYou can put the image using image control, but not possible to edit. What you
can do is to put the document images as background and align the textbox
exactly as a entry field just next to the fields which require a value. This
way you can try, but not sure you may face some problem when you export to
different formats.
Amarnath, MCTS
"Sanjeev Rampersad" wrote:
> After scanning a document, can one load the resultant bitmap image into
> Reporting services and be able to edit it.
> eg. lets say a portion of the document was
> Name : _______________
> Surname : _______________
> ID No. : _______________
> Now where the underlined parts are, can one then go and edit it and Add a
> field from a dataset.
> The reason I ask is that I have several 20 odd page documents to create in
> reporting services.
> We want to automate the process whereby the users capture the neccasary data
> in our application and the report is generated from this.
> Now it may take forever doing this manually because will have to worry about
> whether each page fits properly,
> formatting and as the report gets larger the response times in Visual studio
> is horrendous.
> So I was just wondering if this were possible.
> Or if anyone else has any other suggestions. Am using VS2005.
> Thanks
> Sanjeev
>
>|||Thanks. Its worth a shot.Will try it as a background.
I just have to worry about exporting only to pdf..
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:853A1C5B-39F5-4EBF-BBD0-BA59F92D46D0@.microsoft.com...
> You can put the image using image control, but not possible to edit. What
> you
> can do is to put the document images as background and align the textbox
> exactly as a entry field just next to the fields which require a value.
> This
> way you can try, but not sure you may face some problem when you export to
> different formats.
> Amarnath, MCTS
>
> "Sanjeev Rampersad" wrote:
>> After scanning a document, can one load the resultant bitmap image into
>> Reporting services and be able to edit it.
>> eg. lets say a portion of the document was
>> Name : _______________
>> Surname : _______________
>> ID No. : _______________
>> Now where the underlined parts are, can one then go and edit it and Add a
>> field from a dataset.
>> The reason I ask is that I have several 20 odd page documents to create
>> in
>> reporting services.
>> We want to automate the process whereby the users capture the neccasary
>> data
>> in our application and the report is generated from this.
>> Now it may take forever doing this manually because will have to worry
>> about
>> whether each page fits properly,
>> formatting and as the report gets larger the response times in Visual
>> studio
>> is horrendous.
>> So I was just wondering if this were possible.
>> Or if anyone else has any other suggestions. Am using VS2005.
>> Thanks
>> Sanjeev
>>|||on a PDF it works perfectly ok, if you include as a background image.
Amarnath, MCTS
"Sanjeev Rampersad" wrote:
> Thanks. Its worth a shot.Will try it as a background.
> I just have to worry about exporting only to pdf..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:853A1C5B-39F5-4EBF-BBD0-BA59F92D46D0@.microsoft.com...
> > You can put the image using image control, but not possible to edit. What
> > you
> > can do is to put the document images as background and align the textbox
> > exactly as a entry field just next to the fields which require a value.
> > This
> > way you can try, but not sure you may face some problem when you export to
> > different formats.
> >
> > Amarnath, MCTS
> >
> >
> > "Sanjeev Rampersad" wrote:
> >
> >>
> >> After scanning a document, can one load the resultant bitmap image into
> >> Reporting services and be able to edit it.
> >>
> >> eg. lets say a portion of the document was
> >>
> >> Name : _______________
> >> Surname : _______________
> >> ID No. : _______________
> >>
> >> Now where the underlined parts are, can one then go and edit it and Add a
> >> field from a dataset.
> >> The reason I ask is that I have several 20 odd page documents to create
> >> in
> >> reporting services.
> >> We want to automate the process whereby the users capture the neccasary
> >> data
> >> in our application and the report is generated from this.
> >> Now it may take forever doing this manually because will have to worry
> >> about
> >> whether each page fits properly,
> >> formatting and as the report gets larger the response times in Visual
> >> studio
> >> is horrendous.
> >> So I was just wondering if this were possible.
> >> Or if anyone else has any other suggestions. Am using VS2005.
> >>
> >> Thanks
> >> Sanjeev
> >>
> >>
> >>
>
>

Friday, March 23, 2012

listingreports that user has access

How can I get the list of reports that a user has only view reports access ?
the user is in windows server 2003 active directory.
reporting services 2000 is being used.
within the intranet there is a portal.
in the portal I want to list the available reports to the user
that he can access. I do not want to display all the reports to him and let
him choose. I want him to be able to see only the reports he is allowed to
see?
how can I do this using asp.net 1.1
thanx
rifatis it possible or not?
can someone answer please ?
thanx
rifatsql

Wednesday, March 21, 2012

Listing AD group members

Hello,
I'd like to create a report in Reporting Services 2000 listing the
members of a given Active Directory group.
I found on the internet a vbs-script to retrieve the information
needed:
Set objGroup = GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
For Each objUser in objGroup.Members
Wscript.Echo "Name: " & objUser.DisplayName
Next
This script works fine.
However, I'm not very familiar with VBS-programming (and not with
custom code in Reporting Services either...)
How do I create a report that presents the result from the query?
Any help would be greatly appreciated.
WillyI've been working on a solution, but I'm stuck
In the Report Properties window on the Code tab I've entered the
following code:
Shared Function GetMembersByGroupSQL As String
Dim objGroup As Object
Dim objUser As Object
Dim strQuery As String
objGroup = GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
For Each objUser In objGroup.Members
strQuery = "SELECT Naam = '" & objUser.DisplayName & "'"
Next
Return strQuery
End Function
(I realize I have to alter the For Each construction, in the end I
need strQuery to be something like
SELECT Naam='John' UNION SELECT Naam='Mary' UNION...
For now, only the last row will be returned.)
I've created a new dataset with command type set to 'Text' and entered
the following
= Code.GetMembersByGroupSQL
I've also added a field called 'Naam'.
When I run a report based on this dataset displaying name I get the
following error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot set the command text for data set 'dsGebruikersPerGroep'.
(rsErrorSettingCommandText) Get Online Help
Error during processing of the CommandText expression of dataset
'dsGebruikersPerGroep'. (rsQueryCommandTextProcessingError) Get Online
Help
There's something wrong with my VB code, because when I replace the
existing code with the following, all works fine:
Shared Function GetMembersByGroupSQL As String
Dim strQuery As String
strQuery = "SELECT Naam = 'John'"
Return strQuery
End Function
It seems like the following line of code is the problem: objGroup =GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
I've tested the code in a vbs-script and it worked fine. Do I need to
add references to assembly's and/or classes to make it work?
Kind regards, Willy

Monday, March 19, 2012

Listbox

I'm new to MS Reporting Services and I need help ....
I have a Stored Procedure and I'm passing 3 parameters. One of the
parameters is a listbox with several options. I want to automatically
populate those options from a database query. Problem is I am not sure
how to do this.
The report data is currently coming from a Stored Procedure that
returns a single dataset. Do I need to add another dataset or a
subreport? Need helpYou can handle this by creating a new dataset, which can either use a
stored proc that brings back the options you want in your listbox, or
manually typing in the query (dataset type of "Text").
Next, go to Report --> Parameters
Choose the parameter that you want a listbox for.
Under "Available Values," choose "From Query"
In the dataset field, select the new dataset you just created
In the "value field," choose the field from your dataset that holds the
"value" you want passed to the query that drives your report
In the "label field," choose the field from your dataset that you want
to display in the listbox.
John
melishbd wrote:
> I'm new to MS Reporting Services and I need help ....
> I have a Stored Procedure and I'm passing 3 parameters. One of the
> parameters is a listbox with several options. I want to automatically
> populate those options from a database query. Problem is I am not sure
> how to do this.
>
> The report data is currently coming from a Stored Procedure that
> returns a single dataset. Do I need to add another dataset or a
> subreport? Need help|||Sorry I had misunderstood...these guys seem to have you pointed in the
right direction now, anyway.
John
melishbd wrote:
> I'm new to MS Reporting Services and I need help ....
> I have a Stored Procedure and I'm passing 3 parameters. One of the
> parameters is a listbox with several options. I want to automatically
> populate those options from a database query. Problem is I am not sure
> how to do this.
>
> The report data is currently coming from a Stored Procedure that
> returns a single dataset. Do I need to add another dataset or a
> subreport? Need help

list with grouping loses space between records

hi,
I'm new to reporting services and have had a play with it but wonder if
I can get a quick answer here.
I have a dataset and want to show some details of the parent record
with some details of the child.
I have used a table and that is all ok except for the fact that on the
child record I have table headings (which I have put into the parent
grouping row). Now this row expands because of the data in the parent
record which means that the child record doesn't start until after the
parent record. I want the child record to show as a table with its
headers in line with the parent record i.e. the table headers will be
independent of the parent record - not growing.
So I decided to try and use a list. This works as I want except now, I
am not sure how to get a gap between the records. When there are no
child records I get a nice gap but if there are, say 3 child records,
then the gap between the last child record and the next parent record
is virtually non-existent. I have tried putting empty rectangles in and
even an empty textbox with a "CanShrink=False" to try and force a
certain gap between parent records but there's probably something
really basic I'm missing.
Thanks for any help
Philactually the list doesn't work as i want because each of the cells
grows independently of each other so the borders don't align - is there
a way round this?

List SSRS2005 items on treeview

Hi all,

I'm creating a Custom web interface for SQL Server reporting services 2005.

What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?

Thanks

Hi Rudi,

You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

Hi there Brad,

Thanks alot! I'm still having some trouble though...

I'm using this code to get the list:

Try

Dim P As New ReportingService

Dim RootList As CatalogItem = P.ListChildren("/", True)

LoadTree(RootList)

Catch ex As Exception

End Try

But this is returning the error:

\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.

What am I doing wrong?

Thanks

|||

Don't worry, I got it....

I didn't add the () in

Dim RootList As CatalogItem() = rs.ListChildren("/", True)

Thanks

|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.

Thanks,
Kel

List SSRS2005 items on treeview

Hi all,

I'm creating a Custom web interface for SQL Server reporting services 2005.

What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?

Thanks

Hi Rudi,

You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

Hi there Brad,

Thanks alot! I'm still having some trouble though...

I'm using this code to get the list:

Try

Dim P As New ReportingService

Dim RootList As CatalogItem = P.ListChildren("/", True)

LoadTree(RootList)

Catch ex As Exception

End Try

But this is returning the error:

\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.

What am I doing wrong?

Thanks

|||

Don't worry, I got it....

I didn't add the () in

Dim RootList As CatalogItem() = rs.ListChildren("/", True)

Thanks

|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.

Thanks,
Kel

Friday, March 9, 2012

List Of Reports

I have created an application that uses reports published via SQL reporting services. I have a form with a report viewer control on it and above that I have a drop down list box. I want to fill the list box with available reports from the server and allow the user to select the report they wish to see. The report list could change so I don't want to hard code any report names in the list The problem I am having is that I can't figure out how to get a list of available reports from the server.

Thanks for any help offered.

Check out this article:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listchildren.aspx

BobP

|||

You may have to alter this for your system but you can try the query below.

selectdistinctnamefrom dbo.Catalog

where policyroot = 0

andpathnotlike'/Data Source%'

andpathnotlike'/Model%'

orderbyname

|||

Thanks to both of you, now I have options because I used both and they work (with slight modifications).

I modified the query as follows and it gives me just the reports

selectdistinctnamefrom dbo.Catalog

where policyroot = 0

andtype= 2

orderbyname

I just didn't realize it was in the Catalog table, I swore I looked but I guess not.

Thanks again

List of Procedures used in RDL on Production site

Is there a way to search all of the RDL's that have been deployed out to a
Reporting Services site? I am looking for what stored procedures are being
used on our production reporting site.
Any help would be appreciated.All the deployed reports are stored in a table called "catalog" you can get a
list by querying the table.
Amarnath
"LostinSpace" wrote:
> Is there a way to search all of the RDL's that have been deployed out to a
> Reporting Services site? I am looking for what stored procedures are being
> used on our production reporting site.
> Any help would be appreciated.|||I appreciate the response, but this is not what I am looking for.
I need to search the content inside every single rdl to see what stored
procedures are being used. If there isn't a way to do this in RS, is there a
way to do this from vss?
"Amarnath" wrote:
> All the deployed reports are stored in a table called "catalog" you can get a
> list by querying the table.
> Amarnath
> "LostinSpace" wrote:
> > Is there a way to search all of the RDL's that have been deployed out to a
> > Reporting Services site? I am looking for what stored procedures are being
> > used on our production reporting site.
> > Any help would be appreciated.|||OK You said "deployed" so I gave that answer...
You can search for "<CommandType>StoredProcedure</CommandType>" and the next
line will be the stored procedure name. and select look in "Current project"
from the find dialog box.
Hey this looks very basic, is this what you want ?
Amarnath
"LostinSpace" wrote:
> I appreciate the response, but this is not what I am looking for.
> I need to search the content inside every single rdl to see what stored
> procedures are being used. If there isn't a way to do this in RS, is there a
> way to do this from vss?
> "Amarnath" wrote:
> > All the deployed reports are stored in a table called "catalog" you can get a
> > list by querying the table.
> >
> > Amarnath
> >
> > "LostinSpace" wrote:
> >
> > > Is there a way to search all of the RDL's that have been deployed out to a
> > > Reporting Services site? I am looking for what stored procedures are being
> > > used on our production reporting site.
> > > Any help would be appreciated.|||Deployed is correct. I need to search every single rdl deployed to our RS site.
I need to find what stored procedures are used in each rdl. I do not seem to
be able to
do this from the ReportServer database. I know how to do this from the rdl
when in working with the rdl on its own in Visual Studio, but I have over 500
reports in RS. I need a quick and painless way to search all of the rdlâ's at
the same time to see their stored procedures.
I do appreciate the response, I just have a feeling this can not be done...
"Amarnath" wrote:
> OK You said "deployed" so I gave that answer...
> You can search for "<CommandType>StoredProcedure</CommandType>" and the next
> line will be the stored procedure name. and select look in "Current project"
> from the find dialog box.
> Hey this looks very basic, is this what you want ?
> Amarnath
>
> "LostinSpace" wrote:
> > I appreciate the response, but this is not what I am looking for.
> > I need to search the content inside every single rdl to see what stored
> > procedures are being used. If there isn't a way to do this in RS, is there a
> > way to do this from vss?
> >
> > "Amarnath" wrote:
> >
> > > All the deployed reports are stored in a table called "catalog" you can get a
> > > list by querying the table.
> > >
> > > Amarnath
> > >
> > > "LostinSpace" wrote:
> > >
> > > > Is there a way to search all of the RDL's that have been deployed out to a
> > > > Reporting Services site? I am looking for what stored procedures are being
> > > > used on our production reporting site.
> > > > Any help would be appreciated.

Wednesday, March 7, 2012

list of databases in Analysis Services

Hi all,

I have to write a program to read the names of databases in Analysis
Services. I don't know which table I can get this information from.

Thanks a bunchHippi wrote:
> Hi all,
> I have to write a program to read the names of databases in Analysis
> Services. I don't know which table I can get this information from.
> Thanks a bunch

would this work:

select dbid, name
from master..sysdatabases
where has_dbaccess(name) = 1

--
David Rowland
http://dbmonitor.tripod.com|||No, it doesn't work. It shows all the databases I have in SQL Server

List of all folder permissions

Is there a way to get a list of all folder permissions per folder? We
are in the process of cleaning up two Reporting Services boxes that
have gotten way out of control, including permissions. Part of this
process is assigning users to roles, rather than individual permissions
on folders. But to do this, I need to see who is assigned to what
folder (and there are many). Any ideas?I think RS Scripter will help you in this.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_introduction
Someone wrote an OLAP documenter as a Word macro. When opening the word doc
you could point it at a server and it would document all the cubes. Same
thing would be nice for RS.
Steve MunLeeuw
"madrigal" <nmadrigal@.att.net> wrote in message
news:1160661235.716193.208570@.i3g2000cwc.googlegroups.com...
> Is there a way to get a list of all folder permissions per folder? We
> are in the process of cleaning up two Reporting Services boxes that
> have gotten way out of control, including permissions. Part of this
> process is assigning users to roles, rather than individual permissions
> on folders. But to do this, I need to see who is assigned to what
> folder (and there are many). Any ideas?
>

Friday, February 24, 2012

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.

Monday, February 20, 2012

List all subscriptions and recipients

Hi all,
I'm hoping this is an easy question.
Currently we have a large number of reports running on SQL Reporting
Services. The majority of them have subscriptions setup but we don't have
any details. Additionally, some of them are using a distribution list e-mail
and some have each recipient manually entered.
I want to take this opportunity to move as many of them as possible over to
distribution lists.
I would like to get a list of all reports with the following information:
*name of the schedule subscription is using
*how it is sent (e-mail or file)
*if file, i need: file name, path, render format, credentials, overwrite
options, parameters
*if e-mail, i need: recipients, subject, file and/or link, render format,
parameters
*date of last successful send
What is the easiest way of getting this information?
Thanks in advance for any help!
NancyYou should explore "Reportserver database" because it stores everything there
e.g.
catalog has all the report listing and their details, users all user
details, subscription etc...
Amarnath
"Nancy R" wrote:
> Hi all,
> I'm hoping this is an easy question.
> Currently we have a large number of reports running on SQL Reporting
> Services. The majority of them have subscriptions setup but we don't have
> any details. Additionally, some of them are using a distribution list e-mail
> and some have each recipient manually entered.
> I want to take this opportunity to move as many of them as possible over to
> distribution lists.
> I would like to get a list of all reports with the following information:
> *name of the schedule subscription is using
> *how it is sent (e-mail or file)
> *if file, i need: file name, path, render format, credentials, overwrite
> options, parameters
> *if e-mail, i need: recipients, subject, file and/or link, render format,
> parameters
> *date of last successful send
> What is the easiest way of getting this information?
> Thanks in advance for any help!
> Nancy|||Hi Amarnath,
I'm sorry I'm just responding now, we've had some pressing things come up
over the last few months and this got pushed to the back burner.
Where is the reportserver database? How do I access it?
I generally only deal with the "front end" administration, I haven't done
any of it on the back end.
Thanks,
Nancy
"Amarnath" wrote:
> You should explore "Reportserver database" because it stores everything there
> e.g.
> catalog has all the report listing and their details, users all user
> details, subscription etc...
> Amarnath
> "Nancy R" wrote:
> > Hi all,
> >
> > I'm hoping this is an easy question.
> >
> > Currently we have a large number of reports running on SQL Reporting
> > Services. The majority of them have subscriptions setup but we don't have
> > any details. Additionally, some of them are using a distribution list e-mail
> > and some have each recipient manually entered.
> >
> > I want to take this opportunity to move as many of them as possible over to
> > distribution lists.
> >
> > I would like to get a list of all reports with the following information:
> >
> > *name of the schedule subscription is using
> > *how it is sent (e-mail or file)
> > *if file, i need: file name, path, render format, credentials, overwrite
> > options, parameters
> > *if e-mail, i need: recipients, subject, file and/or link, render format,
> > parameters
> > *date of last successful send
> >
> > What is the easiest way of getting this information?
> >
> > Thanks in advance for any help!
> >
> > Nancy