Showing posts with label creating. Show all posts
Showing posts with label creating. Show all posts

Wednesday, March 28, 2012

ReportViewer Component

Hi all,

I'm creating a custom interface for reporting services but I am having a few problems. This is my environment:

Using the ReportViewer component in remote mode to show my reports of the report server. There are 2 user levels of which any user can be apart of, Admin & user. In every report, there is a parameter called MERCHANTID, when the user who logs in (via custom login interface) is of group admin, then the merchantid parameter gets prompted before the report is run, if the group of the user is "user" then the merchantid parameter is hidden, and is passed programatically to the report. The report path also

My Questions:

1. When my reportviewer component loads up the report and prompts for a parameter, when you select a parameter value or type it in, it just posts back with no results, just the parameter prompt again with no data... How can this be corrected?

2. How do I pass report parameters programatically... so that when my user id of group "user" then "merchantid" gets passed automatically, but if there is any more parameters, then that gets prompted...

Thanks for your help.

For issue #1: You are probably setting the report path or server url after the LoadViewState event, most likely during load. When you set this value, the viewer sees it as defining a new report. So it ignores input from the client, thinking it applies to the old report. You should be setting this information during Init or only if it is the GET request (!Page.IsPostback), depending on your architecture.

For issue #2: You can programmatically set the parameter value using ReportViewer.ServerReport.SetParameters(). Each ReportParameter object you pass in has a Visible property on it. If you set this to false when setting the report parameter, the client will not see a prompt for that parameter.

|||

Hey man,

Thanks alot for the response, I tried moving my code to the init code, and that worked great.... could you help me with the 2nd part though? This is what I need to do:

If Userlevel = 1 then the report parameter called "MERCHANTID" (If the report has it)needs to be visible for prompting. Else, "MERCHANTID" is hidden and the value session.item("MerchantID") is passed as the value.

This is the code I'm currently using, but not working.

Dim Param As ReportParameter = New ReportParameter
If Not UserLevel = 1 Then
If Param.Name = "MERCHANTID" Then
Param.PromptUser = False
Param.Equals(Session.Item("MerchantID"))
End If
Else
Param.PromptUser = True
Param.DefaultValues = Session.Item("MerchantID")
End If
ReportViewer1.ServerReport.SetParameters(Param)

And this is the error I'm getting... Line 54 is the last line in the example I'm giving.

System.InvalidCastException: Unable to cast object of type 'ReportServer2005.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'. at Report.Page_Init(Object sender, EventArgs e) in \\Nccptws001\wwwroot\NetReports\Report.aspx.vb:line 54

Thanks

|||

The compiler is complaining about the last line. SetParameters takes an array of ReportParameter objects, not a single one.

But there are many other problems with your code. Param.Name is always empty string until you set it, so it will never equal "MerchantId". ReportParameter doesn't have a PromptUser or DefaultValues property. The property to set for visibility is Visible, not PromptUser. The property to set the value is Values not DefaultValues. See this help page for more information about ReportParameter: http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.reportparameter_properties(VS.80).aspx

|||

Hi Brian,

Sorry for besing such a wuss, but could you help me with the code to achieve this? How could I set the merchantid field and actually first check if the merchantid parameter does exist on this report?

Thanks Brian.

Rudi Groenewald

|||

Hi Brian,

I'm trying the following code, but no luck yet:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl = New Uri(Http://REPORTSERVER/Reportserver)
ReportViewer1.ServerReport.ReportPath = ReportPath

'SET THE REPORT PARAMETERS
Dim instance As New Microsoft.Reporting.WebForms.ReportParameter
If Not UserLevel = 1 Then
instance.Name = "MERCHANTID"
instance.Values.Add(Session.Item("merchantID"))
instance.Visible = False
Else
instance.Name = "MERCHANTID"
instance.Values.Add(Session.Item("merchantID"))
instance.Visible = True
End If
ReportViewer1.ServerReport.SetParameters(instance)

And I'm getting the error:

System.InvalidCastException: Unable to cast object of type 'Microsoft.Reporting.WebForms.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'. at Report.Page_Init(Object sender, EventArgs e) in \\Nccptws001\wwwroot\NetReports\Report.aspx.vb:line 58

