ReportViewer Help

I use the following code to display a report in the ReportViewer. The report
and the shared datasource are in another .NET solution. The report displays,
but the data does not. Can anyone help me figure out how to make the
report data display?
private DataTable LoadReportData()
{
DataSet ds = new DataSet();
ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
return ds.Tables[1];
}
protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
ProcessingMode.Local;
this.ReportViewer1.LocalReport.ReportPath = "C:\\Reports\\ActivitySummaryReport.rdl";
this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
LoadReportData()));
this.ReportViewer1.LocalReport.EnableExternalImages = true;
}
Thanks,
PaulaAssuming that Tables[1] actually returns data and your report bindings are
correct, try:
reportViewer1.RefreshReport()
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Paula" <pmpayne@.nospam.com> wrote in message
news:abc40aa6399943198835be4ccb90828a@.ureader.com...
>I use the following code to display a report in the ReportViewer. The
>report
> and the shared datasource are in another .NET solution. The report
> displays,
> but the data does not. Can anyone help me figure out how to make the
> report data display?
> private DataTable LoadReportData()
> {
> DataSet ds = new DataSet();
> ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
> return ds.Tables[1];
> }
> protected void Page_Load(object sender, EventArgs e)
> {
> this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
> ProcessingMode.Local;
> this.ReportViewer1.LocalReport.ReportPath => "C:\\Reports\\ActivitySummaryReport.rdl";
> this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
> Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
> LoadReportData()));
> this.ReportViewer1.LocalReport.EnableExternalImages = true;
> }
> Thanks,
> Paula|||How many tables do you have in your dataset?
Remeber that tables are 0 indexed, so if you had only one table in your
dataset you would want to return Tables[0].
"Paula" <pmpayne@.nospam.com> wrote in message
news:abc40aa6399943198835be4ccb90828a@.ureader.com...
>I use the following code to display a report in the ReportViewer. The
>report
> and the shared datasource are in another .NET solution. The report
> displays,
> but the data does not. Can anyone help me figure out how to make the
> report data display?
> private DataTable LoadReportData()
> {
> DataSet ds = new DataSet();
> ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
> return ds.Tables[1];
> }
> protected void Page_Load(object sender, EventArgs e)
> {
> this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
> ProcessingMode.Local;
> this.ReportViewer1.LocalReport.ReportPath => "C:\\Reports\\ActivitySummaryReport.rdl";
> this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
> Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
> LoadReportData()));
> this.ReportViewer1.LocalReport.EnableExternalImages = true;
> }
> Thanks,
> Paulasql

ReportViewer does not print on first attempt

Hi,
Has anyone found a solution to the problem of the reportviewer not printing
the first time you try to print? We found a solution on another newsgroup
but it doesn't fully resolve the problem.
Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout)Me.ReportViewer1.RefreshReport()
By using the displaymode.printlayout now you have to press the Print button
in the print dialog twice. But at least it prints. It seems that when the
print dialog displays it does not have focus. Clicking the print button or
anything else in the print dialog, then clicking the Print Button again does
actually print the report.there is a fix on msdn.
using a timer
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comsql

Reports Dynamically Generated

Hello,
I'm sure there is a simple solution for this, but I'm very new to Reporting Services. I'm working with the Yukon product, and I am creating reports that will compare import data against the database. What I want to be able to do is have a Yukon package import the data, then generate a report, using reporting services through code. Is that possible? It could even be a remote executable that Yukon would have access to...
Thanks.It is possible in SQL Server 2005 but you have to do the setup in Integration Services. Try this link for options.
Hope this helps.
http://www.sqlis.com/

reports about the reports usage

Hi,

We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?

With regards,

Constantijn Enders

Take a look at this article:

http://www.sql-server-performance.com/wp_msrs_01.asp

In general you can see the log files on the server in the following folder:

Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

Shyam

|||

It is a very good article, but unfortenately I can't find those sql scripts.

After some browsing I found them in

\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\Server Management Sample Reports

Thanks for you help

CE

