sql server tools: viewer

Showing posts with label viewer. Show all posts

Sunday, March 25, 2012

Archive Reports for offline review

Is there any way in SSRS to render the report in the native SSRS Report Viewer format and then archive it so that an offline program can later open the report using a program with the reportviewer control, so that the user can sort/drill down/export just as they would when attaching
to the SSRS server?

I see ways to get the reports in other formats (html, pdf, etc.), but not a way to get the report in a format that can later be opened with the ReportViewer component.

Thank you in advance for any help!

Did you ever find a solution to this?sql

Archive Reports for offline review

I see ways to get the reports in other formats (html, pdf, etc.), but not a way to get the report in a format that can later be opened with the ReportViewer component.

Thank you in advance for any help!

Did you ever find a solution to this?

Thursday, March 8, 2012

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
--
TomTom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
--
Tom
"Uri Dimant" wrote:
> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
> >I can't find any information to correct the following warning message that
> >I
> > receive in Event Viewer.
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3055
> > Description: The gatherer property mapping file cannot be opened. Error:
> > 80070003. The default values are being used. You may have to copy the
> > property mapping file from the Setup CD-ROM, or reinstall the application.
> >
> > Environment:
> > Windows 2000 Server SP4
> > SQL Server 2000 SP4 Standard Edition (8.00.2039)
> > MDAC 2.81.1117.6
> >
> > The server is not in a cluster, and doesn't have Exchange installed. Any
> > assistance would greatly be appreciated!!!
> > --
> > Tom
>
>|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>>I can't find any information to correct the following warning message that
>>I
>> receive in Event Viewer.
>> Event Type: Warning
>> Event Source: Microsoft Search
>> Event Category: Gatherer
>> Event ID: 3055
>> Description: The gatherer property mapping file cannot be opened.
>> Error:
>> 80070003. The default values are being used. You may have to copy the
>> property mapping file from the Setup CD-ROM, or reinstall the
>> application.
>> Environment:
>> Windows 2000 Server SP4
>> SQL Server 2000 SP4 Standard Edition (8.00.2039)
>> MDAC 2.81.1117.6
>> The server is not in a cluster, and doesn't have Exchange installed. Any
>> assistance would greatly be appreciated!!!
>> --
>> Tom
>

Saturday, February 25, 2012

Application Log - Overwrite as Needed

In the event viewer: In Application Log properties, there are options on
what to do "When maximum log size is reached." I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."
Why does it do this and how can I make it stop? It has been going on for
several months.Sheila,
If it is possible, perhaps a Group Policy at a higher level could be making
this change.
HTH
Jerry
"Sheila" <Sheila@.discussions.microsoft.com> wrote in message
news:E4ADF2FF-F543-4FC6-A2E4-8CB0E717850F@.microsoft.com...
> In the event viewer: In Application Log properties, there are options on
> what to do "When maximum log size is reached." I set it to "Overwrite as
> Needed", but the next day it is changed to "Overwrite Events Older than 5
> Days."
> Why does it do this and how can I make it stop? It has been going on for
> several months.
>

Application Log - Overwrite as Needed

In the event viewer: In Application Log properties, there are options on
what to do "When maximum log size is reached." I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."
Why does it do this and how can I make it stop? It has been going on for
several months.
Sheila,
If it is possible, perhaps a Group Policy at a higher level could be making
this change.
HTH
Jerry
"Sheila" <Sheila@.discussions.microsoft.com> wrote in message
news:E4ADF2FF-F543-4FC6-A2E4-8CB0E717850F@.microsoft.com...
> In the event viewer: In Application Log properties, there are options on
> what to do "When maximum log size is reached." I set it to "Overwrite as
> Needed", but the next day it is changed to "Overwrite Events Older than 5
> Days."
> Why does it do this and how can I make it stop? It has been going on for
> several months.
>

Application Log - Overwrite as Needed

Application goes slow or not responding after few transaction

Dear all viewer ,

Thanks to everyone.

We are using -
MSSQL Server 2000 on windows 2000 advanced server.
PB 7.0 for client server front end tools.

Prior to few days our application works fine, rightnow it get slow or not responding after few (4/5) transaction. We don't know wht it is, If anyone has same experience so that is helpfull for us.

Thanks

R.MallMonitor your activity with SQL Profiler.|||Thanks for reply

How I can do it? Can you give me step by step methods?

R.Mall|||SELECT Profiler
FROM BooksOnline

or

SELECT Consultant
FROM YellowPages|||Thanks for right suggession, I will do it.

Thanks|||I wonder if he actually did that? :)

You can also find information about running Profiler from:

www.sql-server-performance.com
www.sqlteam.com
SQL Server 2000 Performance Tuning Technical Manual (Microsoft Press)

Thursday, February 16, 2012