It's still moaning at the last line.

and I still don't want to pass the "MerchantID" parameter if the report doesn't have report parameters.... Any ideas?

Thanks alot for the help.

Regards,

Rudi Groenewald

|||The rest of your code looks good now, but you are still passing in a single instance of ReportParameter to SetParameters. The method takes an array of ReportParameter.|||

Hi Brian,

ok.. but that's the only parameter I want to pass... I don't quite understand what you're saying....

|||The method takes an IEnumerable. If you want to pass a single report parameter, you still need to pass an array of one element.|||

Hi Brian...

Ok, Thanks, I understand now what I should do... but how do I do it?

Could you give me some sample code?

Thanks

|||This should work

'SET THE REPORT PARAMETERS
Dim instance As New Microsoft.Reporting.WebForms.ReportParameter
...
dim prms(0) as Microsoft.Reporting.WebForms.ReportParameter
prms(0) = instance

ReportViewer1.ServerReport.SetParameters(prms)sql

ReportViewer Component

Hi all,

I'm creating a custom interface for reporting services but I am having a few problems. This is my environment:

Using the ReportViewer component in remote mode to show my reports of the report server. There are 2 user levels of which any user can be apart of, Admin & user. In every report, there is a parameter called MERCHANTID, when the user who logs in (via custom login interface) is of group admin, then the merchantid parameter gets prompted before the report is run, if the group of the user is "user" then the merchantid parameter is hidden, and is passed programatically to the report. The report path also

My Questions:

1. When my reportviewer component loads up the report and prompts for a parameter, when you select a parameter value or type it in, it just posts back with no results, just the parameter prompt again with no data... How can this be corrected?

2. How do I pass report parameters programatically... so that when my user id of group "user" then "merchantid" gets passed automatically, but if there is any more parameters, then that gets prompted...

Thanks for your help.

For issue #1: You are probably setting the report path or server url after the LoadViewState event, most likely during load. When you set this value, the viewer sees it as defining a new report. So it ignores input from the client, thinking it applies to the old report. You should be setting this information during Init or only if it is the GET request (!Page.IsPostback), depending on your architecture.

For issue #2: You can programmatically set the parameter value using ReportViewer.ServerReport.SetParameters(). Each ReportParameter object you pass in has a Visible property on it. If you set this to false when setting the report parameter, the client will not see a prompt for that parameter.

|||

Hey man,

Thanks alot for the response, I tried moving my code to the init code, and that worked great.... could you help me with the 2nd part though? This is what I need to do:

If Userlevel = 1 then the report parameter called "MERCHANTID" (If the report has it)needs to be visible for prompting. Else, "MERCHANTID" is hidden and the value session.item("MerchantID") is passed as the value.

This is the code I'm currently using, but not working.

Dim Param As ReportParameter = New ReportParameter
If Not UserLevel = 1 Then
If Param.Name = "MERCHANTID" Then
Param.PromptUser = False
Param.Equals(Session.Item("MerchantID"))
End If
Else
Param.PromptUser = True
Param.DefaultValues = Session.Item("MerchantID")
End If
ReportViewer1.ServerReport.SetParameters(Param)

And this is the error I'm getting... Line 54 is the last line in the example I'm giving.

System.InvalidCastException: Unable to cast object of type 'ReportServer2005.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'. at Report.Page_Init(Object sender, EventArgs e) in \\Nccptws001\wwwroot\NetReports\Report.aspx.vb:line 54

Thanks

|||

The compiler is complaining about the last line. SetParameters takes an array of ReportParameter objects, not a single one.

But there are many other problems with your code. Param.Name is always empty string until you set it, so it will never equal "MerchantId". ReportParameter doesn't have a PromptUser or DefaultValues property. The property to set for visibility is Visible, not PromptUser. The property to set the value is Values not DefaultValues. See this help page for more information about ReportParameter: http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.reportparameter_properties(VS.80).aspx

|||

Hi Brian,

Sorry for besing such a wuss, but could you help me with the code to achieve this? How could I set the merchantid field and actually first check if the merchantid parameter does exist on this report?

Thanks Brian.

Rudi Groenewald

|||

Hi Brian,