Reports from MS Analysis Services

I am thinking about a solution to generate reports dynamically from the web from MS Analysis Services cubes. What would be the possible options? Thanks!if you want to build, you can use clientside Office Web Components.

does it NEED to be web-based?

i personally prefer real excel automation against real XLS files that end users can save wherever they like.

my team develops webbased reports using OWC. it is a great way to go. it might frutstrate you. it might take you a year.

but at the end of that year, you will have some very powerful flexible reports.

these are the best MD ActiveX controls anywhere.

if you buy, you are on your own, and be prepared to spend big $$.

ReportingSrvc Logs filling drive

For no apparent reason RS logging started filling the
servers drive with 33 MB files. Researching it gave a
reboot solution, but no fix. The same 4 lines repeat
themselves.
ReportingServicesService!runningjobs!273c!8/15/2004-
14:22:20:: i INFO: Execution Log Entry Expiration timer
enabled: Cycle: 41859 seconds
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:20:: i INFO: Expiring old execution log entries
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:20:: i INFO: Expiration of old execution log entries
is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
ReportingServicesService!runningjobs!2738!8/15/2004-
14:22:21:: i INFO: Execution Log Entry Expiration timer
enabled: Cycle: 41858 seconds
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Expiring old execution log entries
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Expiration of old execution log entries
is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
Is there a fix for this?
GRWe are aware of this issue and are working on a potential fix. Your best
option at this point is to contact PSS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"GR" <anonymous@.discussions.microsoft.com> wrote in message
news:696501c48399$85c483e0$a301280a@.phx.gbl...
> For no apparent reason RS logging started filling the
> servers drive with 33 MB files. Researching it gave a
> reboot solution, but no fix. The same 4 lines repeat
> themselves.
> ReportingServicesService!runningjobs!273c!8/15/2004-
> 14:22:20:: i INFO: Execution Log Entry Expiration timer
> enabled: Cycle: 41859 seconds
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:20:: i INFO: Expiring old execution log entries
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:20:: i INFO: Expiration of old execution log entries
> is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!2738!8/15/2004-
> 14:22:21:: i INFO: Execution Log Entry Expiration timer
> enabled: Cycle: 41858 seconds
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Expiring old execution log entries
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Expiration of old execution log entries
> is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
> Is there a fix for this?
> GR

Reporting solution

