Showing posts with label company. Show all posts
Showing posts with label company. Show all posts

Friday, March 23, 2012

ReportServer: newly published reports and/or folders - how to remove the "!NEW" in gre

I am heavily using ReportServer to disseminate reports around my company, but I cannot get rid of the "!NEW" message in green beside each newly published item.
Help is appreciated, thanks.

You cannot remove it manually. It will go away automatically after 2 days (currently this value cannot be configured).

Obviously, you set the system time of the report server to a date in the past, publish the reports, and then set the system time to present time ...

-- Robert

ReportServer: newly published reports and/or folders - how to remove the "!NEW" in

I am heavily using ReportServer to disseminate reports around my company, but I cannot get rid of the "!NEW" message in green beside each newly published item.
Help is appreciated, thanks.

You cannot remove it manually. It will go away automatically after 2 days (currently this value cannot be configured).

Obviously, you set the system time of the report server to a date in the past, publish the reports, and then set the system time to present time ...

-- Robert

sql

Reportserver virtual directory

On my web hosting server the inetpub/wwwroot folder is located on D: drive, and the web hosting company configured it that way.

When i have installed the sql server 2005 it created the virtual directory under c:\inetpub\wwwroot which is not a default website location on that server.

could you please tell me how to switch the virtual directory path from c:\inetpub\wwwroot

to

d:\inetpub\wwwroot

Please any help would be greatly appreciated.

Thank you very much.

I'm not quite sure how you mean. When RS installs it doesn't place any files in c:\inetpub\wwwroot. The standard location will be

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Note that the drive letter and the number after the MSSQL. part may vary depending on the choices made during setup and the SQL Server components selected.

The using the configuration tool, it creates 2 virtual directories beneath the default website i.e. the one on port 80 called "reportserver" and "reports" and these are just pointers to the physical directories located int he above install path.

Please can you clarify the issue you seem to be having?

Wednesday, March 21, 2012

Reports wont show any result in another User Account

Hi,

i got a problem with all the reports which where created in by one user. This user has left our company. The weird think is that all the reports the user has created works/runs fine in that users account.

The problem is if i try to run exactly the same report in my user account it does not show any values, except of one that is total count of the data entries. I got the connection to the database, i created a test report with basic values, it works fine.

The reports wont run on any other user account. It just run fine in the account where it got created.

I assume the user must have setup something in his Crystal Reports, DB2 or anywhere else. Attributes and the rights are exactly the same. My account is in the same group like the other account. I do have exactly the same rights i also can modify the file and safe it but i cant see the result after i run the report. If i can't check the results it makes no sense to modify it. I have to login in that account to do the modifications or to test them.

I have a tool which runs report independetly. There i can see the result in any account. The reports does only not work in Crystal Reports.

Anyone has idea what could be wrong ? I have tried everything but i cant find out what the problem is.

It's really urgent i hope someone has a solution

TrayHard to say, have you checked the database connections under the "working id" and compared them with yours. Perhaps he set up a custom connection to the database that your connection does not have.
" Grasping at straws "sql

Monday, March 12, 2012

Reports in IFrames over internet.

We are considering Reporting Services as one of the options for our
company's data reporting needs. I have a few questions. It will be
great if someone can help me with these.
1.Are Iframe and "new window" the only two ways to display/integrate
reports in a .net Web application? Does the reporting server API
provide an interface to get results from a Reporting server and
display in a customized way?
2.Is it recommended for Internet based applications or should it only
be considered for intranet applications?
Appreciate all the helpThere is also a web service API that would allow you to tailor your
control over when and how to display. You are still limited in your
display format by the available rendering extensions.
And this is definitely a viable option for Internet based
applications. However, you will have to write a custom security
extension (or tailor the sample).
aishaumer@.yahoo.com (AK) wrote in message news:<5c59061c.0407211602.45afed5@.posting.google.com>...
> We are considering Reporting Services as one of the options for our
> company's data reporting needs. I have a few questions. It will be
> great if someone can help me with these.
> 1.Are Iframe and "new window" the only two ways to display/integrate
> reports in a .net Web application? Does the reporting server API
> provide an interface to get results from a Reporting server and
> display in a customized way?
> 2.Is it recommended for Internet based applications or should it only
> be considered for intranet applications?
> Appreciate all the help

