Hi, all experts here,
Thank you very much for your kind attention.
I wanna know how can we limit the data regions in a specific report page. How can we achieve this? Really need help.
Thanks a lot in advance for any guidance and advices for that.
With best regards,
Yours sincerely,
Hiya,
Would please any expert here give me any guidance and advices for that?
Thanks a lot.
With best regards,
Yours sincerely,
Hi, experts,
Thanks for your kind attention.
I wanna know how can we format percentage values with 2 decimals (e.g. 98.88%)?
I am looking forward to hearing from you shortly and thanks a lot in advance.
With kindest regards,
Yours sincerely,
If it is a measure try the format property in the Properties tab. Or do you need something else?
Cheers
|||Hi,
Thank you for your reply.
Yes, I cant find the format for defining the decimal places for percentage values in the format property tab?
I am looking forward to hearing from you.
With kindest regards,
Yours sincerely,
|||Actually there isn't one :-) . The building option for percentage always uses 2 decimal places. Else I think that you would have to specify your own format if you need percentage with more than 2 decimal places.
cheers
|||Hi,
Thanks for that.
Kind regards,
|||Hello Helen! Try "###.##%" or "000.00%" for the calculated member!
You will figure out how they work!
HTH
Thomas Ivarsson
|||Hi, Thomas,
Thanks very much for your advices.
With kindest regards,
Yours sincerely,
Hi, experts,
Thanks for your kind attention.
I wanna know how can we format percentage values with 2 decimals (e.g. 98.88%)?
I am looking forward to hearing from you shortly and thanks a lot in advance.
With kindest regards,
Yours sincerely,
If it is a measure try the format property in the Properties tab. Or do you need something else?
Cheers
|||Hi,
Thank you for your reply.
Yes, I cant find the format for defining the decimal places for percentage values in the format property tab?
I am looking forward to hearing from you.
With kindest regards,
Yours sincerely,
|||Actually there isn't one :-) . The building option for percentage always uses 2 decimal places. Else I think that you would have to specify your own format if you need percentage with more than 2 decimal places.
cheers
|||Hi,
Thanks for that.
Kind regards,
|||Hello Helen! Try "###.##%" or "000.00%" for the calculated member!
You will figure out how they work!
HTH
Thomas Ivarsson
|||Hi, Thomas,
Thanks very much for your advices.
With kindest regards,
Yours sincerely,
Hi, experts,
Thanks for your kind attention.
I wanna know how can we format percentage values with 2 decimals (e.g. 98.88%)?
I am looking forward to hearing from you shortly and thanks a lot in advance.
With kindest regards,
Yours sincerely,
If it is a measure try the format property in the Properties tab. Or do you need something else?
Cheers
|||Hi,
Thank you for your reply.
Yes, I cant find the format for defining the decimal places for percentage values in the format property tab?
I am looking forward to hearing from you.
With kindest regards,
Yours sincerely,
|||Actually there isn't one :-) . The building option for percentage always uses 2 decimal places. Else I think that you would have to specify your own format if you need percentage with more than 2 decimal places.
cheers
|||Hi,
Thanks for that.
Kind regards,
|||Hello Helen! Try "###.##%" or "000.00%" for the calculated member!
You will figure out how they work!
HTH
Thomas Ivarsson
|||Hi, Thomas,
Thanks very much for your advices.
With kindest regards,
Yours sincerely,
Hi all,
Could you tell the correct way to use Reporting Services on ASP.NET pages?
Now I wanna create an ASP.NET page to show some reports, and I hope to control all logic by program, so I need know the API between ASP.NET and Reporting Services.
For example, I wanna pass some data to Reporting Services via API, and then Reporting Services handle the data and return reports to me, and then I can show the reports on my web pages.
Please tell me how?
Hi Xinwen.You can use the Report control and give hime the link to your report so it will show in side the control.
You don't interact with the report like you described - You can interact with the report with PARAMETERS passing through the URL.
So whan you give the report control the report url you can add to that url parameters that the report should get (like person id or project number) and also to change things in the report (like open it in diffrent ways, change the zoom, automaticlly export to pdf and so on) with the url command parameters.
for exm:
ttp://reportserver/myreportfolder/reportname.rdl?rc:format=PDF will export it to pdf.
search google about "report service url parameters"
good luck,
Roy.|||Thanks Roy!
Hi all,
Could you tell the correct way to use Reporting Services on ASP.NET pages?
Now I wanna create an ASP.NET page to show some reports, and I hope to control all logic by program, so I need know the API between ASP.NET and Reporting Services.
For example, I wanna pass some data to Reporting Services via API, and then Reporting Services handle the data and return reports to me, and then I can show the reports on my web pages.
Please tell me how?
Hi Xinwen.You can use the Report control and give hime the link to your report so it will show in side the control.
You don't interact with the report like you described - You can interact with the report with PARAMETERS passing through the URL.
So whan you give the report control the report url you can add to that url parameters that the report should get (like person id or project number) and also to change things in the report (like open it in diffrent ways, change the zoom, automaticlly export to pdf and so on) with the url command parameters.
for exm:
ttp://reportserver/myreportfolder/reportname.rdl?rc:format=PDF will export it to pdf.
search google about "report service url parameters"
good luck,
Roy.
|||Thanks Roy!|||
Hi,
|||I tried with this but instead of prompting to save Excel File,it is displaying the report
http://localhost/Reports/Pages/Report.aspx?ItemPath=NameOfReport&rs:Command=Renderl&rs:Format=Excel
-Thanks,
Digant Desai
In Visual studio 2005,there is a report veiwer contrlo to view your RDL reports.
U need to link report viewer control to corresponding report in Reporting service project.This u can do
by setting Propertis of report viewer.
You can also pass parameters form ASP page to rdl file.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer2.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
this.ReportViewer2.Visible = true;
this.ReportViewer2.ServerReport.ReportServerUrl = new System.Uri("http://localhost/ReportServer");
string strReport = "/ReportProject14/Report1";
this.ReportViewer2.ServerReport.ReportPath = strReport;
Microsoft.Reporting.WebForms.ReportParameter[] RptParameters =
new Microsoft.Reporting.WebForms.ReportParameter[3];
string strComp = this.DropDownList1.SelectedItem.Value;
RptParameters[0] =
new Microsoft.Reporting.WebForms.ReportParameter("INTCOMPANYKEY", strComp);
string strFacility = this.DropDownList3.SelectedItem.Value;
RptParameters[1] =
new Microsoft.Reporting.WebForms.ReportParameter("INTFACILITYKEY", strFacility);
string strActivity = this.DropDownList2.SelectedItem.Value;
RptParameters[2] =
new Microsoft.Reporting.WebForms.ReportParameter("Activity", strActivity);
this.ReportViewer2.ServerReport.SetParameters(RptParameters);
this.ReportViewer2.ServerReport.Refresh();
}
}