I was interested in knowing (my experience is limited) what might be the best
solution when using Reporting Services to return data that can be 15 minutes
old, tops. We are looking to have a separate, second data set dedicated to
this reporting. Is a type of replication best suited? Any other ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1I've been successful reporting from production tables with hundreds of
millions or rows of live data, hundreds of new rows per minute. Since the
tables have clustered indexes on either sequential entry OR time fields, the
reporting queries are virtually instantaneous.
What is the clustering index on the table?
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:622a2e85990f8@.uwe...
>I was interested in knowing (my experience is limited) what might be the
>best
> solution when using Reporting Services to return data that can be 15
> minutes
> old, tops. We are looking to have a separate, second data set dedicated to
> this reporting. Is a type of replication best suited? Any other ideas?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||This is ad-hoc reporting that will be instituted. We do not want ad-hoc
reporting on our production databases so we are looking at an alternative
solution.
Arnie Rowland wrote:
>I've been successful reporting from production tables with hundreds of
>millions or rows of live data, hundreds of new rows per minute. Since the
>tables have clustered indexes on either sequential entry OR time fields, the
>reporting queries are virtually instantaneous.
>What is the clustering index on the table?
>>I was interested in knowing (my experience is limited) what might be the
>>best
>> solution when using Reporting Services to return data that can be 15
>> minutes
>> old, tops. We are looking to have a separate, second data set dedicated to
>> this reporting. Is a type of replication best suited? Any other ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||In that case, some form of replication is in order -look into MERGE
Replication.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:622a9e2ed3ce4@.uwe...
> This is ad-hoc reporting that will be instituted. We do not want ad-hoc
> reporting on our production databases so we are looking at an alternative
> solution.
> Arnie Rowland wrote:
>>I've been successful reporting from production tables with hundreds of
>>millions or rows of live data, hundreds of new rows per minute. Since the
>>tables have clustered indexes on either sequential entry OR time fields,
>>the
>>reporting queries are virtually instantaneous.
>>What is the clustering index on the table?
>>I was interested in knowing (my experience is limited) what might be the
>>best
>> solution when using Reporting Services to return data that can be 15
>> minutes
>> old, tops. We are looking to have a separate, second data set dedicated
>> to
>> this reporting. Is a type of replication best suited? Any other ideas?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||Thanks Arnie. Can you verify something, please? I have been reading BOL on
the different types of replication: Merge, Transactional, and Snapshot. I am
trying to determine what is the best for our situation. It sounds like when
using Snapshot replication (if data on the subscriber could only be 15
minutes old at tops), that applying the Snapshot every 15 minutes, if a user
tried to generate a report while the Snapshot was being applied, then the
user might not have very good response time, depending on the size of the
Snapshot. Is that correct?
Arnie Rowland wrote:
>In that case, some form of replication is in order -look into MERGE
>Replication.
>> This is ad-hoc reporting that will be instituted. We do not want ad-hoc
>> reporting on our production databases so we are looking at an alternative
>[quoted text clipped - 15 lines]
>> to
>> this reporting. Is a type of replication best suited? Any other ideas?
--
Message posted via http://www.sqlmonster.com|||Snapshot Replication takes a 'snapshot' of the ENTIRE database and
replicates it to the subscriber.
Depending upon the size of the database, that could be a substaintial
performance issue. Imagine, 400 new rows of data, but 4 million rows (and
growing) transferred each time. Probably not a good plan -except for the
first time.
Transactional Replication is the best choice since the reporting server is
not changing any data and you are only concerned with the new data since the
last replcation update.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:622b2eda71445@.uwe...
> Thanks Arnie. Can you verify something, please? I have been reading BOL on
> the different types of replication: Merge, Transactional, and Snapshot. I
> am
> trying to determine what is the best for our situation. It sounds like
> when
> using Snapshot replication (if data on the subscriber could only be 15
> minutes old at tops), that applying the Snapshot every 15 minutes, if a
> user
> tried to generate a report while the Snapshot was being applied, then the
> user might not have very good response time, depending on the size of the
> Snapshot. Is that correct?
> Arnie Rowland wrote:
>>In that case, some form of replication is in order -look into MERGE
>>Replication.
>> This is ad-hoc reporting that will be instituted. We do not want ad-hoc
>> reporting on our production databases so we are looking at an
>> alternative
>>[quoted text clipped - 15 lines]
>> to
>> this reporting. Is a type of replication best suited? Any other ideas?
> --
> Message posted via http://www.sqlmonster.com

Reporting solution