I'm trying the following code, but no luck yet:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl = New Uri(Http://REPORTSERVER/Reportserver)
ReportViewer1.ServerReport.ReportPath = ReportPath

'SET THE REPORT PARAMETERS
Dim instance As New Microsoft.Reporting.WebForms.ReportParameter
If Not UserLevel = 1 Then
instance.Name = "MERCHANTID"
instance.Values.Add(Session.Item("merchantID"))
instance.Visible = False
Else
instance.Name = "MERCHANTID"
instance.Values.Add(Session.Item("merchantID"))
instance.Visible = True
End If
ReportViewer1.ServerReport.SetParameters(instance)

And I'm getting the error:

System.InvalidCastException: Unable to cast object of type 'Microsoft.Reporting.WebForms.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'. at Report.Page_Init(Object sender, EventArgs e) in \\Nccptws001\wwwroot\NetReports\Report.aspx.vb:line 58

It's still moaning at the last line.

and I still don't want to pass the "MerchantID" parameter if the report doesn't have report parameters.... Any ideas?

Thanks alot for the help.

Regards,

Rudi Groenewald

|||The rest of your code looks good now, but you are still passing in a single instance of ReportParameter to SetParameters. The method takes an array of ReportParameter.|||

Hi Brian,

ok.. but that's the only parameter I want to pass... I don't quite understand what you're saying....

|||The method takes an IEnumerable. If you want to pass a single report parameter, you still need to pass an array of one element.|||

Hi Brian...

Ok, Thanks, I understand now what I should do... but how do I do it?

Could you give me some sample code?

Thanks

|||This should work

'SET THE REPORT PARAMETERS
Dim instance AsNew Microsoft.Reporting.WebForms.ReportParameter
...
dim prms(0) as Microsoft.Reporting.WebForms.ReportParameter
prms(0) = instance

ReportViewer1.ServerReport.SetParameters(prms)

ReportViewer Code Behind?

Is there anyway to apply code behind to a report viewer? For example I am creating a form that has 4 text boxes. Depending on the record being pulled from the database, I want to put an "X" in one of those four text boxes.

So, it would be ideal to write some kind of conditional statement that will do this for me.

Is this possible?

You can easily pass parameters to the reports using report viewer check this links it will be great help

http://www.gotreportviewer.com/
http://www.gotreportviewer.com/localmodeparameters/index.html
http://msdn2.microsoft.com/en-us/library/ms251685(VS.80).aspx

|||

Thanks for the reply. However, I don't know if this will help me? I found the second article interesting, but it talks about checkboxes. There is no checkbox option in the reportviewer toolbox (only Pointer, Textbox, Line, Table, Matrix, Rectangle, List, Image, Subreport, & Chart).

Anyway, the sample is kind of vague. I'm new to .NET so I'm having a difficult time following this. Let me try to simplfiy my question:

In my .rdlc reportviewer I have a text box named "bobText". There is nothing in the text box right now. From the Web page, I am clicking on a specific person or record in the database. Clicking on this link opens this form. Depending on what person I clicked on from the Web page will determine what text is put into "bobText". So, in my .aspx page, how do I populate the value of "bobText" with whatever I want?

|||

I believe I figured it out using these URLs. Thanks for your help.

|||

Could you show us how you did it? I am having the same problem.

Thanks

Will

|||

Sure.

In your RDLC design, put a textbox out there. For an example, let's say the name of the text box is "phoneNumber".

Choose "Report" from the Properties drop down. Look for "ReportParameters" and click the "..." button to open Report Parameters dialog box. Name your parameter (ie: phoneText). Check the "hidden" check box if this field is initially empty. Click "Ok"

Click back on the "phoneNumber" text box. In the properties, find "Value" and enter this: =Parameters!phoneText.Value

That's all for the RDLC file. Now open up your aspx code behind. I use C#, so I'd open my aspx.cs file.

Also, I used a dataset for this. My dataset name is DataSet1.

In the code behind, you will need to add the following lines:

using Microsoft.Reporting.WebForms;
using DataSet1TableAdapters;

Change "DataSet1" to whatever the name of your dataset is.

In your class before the Page_Load subroutine, you'll need to add this:

