Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts

Friday, March 30, 2012

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

How to get the URL to access a report?

hi, all
I am just starting to use the SQL Server 2005 report service. And I
also made some reports, and I am thinking how to get the URL to access
the report, especially when I have some parameters need to be passed
into the report.THe easiest way to get the URL is simply to run the report from Report
Manager, then copy the URL from IE..
ALso read about URL access and parameters for RS in the Books on Line... It
will tell you how you can change the URL to add parameters, do rendering
options..etc
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Nick" wrote:
> hi, all
> I am just starting to use the SQL Server 2005 report service. And I
> also made some reports, and I am thinking how to get the URL to access
> the report, especially when I have some parameters need to be passed
> into the report.
>sql

Monday, March 26, 2012

how to get the report list with one modified table ?

When i modify one table schema, how could i get the report list that lists
all the reports reference the table i modified ?
Thanks for any help.Hi Abel:
AFAIK, there is no easy way to do this. It might be an interesting
utility to write...
--
Scott
http://www.OdeToCode.com/
On Fri, 1 Oct 2004 00:07:02 -0700, "Abel"
<Abel@.discussions.microsoft.com> wrote:
>When i modify one table schema, how could i get the report list that lists
>all the reports reference the table i modified ?
>Thanks for any help.

Wednesday, March 21, 2012

How to get the Columns list to the end user?

Hello Nilay here,

How to display the coulumn list of the reports to the end user ?

Thanks,I don't understand the question. Is it

a) How to prompt the user for the columns he/she wants to display, or
b) How to display a column containing a list of reports?|||Hi, I want to show the All coumns, which are in the report, to the end user. So user can select his usefull columns and the selected coulmn should only show on the report and other should be hide.

Regards,
Nilay|||

In SQL Server 2005, you can use a multi-value parameter to prompt the user. Then you can write an expression/custom function to parse the output of the parameter. Call that expression/custom function in the visibility expression for the column in your table/matrix.

You'll need to make sure the choices in your parameter list are are kept in sync with your fields list, that's something that we don't provide by default.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

How to get the Columns list to the end user?

Hello Nilay here,

How to display the coulumn list of the reports to the end user ?

Thanks,I don't understand the question. Is it

a) How to prompt the user for the columns he/she wants to display, or
b) How to display a column containing a list of reports?|||Hi, I want to show the All coumns, which are in the report, to the end user. So user can select his usefull columns and the selected coulmn should only show on the report and other should be hide.

Regards,
Nilay|||

In SQL Server 2005, you can use a multi-value parameter to prompt the user. Then you can write an expression/custom function to parse the output of the parameter. Call that expression/custom function in the visibility expression for the column in your table/matrix.

You'll need to make sure the choices in your parameter list are are kept in sync with your fields list, that's something that we don't provide by default.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Monday, March 12, 2012

How To Get Rid Of Sql Log

Hi,
I have a Data base on Sql Server 2000, sp3a. Database is used to to build summary tables to show reports on web. There are many sub systems, which prepare summarized tables for faster web page serving. Every thing is working fine.

The problem is sql server log gets full. In one given day it could go up to 18 GB. I know, if I back it up it gets truncated. Is there a way, I can stop sql server not to log, as it is not needed?

Can I set up Sql server to automatically truncate it. I do have auto shrink options checked, but log file still keeps growing.

Any idea, what is going on here.
Thanks,
Mashro::Is there a way, I can stop sql server not to log, as it is not needed?

You err, it IS needed.

Read up in the documentation what the log is used for. It is needed.|||Back it up regularly to keep it from growing out of control. You can't eliminate the log. It's a pretty key piece of the puzzle. If you have the db set to simple recovery, it should truncate the log on each checkpoint. Probably no need to use a full recovery model on a 'derived' reporting database like you seem to have.

how to get rid of document map in reports

there is a tree on the left hand side of my report ,which I don't want it to
be there ,how can I hide that document map? is there a special paramter or
somehting that I have to pass?
thanks for yuor help.
ALIData regions (matrix, table, list, etc.), groupings (except chart groups
where Labels have a different meaning), and textboxes have a property called
Label. If the Label property is set on any of these and the expression
returns a value != null, the document map will show up.
You can open an RDL file in a XML editor, report designer code view, or
notepad and just search for <Label> elements and remove them if you don't
want them. However, make sure to *not* remove <Label> elements on report
parameters or on chart groupings (because these are the labels shown inside
the chart).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23IuNuXl3EHA.3504@.TK2MSFTNGP12.phx.gbl...
> there is a tree on the left hand side of my report ,which I don't want it
to
> be there ,how can I hide that document map? is there a special paramter
or
> somehting that I have to pass?
> thanks for yuor help.
> ALI
>|||thanks for the information.now it is working
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:u$bxhdl3EHA.3504@.TK2MSFTNGP12.phx.gbl...
> Data regions (matrix, table, list, etc.), groupings (except chart groups
> where Labels have a different meaning), and textboxes have a property
called
> Label. If the Label property is set on any of these and the expression
> returns a value != null, the document map will show up.
> You can open an RDL file in a XML editor, report designer code view, or
> notepad and just search for <Label> elements and remove them if you don't
> want them. However, make sure to *not* remove <Label> elements on report
> parameters or on chart groupings (because these are the labels shown
inside
> the chart).
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23IuNuXl3EHA.3504@.TK2MSFTNGP12.phx.gbl...
> > there is a tree on the left hand side of my report ,which I don't want
it
> to
> > be there ,how can I hide that document map? is there a special
paramter
> or
> > somehting that I have to pass?
> >
> > thanks for yuor help.
> > ALI
> >
> >
>

How to get reports on internet?

We were using reports on our intranet environment for a while and tried to
create couple of reports on internet. We did this -
Installed a Windows 2003 Server/SQL Server 2000/Report Services, then
uploaded reports. Can we get reports on our web pages without giving an
external IP for Reporting services server?
With our current installation, we are getting a 'Page Not Found' error.
Any idea?I am pretty sure you will need an external IP in order for the "world" to see
the Reporting Server.
That being said, I am sure you have run into the login window. All external
users will need to have windows accounts because by default the
authentication method used is windows. You will need to add a custom
security extension to change this to forms authentication.
"Binoy" wrote:
> We were using reports on our intranet environment for a while and tried to
> create couple of reports on internet. We did this -
> Installed a Windows 2003 Server/SQL Server 2000/Report Services, then
> uploaded reports. Can we get reports on our web pages without giving an
> external IP for Reporting services server?
> With our current installation, we are getting a 'Page Not Found' error.
> Any idea?