I was interested in knowing (my experience is limited) what might be the bes
t
solution when using Reporting Services to return data that can be 15 minutes
old, tops. We are looking to have a separate, second data set dedicated to
this reporting. Is a type of replication best suited? Any other ideas?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1I've been successful reporting from production tables with hundreds of
millions or rows of live data, hundreds of new rows per minute. Since the
tables have clustered indexes on either sequential entry OR time fields, the
reporting queries are virtually instantaneous.
What is the clustering index on the table?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:622a2e85990f8@.uwe...
>I was interested in knowing (my experience is limited) what might be the
>best
> solution when using Reporting Services to return data that can be 15
> minutes
> old, tops. We are looking to have a separate, second data set dedicated to
> this reporting. Is a type of replication best suited? Any other ideas?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1|||This is ad-hoc reporting that will be instituted. We do not want ad-hoc
reporting on our production databases so we are looking at an alternative
solution.
Arnie Rowland wrote:[vbcol=seagreen]
>I've been successful reporting from production tables with hundreds of
>millions or rows of live data, hundreds of new rows per minute. Since the
>tables have clustered indexes on either sequential entry OR time fields, th
e
>reporting queries are virtually instantaneous.
>What is the clustering index on the table?
>
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||In that case, some form of replication is in order -look into MERGE
Replication.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:622a9e2ed3ce4@.uwe...
> This is ad-hoc reporting that will be instituted. We do not want ad-hoc
> reporting on our production databases so we are looking at an alternative
> solution.
> Arnie Rowland wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1|||Thanks Arnie. Can you verify something, please? I have been reading BOL on
the different types of replication: Merge, Transactional, and Snapshot. I am
trying to determine what is the best for our situation. It sounds like when
using Snapshot replication (if data on the subscriber could only be 15
minutes old at tops), that applying the Snapshot every 15 minutes, if a user
tried to generate a report while the Snapshot was being applied, then the
user might not have very good response time, depending on the size of the
Snapshot. Is that correct?
Arnie Rowland wrote:[vbcol=seagreen]
>In that case, some form of replication is in order -look into MERGE
>Replication.
>
>[quoted text clipped - 15 lines]
Message posted via http://www.droptable.com|||Snapshot Replication takes a 'snapshot' of the ENTIRE database and
replicates it to the subscriber.
Depending upon the size of the database, that could be a substaintial
performance issue. Imagine, 400 new rows of data, but 4 million rows (and
growing) transferred each time. Probably not a good plan -except for the
first time.
Transactional Replication is the best choice since the reporting server is
not changing any data and you are only concerned with the new data since the
last replcation update.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:622b2eda71445@.uwe...
> Thanks Arnie. Can you verify something, please? I have been reading BOL on
> the different types of replication: Merge, Transactional, and Snapshot. I
> am
> trying to determine what is the best for our situation. It sounds like
> when
> using Snapshot replication (if data on the subscriber could only be 15
> minutes old at tops), that applying the Snapshot every 15 minutes, if a
> user
> tried to generate a report while the Snapshot was being applied, then the
> user might not have very good response time, depending on the size of the
> Snapshot. Is that correct?
> Arnie Rowland wrote:
> --
> Message posted via http://www.droptable.com|||I've been successful reporting from production tables with hundreds of
millions or rows of live data, hundreds of new rows per minute. Since the
tables have clustered indexes on either sequential entry OR time fields, the
reporting queries are virtually instantaneous.
What is the clustering index on the table?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:622a2e85990f8@.uwe...
>I was interested in knowing (my experience is limited) what might be the
>best
> solution when using Reporting Services to return data that can be 15
> minutes
> old, tops. We are looking to have a separate, second data set dedicated to
> this reporting. Is a type of replication best suited? Any other ideas?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1|||This is ad-hoc reporting that will be instituted. We do not want ad-hoc
reporting on our production databases so we are looking at an alternative
solution.
Arnie Rowland wrote:[vbcol=seagreen]
>I've been successful reporting from production tables with hundreds of
>millions or rows of live data, hundreds of new rows per minute. Since the
>tables have clustered indexes on either sequential entry OR time fields, th
e
>reporting queries are virtually instantaneous.
>What is the clustering index on the table?
>
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||In that case, some form of replication is in order -look into MERGE
Replication.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:622a9e2ed3ce4@.uwe...
> This is ad-hoc reporting that will be instituted. We do not want ad-hoc
> reporting on our production databases so we are looking at an alternative
> solution.
> Arnie Rowland wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1|||Thanks Arnie. Can you verify something, please? I have been reading BOL on
the different types of replication: Merge, Transactional, and Snapshot. I am
trying to determine what is the best for our situation. It sounds like when
using Snapshot replication (if data on the subscriber could only be 15
minutes old at tops), that applying the Snapshot every 15 minutes, if a user
tried to generate a report while the Snapshot was being applied, then the
user might not have very good response time, depending on the size of the
Snapshot. Is that correct?
Arnie Rowland wrote:[vbcol=seagreen]
>In that case, some form of replication is in order -look into MERGE
>Replication.
>
>[quoted text clipped - 15 lines]
Message posted via http://www.droptable.com