view_PERSONNEL_RPTSTableAdapter RptAdapter =newview_PERSONNEL_RPTSTableAdapter();
ReportParameter phoneParam =newReportParameter();

Now, "view_PERSONNEL_RPTS" is the name of the view that's being accessed in my dataset. You should change this accordingly.

In your Page_Load subroutine, here's what you'll need. Here I am getting the row of data from the database and checking for values. It may not be exactly how you're doing it but it should still help.

DataSet1.view_PERSONNEL_RPTSDataTable GetEmpDatatable =newDataSet1.view_PERSONNEL_RPTSDataTable();
GetEmpDatatable = RptAdapter.GetData_RosterForm(id); // id is a variable I pass from the Web site. GetData_RosterForm is from my TableAdapter

DataSet1.view_PERSONNEL_RPTSRow GetEmpRow;
GetEmpRow = GetEmpDatatable[0]; // This gets the row of data and stores it into GetEmpRow

phoneParam.Name = "phoneText"; // This references the parameter we set in the RDLC file.

switch (GetEmpRow.TYPE.ToString().ToUpper())
{


case"CUSTOMER SERVICE":
phoneParam.Values.Add("1-800-555-1212");
break;

case"TECH SUPPORT":
phoneParam.Values.Add("1-800-555-TECH");
break;

default:
phoneParam.Values.Add("1-800-555-BLAH");
break;
}

ReportParameter[] p = { phoneParam };

try
{
this.ReportViewer1.LocalReport.SetParameters(p);

}

catch (Exception err)
{

Response.Write(err);

}

That's it! You can add as many parameters you want. Just make sure to add any other parameters to theReportParameter[] p array.
Hope it helps.

Jeremy

ReportViewer and Click through links

