Showing posts with label number. Show all posts
Showing posts with label number. Show all posts

Friday, February 24, 2012

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

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