Append current date in exported report file name in PDF format in sql report server 2000

HI All

I want to append current date in exported reported file name.

I am using report viewer to diplay report . when i exported report in pdf format it ask me to save file at this time file name is same what ever i uploaded in report server.

when it ask me to save i want append current date to the file name.

like report file name is "testingdetail" then i want "testingdetail-November-27-2006.pdf"

Please help me in this

Thanks

Alpesh

It appears you can only alter the filename when using subscriptions. (link to related post)

If you find another way to achieve that behavior please let me know.

|||

Hi All

I found another way to append current date to Expoting report file name.

We have to overide the Reder method of reporting service

first we have to add web reference of reporting service then

put below code in button click event

private void lnkexport_Click(object sender, System.EventArgs e)

{

ReportingService rs = new ReportingService();

string reportPath=/SampleDetail/TestingDetail;

// TestingDetail report must uploded in SampleDetail folder in ReportManager

TestingDetailReport testingDetailParams =this.reportParams as TestingDetailReport;

ParameterValue[] parameters = new ParameterValue[1];

parameters[0] = new ParameterValue();

parameters[0].Name="parameterName";

parameters[0].Value=parameterValue;

Byte[] result = this.LoadReport(reportPath,parameters);

string fname = "TestingDetail" + " - " +DateTime.Today.ToString("MMMM-dd-yyyy");

Response.ClearContent();

Response.AddHeader("Content-Disposition","attachment; filename=" + fname);

Response.AddHeader("Content-Length", result.LongLength.ToString());

Response.ContentType="Application/pdf";

Response.BinaryWrite(result);

Response.Flush();

Response.Close();

}

private Byte[] LoadReport(string reportPath,ParameterValue[] parameter )

{

ReportingService rs = new ReportingService();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

string[] streamIDs;

string optionalString = null;

ParameterValue[]optionalparams =null;

Warning[] warning = null;

Byte[] output= rs.Render(reportPath,"PDF",null,null,parameter,null,null,out optionalString,out optionalString,out optionalparams,out warning,out streamIDs);

return output;

}

Thanks

Alpesh

Monday, February 13, 2012

Apparent Security violations recorded in Event Viewer

I am receiving the following event in the event viewer. I
believe that it is from hackers trying to execute Sql
Statements against my Sql Server to gain access to my
website. I only have port 80 open via my firewall, so I'm
confused as to how they are getting in. Does anyone have
any suggestions?
Any help, ideas, suggestions would be greatly appreciated.
Pat Rogers
Event Type: Information
Event Source: ODBC Error (388221)
Event Category: None
Event ID: 0
Date: 7/21/2004
Time: 8:44:23 AM
User: N/A
Computer: P6-CR2-SVR
Description:
The description for Event ID ( 0 ) in Source ( ODBC Error
(388221) )
cannot be found. The local computer may not have the
necessary registry
information or message DLL files to display messages from
a remote
computer. The following information is part of the event:
Message Text:
=============
SQL Selected Record is invalid: - 00000.Pat,
I would at least make sure that you record all failed access attempts. This
can be done by properties - Security tab - Audit level and check Failure.
This way you can see who is trying to get access.
Chris Wood
Alberta Department of Energy
CANADA
"Pat Rogers" <progers@.kc.rr.com> wrote in message
news:2ea301c470e0$6a535d50$a401280a@.phx.gbl...
> I am receiving the following event in the event viewer. I
> believe that it is from hackers trying to execute Sql
> Statements against my Sql Server to gain access to my
> website. I only have port 80 open via my firewall, so I'm
> confused as to how they are getting in. Does anyone have
> any suggestions?
> Any help, ideas, suggestions would be greatly appreciated.
> Pat Rogers
> Event Type: Information
> Event Source: ODBC Error (388221)
> Event Category: None
> Event ID: 0
> Date: 7/21/2004
> Time: 8:44:23 AM
> User: N/A
> Computer: P6-CR2-SVR
> Description:
> The description for Event ID ( 0 ) in Source ( ODBC Error
> (388221) )
> cannot be found. The local computer may not have the
> necessary registry
> information or message DLL files to display messages from
> a remote
> computer. The following information is part of the event:
> Message Text:
> =============
> SQL Selected Record is invalid: - 00000.
>
>

Sunday, March 25, 2012

Archive Reports for offline review

Archive Reports for offline review

Thursday, March 8, 2012

Application Warning

Application Warning

Application Warning

Saturday, February 25, 2012

Application Log - Overwrite as Needed

Application Log - Overwrite as Needed

Application Log - Overwrite as Needed

Application goes slow or not responding after few transaction

Thursday, February 16, 2012

Append current date in exported report file name in PDF format in sql report server 2000

Monday, February 13, 2012

Apparent Security violations recorded in Event Viewer

sql server tools

Blog Archive

About Me