I am creating a .Net application using the ReportViewer, which is working fine.
But when I have a report that has a link to another report, upon clicking
the link it takes the new report to full screen.
What I want to happen is for the new report stay in the ReportViewer.
Any ideas?
--
Regards
<<<Bryan Avery>>Ok I just did this and it was kind of a pain. Too me all day to work it out.
1. You need to use 'Jump to URL' instead of the other options.
2. Open Report Viewer project and add the following code:
Private _linktarget As String = "_self"
<Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
iFrame target")> _
Public Property LinkTarget() As String
Get
Return Me._linktarget
End Get
Set(ByVal Value As String)
Me._linktarget = Value
Me.SetParameter("rc:LinkTarget", Value)
End Set
End Property
3. Recompile and place dll in project bin.
Now the default is _self and you have the option to change the target from
your code.
This solution isn't ideal because you have to use the jump to url which
means more work in creating the url with params, and you may have to hard
code your servername.
--
Message posted via http://www.sqlmonster.com|||Hi Patrick,
Thanks for the quick response, but I'm a little lost to where I should be
entering line 2, could you give me any more pointers please?
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> Ok I just did this and it was kind of a pain. Too me all day to work it out.
> 1. You need to use 'Jump to URL' instead of the other options.
> 2. Open Report Viewer project and add the following code:
> Private _linktarget As String = "_self"
> <Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
> iFrame target")> _
> Public Property LinkTarget() As String
> Get
> Return Me._linktarget
> End Get
> Set(ByVal Value As String)
> Me._linktarget = Value
> Me.SetParameter("rc:LinkTarget", Value)
> End Set
> End Property
> 3. Recompile and place dll in project bin.
> Now the default is _self and you have the option to change the target from
> your code.
> This solution isn't ideal because you have to use the jump to url which
> means more work in creating the url with params, and you may have to hard
> code your servername.
> --
> Message posted via http://www.sqlmonster.com
>|||No problem. There are a few changes I discovered since the last post, I'll
note them the end here.
You can find the reportviewer project here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\
Applications\ReportViewer\vb
Open the project and open the ReportViewer.vb class file.
in the "Private Member Variables" region add:
Private _linktarget As String = "_self"
in the "Properties" region add the property in the above thread.
Now here is the addition to the above.
in the "Render" region add the following line to the Render sub:
output.WriteAttribute("name", "ifmReport")
You need this when you call the viewer property you created. Compile and
drop in your bin/GAC.
So now in your app you will add the following line:
rvwReport.LinkTarget = "ifmReport"
rvwReport being your declared instance of the object. In this bit of code:
Protected WithEvents rvwReport As
Microsoft.Samples.ReportingServices.ReportViewer
Now the good news is that I discovered that the "Jump to Report" option
works when I do this, which is great because the "Jump to URL" was a real
pain.
I'm assuming you are a VB and not a C# person.
Hope this helps... now I'm off to post more questions.
--
Message posted via http://www.sqlmonster.com|||Good news is that it is working :-)
Bad news is, it is only working in part.
What I mean is that you can display the first report, and a click to the
next report works okay, but on the third click to the third report it goes
back to full screen :-(
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> No problem. There are a few changes I discovered since the last post, I'll
> note them the end here.
> You can find the reportviewer project here:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\
> Applications\ReportViewer\vb
> Open the project and open the ReportViewer.vb class file.
> in the "Private Member Variables" region add:
> Private _linktarget As String = "_self"
> in the "Properties" region add the property in the above thread.
> Now here is the addition to the above.
> in the "Render" region add the following line to the Render sub:
> output.WriteAttribute("name", "ifmReport")
> You need this when you call the viewer property you created. Compile and
> drop in your bin/GAC.
> So now in your app you will add the following line:
> rvwReport.LinkTarget = "ifmReport"
> rvwReport being your declared instance of the object. In this bit of code:
> Protected WithEvents rvwReport As
> Microsoft.Samples.ReportingServices.ReportViewer
> Now the good news is that I discovered that the "Jump to Report" option
> works when I do this, which is great because the "Jump to URL" was a real
> pain.
> I'm assuming you are a VB and not a C# person.
> Hope this helps... now I'm off to post more questions.
> --
> Message posted via http://www.sqlmonster.com
>|||I know, I'm trying to work that out now. So annoying, thought I had it solved.
Seems that when the report goes back to the server it "forgets" the target
and goes back to "_top". :-\ There has to be a config setting on the server
that we can change. So can anyone out there find it?
--
Message posted via http://www.sqlmonster.com|||Thanks for all your effort.
I was wondering if you know how we can control the tool bar that is within
the ReportViewer so we can have external controls controlling the Zoom,
Export, etc.
Is this something you've come across and is it easy to do?
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> I know, I'm trying to work that out now. So annoying, thought I had it solved.
> Seems that when the report goes back to the server it "forgets" the target
> and goes back to "_top". :-\ There has to be a config setting on the server
> that we can change. So can anyone out there find it?
> --
> Message posted via http://www.sqlmonster.com
>

Monday, March 26, 2012

Reportviewer - few questions...

Hello!
I need help with my page.., If someone would help me (information or link)
how to do any step...
I'm creating a asp.net page with reportviewer control.
My idea is:
- three parameters to list (standart dropdownlist like in Reporting
Services)
a) computername (query from database "SELECT ComputerName FROM DATA")
b) countername (query from database "SELECT CounterName FROM COUNTERS")
c) countertype (query from database "SELECT CounterType FROM COUNTERS")
In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
cannot set "Available values - from query"...
So my question is "How to fill parameter with values from SQL database?"
Thanks for helpC#:
ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
ReportParameter rp2 = new ReportParameter("userID", userID, false);
ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
rp2 });
Leszek wrote:
> Hello!
> I need help with my page.., If someone would help me (information or link)
> how to do any step...
> I'm creating a asp.net page with reportviewer control.
> My idea is:
> - three parameters to list (standart dropdownlist like in Reporting
> Services)
> a) computername (query from database "SELECT ComputerName FROM DATA")
> b) countername (query from database "SELECT CounterName FROM COUNTERS")
> c) countertype (query from database "SELECT CounterType FROM COUNTERS")
> In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
> cannot set "Available values - from query"...
> So my question is "How to fill parameter with values from SQL database?"
> Thanks for help|||Thanks!!
I made it other way - ojectdatasource, that is created on load aspx page.
Uzytkownik <mark.feferman@.gmail.com> napisal w wiadomosci
news:1149797507.592285.30150@.i39g2000cwa.googlegroups.com...
> C#:
> ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
> ReportParameter rp2 = new ReportParameter("userID", userID, false);
> ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
> rp2 });
>
> Leszek wrote:
>> Hello!
>> I need help with my page.., If someone would help me (information or
>> link)
>> how to do any step...
>> I'm creating a asp.net page with reportviewer control.
>> My idea is:
>> - three parameters to list (standart dropdownlist like in Reporting
>> Services)
>> a) computername (query from database "SELECT ComputerName FROM DATA")
>> b) countername (query from database "SELECT CounterName FROM
>> COUNTERS")
>> c) countertype (query from database "SELECT CounterType FROM
>> COUNTERS")
>> In Reporting Services 2.0 (SP2) where three tabs - data, layout and
>> preview.
>> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
>> cannot set "Available values - from query"...
>> So my question is "How to fill parameter with values from SQL database?"
>> Thanks for help
>sql

Friday, March 23, 2012

reportservertempdb

We are working on creating a copy of our SQL server machine for disaster
recovery purposes. ReportServerTempDB is purely a temp database, correct?
Meaning, the data in it does not need to be replicated from our production
server to our disaster recovery server, correct?
Could someone just verify this for me.
Thanks.Yes, you don't need to replicated your ReportServerTempDB
According to BOL "Backup and Restore Operations for a Reporting Services
Installation"
The only reason to backup the reportservertempdb is to avoid having to
recreate it if there is a hardware failure.
Med bouchenafa
"Jeff" <Jeff@.discussions.microsoft.com> a écrit dans le message de news:
C440E7E5-D027-4C98-9A8B-EA0C8C2B245B@.microsoft.com...
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Depends... are you talking disaster recovery... in which you would
re-establish services from a repository of stored data? ...or... are you
looking for fault tollerance where a more real-time fail over takes place
imediately after the falure due to disaster?
"Jeff" wrote:
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Ken,
We're looking a the former. We have an offsite repository of data, which we
would use to re-establish services in the event of a fire or something like
that. This isn't for real time failover.
"Ken Carter" wrote:
> Depends... are you talking disaster recovery... in which you would
> re-establish services from a repository of stored data? ...or... are you
> looking for fault tollerance where a more real-time fail over takes place
> imediately after the falure due to disaster?
> "Jeff" wrote:
> > We are working on creating a copy of our SQL server machine for disaster
> > recovery purposes. ReportServerTempDB is purely a temp database, correct?
> > Meaning, the data in it does not need to be replicated from our production
> > server to our disaster recovery server, correct?
> >
> > Could someone just verify this for me.
> >
> > Thanks.

Monday, March 12, 2012

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/

Monday, February 20, 2012

Reporting Services-getting started

Someone pleeeease help me. I need help creating a report. A simple report
in SQL 2005. I use Access and ADP's all the time - the reports are very easy
to create, modify, etc. I'd like to know how to make a report using
Reporting Services. The "help" is of no use - I can't understand how to even
use the report wizard. It seems like there are 610 different ways to do one
simple thing - create a report.
I have views of data that I have created that I need to present - in report
format, with groupings, totals, etc. Can someone please tell me how to do
this?
Also, what are the benefits of using reporting services versus just creating
an ADP and developing reports the old fashioned way? Seriously, what ARE the
benefits?
Any help would be very welcomed. Thanks.
--
FrustratedHey Craig,
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
What's ADP? I worked with Access but this acronym is missing in my
vocabulary.
A damn good book (although on RS 2000) is the Hitchhikers Guide to Reporting
Services.
About RS: Sorry but to me it looks pretty straightforward. You create a
report, create datasets that query a datasource that you might have to
create. Then you stick those into the report and format them. W/o more
detailed information about where you're stuck it's hard to help you.
Christoph|||If ADPs are doing what you need then I would suggest just continuing with
them.
ADPs require Access to be installed at each PC. And the same version of
Access. If this is not a problem and it is working well for you then you can
just continue to use them.
RS is a server based product. You develop and then deploy. As a server based
product there is more infrastructure to setup (versus ADPs). You have to
know about IIS, Windows 2003 and SQL Server.
Access is a much more mature product and in my opion has better wizards. RS
would do well to add additional wizards. But that being said, if you create
a report using the wizard in RS it does allow you to group and it adds the
group and totals for you. Have you tried something simple just to test?
Advantages of RS. Server based, clients only need a browser. Format
independent reports, render to different formats: Html, Excel, PDF, CSV etc.
Can integrate with own apps either with URL integration, web services or
controls which ship with VS 2005.
One other point, there are walkthroughs but they start from scratch, not
using the wizard. I suggest first creating some sample reports using the
wizard and then modifying the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
> Any help would be very welcomed. Thanks.
> --
> Frustrated|||In Books Online look for Report Wizard. There will be two hits for it. Look
at report wizard help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig" <Craig@.discussions.microsoft.com> wrote in message
news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> Someone pleeeease help me. I need help creating a report. A simple
> report
> in SQL 2005. I use Access and ADP's all the time - the reports are very
> easy
> to create, modify, etc. I'd like to know how to make a report using
> Reporting Services. The "help" is of no use - I can't understand how to
> even
> use the report wizard. It seems like there are 610 different ways to do
> one
> simple thing - create a report.
> I have views of data that I have created that I need to present - in
> report
> format, with groupings, totals, etc. Can someone please tell me how to do
> this?
> Also, what are the benefits of using reporting services versus just
> creating
> an ADP and developing reports the old fashioned way? Seriously, what ARE
> the
> benefits?
> Any help would be very welcomed. Thanks.
> --
> Frustrated|||Thanks for the help...
--
Craig
"Bruce L-C [MVP]" wrote:
> In Books Online look for Report Wizard. There will be two hits for it. Look
> at report wizard help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Craig" <Craig@.discussions.microsoft.com> wrote in message
> news:6137FDEC-B961-48F9-BA30-89ECFECF9AE9@.microsoft.com...
> > Someone pleeeease help me. I need help creating a report. A simple
> > report
> > in SQL 2005. I use Access and ADP's all the time - the reports are very
> > easy
> > to create, modify, etc. I'd like to know how to make a report using
> > Reporting Services. The "help" is of no use - I can't understand how to
> > even
> > use the report wizard. It seems like there are 610 different ways to do
> > one
> > simple thing - create a report.
> >
> > I have views of data that I have created that I need to present - in
> > report
> > format, with groupings, totals, etc. Can someone please tell me how to do
> > this?
> >
> > Also, what are the benefits of using reporting services versus just
> > creating
> > an ADP and developing reports the old fashioned way? Seriously, what ARE
> > the
> > benefits?
> >
> > Any help would be very welcomed. Thanks.
> >
> > --
> > Frustrated
>
>

Reporting Services, Visual Studio, Layout, Grouping

I'm creating a report with Visual Studio 2003 and the reporting services
project.
I'd like to group like:
1/04
$20
2/04
$30
Right now I'm getting the grouping:
1/1/04
$10
1/2/04
$10
1/3/04
$10
The data is stored on a daily basis and it needs to be summed by month.
Thanks,
JimI assume you have a field representing a DateTime object and you want to
group by month. Keep in mind, you can group on any function - so try this as
grouping expression:
=Year(Fields!SalesDate.Value)*100 + Month(Fields!SalesDate.Value)
Documentation on Year() and Month() is available on MSDN:
* http://msdn.microsoft.com/library/en-us/vblr7/html/vafctyear.asp
* http://msdn.microsoft.com/library/en-us/vblr7/html/vafctMonth.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:126E457A-AACF-4F28-B809-EE607A3BE6A8@.microsoft.com...
> I'm creating a report with Visual Studio 2003 and the reporting services
> project.
> I'd like to group like:
> 1/04
> $20
> 2/04
> $30
> Right now I'm getting the grouping:
> 1/1/04
> $10
> 1/2/04
> $10
> 1/3/04
> $10
> The data is stored on a daily basis and it needs to be summed by month.
> Thanks,
> Jim

Reporting Services, Charts with time-scale axis

Hi all,
Firstly sorry if this is the wrong place to be posting
this question ... it's the most appropriate newsgroup I
could find.
I'm creating a report using reporting services and I'm
including a graph thats shows number of times something
is accessed per day over time. Data coming from an SQL
Server 2000 database. The dataset will only have data
records in if the item is accessed ... i.e. if it is not
accessed in a particular day then no record is present.
I've therefore made the chart time-scale in the x-axis to
ensure the scaling is correct. I've even included a union
query to a blank set of data for todays date such that the
graph will always extend up to the current date. The
report has a parameter such that a filter can be applied
to the data to show particular sections only (i.e.
accesses by a particular individual) This all works fine
for when there is a relatively large set of records post
filter and the charts look good.
The problem comes when there is only a small amount of
data, say three points, over a large period of time. The
scaling on the x-axis is correct and runs from the first
data items date up until the current date. The problem is
that the width of each column is massive and spans maybe 7
days. It looks to me as though the width of the columns is
calculated according to the number of the points (in this
example 3) and not according to the number of "time-sacle
points" maybe 100. The result is three hugely wide bars
each spanning a weeks worth of dates with the left hand
edge on the date of the actual event.
I could try and introduce zero data into the data set for
each of the intervening dates but didn't want to go to
through the overhead of calculating all this unnecessary
data ... that is after all the point of a time-scale axis.
Would appreciate it is anyone has any experience in this
or ideas I could try.
Thanks in advance (and for reading this far!)
Matt.
Matt,
Just to let you know that there is an RS group: .reportingsvcs. I think you have much better change
to get good help there.
Yesterday I read a post referring to editing the rdl file and pitting in the width there. Check the
archives, search for <PointWidth>.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt Williams" <anonymous@.discussions.microsoft.com> wrote in message
news:064501c49af9$4753e070$a401280a@.phx.gbl...
> Hi all,
> Firstly sorry if this is the wrong place to be posting
> this question ... it's the most appropriate newsgroup I
> could find.
> I'm creating a report using reporting services and I'm
> including a graph thats shows number of times something
> is accessed per day over time. Data coming from an SQL
> Server 2000 database. The dataset will only have data
> records in if the item is accessed ... i.e. if it is not
> accessed in a particular day then no record is present.
> I've therefore made the chart time-scale in the x-axis to
> ensure the scaling is correct. I've even included a union
> query to a blank set of data for todays date such that the
> graph will always extend up to the current date. The
> report has a parameter such that a filter can be applied
> to the data to show particular sections only (i.e.
> accesses by a particular individual) This all works fine
> for when there is a relatively large set of records post
> filter and the charts look good.
> The problem comes when there is only a small amount of
> data, say three points, over a large period of time. The
> scaling on the x-axis is correct and runs from the first
> data items date up until the current date. The problem is
> that the width of each column is massive and spans maybe 7
> days. It looks to me as though the width of the columns is
> calculated according to the number of the points (in this
> example 3) and not according to the number of "time-sacle
> points" maybe 100. The result is three hugely wide bars
> each spanning a weeks worth of dates with the left hand
> edge on the date of the actual event.
> I could try and introduce zero data into the data set for
> each of the intervening dates but didn't want to go to
> through the overhead of calculating all this unnecessary
> data ... that is after all the point of a time-scale axis.
> Would appreciate it is anyone has any experience in this
> or ideas I could try.
> Thanks in advance (and for reading this far!)
> Matt.
|||Thank you very much for your help ... it gives me
somewhere to start ...
Matt.

>--Original Message--
>Matt,
>Just to let you know that there is an RS
group: .reportingsvcs. I think you have much better
change
>to get good help there.
>Yesterday I read a post referring to editing the rdl
file and pitting in the width there. Check the
>archives, search for <PointWidth>.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Matt Williams" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:064501c49af9$4753e070$a401280a@.phx.gbl...
not[vbcol=seagreen]
to[vbcol=seagreen]
union[vbcol=seagreen]
the[vbcol=seagreen]
applied[vbcol=seagreen]
fine[vbcol=seagreen]
post[vbcol=seagreen]
The[vbcol=seagreen]
first[vbcol=seagreen]
is[vbcol=seagreen]
maybe 7[vbcol=seagreen]
columns is[vbcol=seagreen]
this[vbcol=seagreen]
sacle[vbcol=seagreen]
for[vbcol=seagreen]
unnecessary[vbcol=seagreen]
axis.[vbcol=seagreen]
this
>
>.
>