Monday, February 20, 2012

Reporting Services: alternatives to Visual Studio as a Report Designer?

I am sold on Reporting Services. Our small company data
base is running on SQLserver2000 on Windows2003. We don't
need the full functionality ( and especially cost) of
Visual Studio.net as the Report Designer. What lower-cost
alternatives are there to buying Visual Studio. net?
Ian Wells
Check the Reporting Services partners -
http://www.microsoft.com/sql/reporti...twareapps.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Ian Wells" <ian.wells@.experienceplus.com> wrote in message
news:83a901c4ce69$e57d2b50$a301280a@.phx.gbl...
> I am sold on Reporting Services. Our small company data
> base is running on SQLserver2000 on Windows2003. We don't
> need the full functionality ( and especially cost) of
> Visual Studio.net as the Report Designer. What lower-cost
> alternatives are there to buying Visual Studio. net?
> Ian Wells

Reporting Services/BI Model processing

My company is in the process of migrating to SQL Reporting Services 2005. At
this time we are most interested in the Business Intelligence functionality
included in SS2K5. While we were testing this product we had everything all
on the same box...SS, Reporting Services, web tools...everything. Now, we are
scaling out the project and are trying to determine where the processing of
the reports and BI models takes place. Is it on the SQL Server box or on the
Reporting Services box?
Thanks in advance!!
--
ManuelRS is a aps.net application. It uses SQL Server databases for its object and
metadata storage. It stores reporting definitions, subscriptions, etc.
Rendering occurs in RAM. So, a big report can definitely really drag on the
server. Then, if your data is also coming from SQL Server then SQL Server DB
engine has the work to retrieve the data. This is totally separate from the
work that RS is doing.
When RS is put on its own server you still need to have a SQL Server license
for the box. It doesn't matter where the RS databases reside (ReportServer
and ReportServerTempDB). My advice is, unless you are doing a web farm,
install the SQL Server database for the metadata storage on the box that
will run RS. Then keep the data you are reporting off of on a second box. In
that way, the temp data storage, the report definitions, etc are close at
hand. And, a big report won't slow down your database server which contains
your data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> My company is in the process of migrating to SQL Reporting Services 2005.
> At
> this time we are most interested in the Business Intelligence
> functionality
> included in SS2K5. While we were testing this product we had everything
> all
> on the same box...SS, Reporting Services, web tools...everything. Now, we
> are
> scaling out the project and are trying to determine where the processing
> of
> the reports and BI models takes place. Is it on the SQL Server box or on
> the
> Reporting Services box?
> Thanks in advance!!
> --
> Manuel
>|||We're a lot clearer on what our approach will be. Thanks a million!
--
Manuel
"Bruce L-C [MVP]" wrote:
> RS is a aps.net application. It uses SQL Server databases for its object and
> metadata storage. It stores reporting definitions, subscriptions, etc.
> Rendering occurs in RAM. So, a big report can definitely really drag on the
> server. Then, if your data is also coming from SQL Server then SQL Server DB
> engine has the work to retrieve the data. This is totally separate from the
> work that RS is doing.
> When RS is put on its own server you still need to have a SQL Server license
> for the box. It doesn't matter where the RS databases reside (ReportServer
> and ReportServerTempDB). My advice is, unless you are doing a web farm,
> install the SQL Server database for the metadata storage on the box that
> will run RS. Then keep the data you are reporting off of on a second box. In
> that way, the temp data storage, the report definitions, etc are close at
> hand. And, a big report won't slow down your database server which contains
> your data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
> news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> > My company is in the process of migrating to SQL Reporting Services 2005.
> > At
> > this time we are most interested in the Business Intelligence
> > functionality
> > included in SS2K5. While we were testing this product we had everything
> > all
> > on the same box...SS, Reporting Services, web tools...everything. Now, we
> > are
> > scaling out the project and are trying to determine where the processing
> > of
> > the reports and BI models takes place. Is it on the SQL Server box or on
> > the
> > Reporting Services box?
> >
> > Thanks in advance!!
> > --
> > Manuel
> >
>
>