or
1 answer
87 views
Hi,
I installed telerik reporting in my system and i am using visual studio 2005. When i start "new project in windows application", i can able to see all the reporting toolbox with all reporting controls but when i start "new website" i can able to see only report viewer.
Basically i want to develop report for the website. Frankly speaking i don't have any idea developing reporting using telerik reporting. I developed using Business intelligence for sql reporting services.
Please tell how to start with telerik reporting.
And also i want to place a button in my web page, when i click on the the button i want to display a report.
Hope my problem will be solved as soon as possible.
Thanks.
Best Regards
Arshad
Vassil Petev
Telerik team
answered
on
04 May 2009
1 answer
123 views
I've made the necessary changes to devenv.exe.config to get our design time ability to preview reports working. Yeah! This makes it much faster to get reports designed rather than change/compile/run. We use Subsonic so I had to add sections to the dev config that told it where to find the subsonic "stuff".
However I have a question (looking for ideas) on setting the datasource at design time versus production.
To get design-time preview working, I added code after the InitializeComponent() method to hit a business object and return a dataset which I assign to the report datasource. This call just hits the business object method with some dummy data - enough to give the preview something to work with.
But in production this call won't do. For production I comment out this assignment, and do it in the real code (web page presenter logic) that is instantiating the report viewer, prompting for real values, and showing the report. So for production (or stage - basically whenever NOT previewing at design-time) I comment out the assignment in the report .cs file after the InitializeComponent(), because the datasource assignment happens elsewhere.
Is there a better way to do this? I don't want to have to remember to comment out the datasource assignment and if I do, I assume the datasource assignment is happening twice which I don't want either.
I can't just put the production datasource assignment logic directly into the report .cs file because it's part of another business module (using MS MVP pattern) with lots of other stuff going on that I don't want to have in my report library module.
Any ideas?
Thx
However I have a question (looking for ideas) on setting the datasource at design time versus production.
To get design-time preview working, I added code after the InitializeComponent() method to hit a business object and return a dataset which I assign to the report datasource. This call just hits the business object method with some dummy data - enough to give the preview something to work with.
But in production this call won't do. For production I comment out this assignment, and do it in the real code (web page presenter logic) that is instantiating the report viewer, prompting for real values, and showing the report. So for production (or stage - basically whenever NOT previewing at design-time) I comment out the assignment in the report .cs file after the InitializeComponent(), because the datasource assignment happens elsewhere.
Is there a better way to do this? I don't want to have to remember to comment out the datasource assignment and if I do, I assume the datasource assignment is happening twice which I don't want either.
I can't just put the production datasource assignment logic directly into the report .cs file because it's part of another business module (using MS MVP pattern) with lots of other stuff going on that I don't want to have in my report library module.
Any ideas?
Thx
Steve
Telerik team
answered
on
04 May 2009
7 answers
338 views
Hii Team ,
I have master report which pass parameter to a subreport sometimes the subreport don't have data in it
i need to make the subreport area and headers hidden when no data represented in the subreport
i tried this
I have master report which pass parameter to a subreport sometimes the subreport don't have data in it
i need to make the subreport area and headers hidden when no data represented in the subreport
i tried this
Telerik.Reporting.Processing.
SubReport subReport;
subReport = (Telerik.Reporting.Processing.
SubReport)sender;
if (subReport.InnerReport.Items.Count == 0)
subReport.Visible =
false;
but it not working i need to know what should i do to make it hidden when no data
GVera
Top achievements
Rank 1
Rank 1
answered
on
01 May 2009
2 answers
76 views
We have a web application (vs2008) running the latest versions.
At run-time the report viewer works fine. Its datasource is set to a businessobject method that returns a dataset.
However at design-time we cannot get things working. At preview we get an error about it not being able to find a section of the application config file.
The business object uses SubSonic which has info in the web.config file. The previewer is not finding this info.
Is there a "trick" to making this same config info available to the report designer so that we can preview?
Thx
At run-time the report viewer works fine. Its datasource is set to a businessobject method that returns a dataset.
However at design-time we cannot get things working. At preview we get an error about it not being able to find a section of the application config file.
The business object uses SubSonic which has info in the web.config file. The previewer is not finding this info.
Is there a "trick" to making this same config info available to the report designer so that we can preview?
Thx
Kevin
Top achievements
Rank 2
Rank 2
answered
on
01 May 2009
1 answer
95 views
I have a couple of questions on styling reports in Telerik Reporting Q1 2009.
First, is there a way to style a table control so that all the rows and cells have a border? Or do I have to define a style for this and then apply it to my header / row cells?
Is it possible to apply a style selector to a table control? How about the table control header or rows, specifically?
First, is there a way to style a table control so that all the rows and cells have a border? Or do I have to define a style for this and then apply it to my header / row cells?
Is it possible to apply a style selector to a table control? How about the table control header or rows, specifically?
Steve
Telerik team
answered
on
30 Apr 2009
1 answer
148 views
Hi,
I´ve some dificult to resolv one problem, the cenarius is:
- I´ve a common header report
- Detail section, and footer
On my detail I have some controls anfter I want a sub report to detailing same records and after I have more controls.
The problem is that the sub report lost the datasource, and on databinding occurs the error.
My Source:
Fisrt Report
My SubReport
Someone can help me?
Thanks
I´ve some dificult to resolv one problem, the cenarius is:
- I´ve a common header report
- Detail section, and footer
On my detail I have some controls anfter I want a sub report to detailing same records and after I have more controls.
The problem is that the sub report lost the datasource, and on databinding occurs the error.
My Source:
Fisrt Report
| namespace Eorder_Reporting | |
| { | |
| using System.ComponentModel; | |
| using System.Drawing; | |
| using System.Windows.Forms; | |
| using Telerik.Reporting; | |
| using Telerik.Reporting.Drawing; | |
| using System.Data; | |
| using Report.dal; | |
| using System.Text; | |
| /// <summary> | |
| /// Summary description for ReportConsultaPedido. | |
| /// </summary> | |
| public partial class ReportConsultaPedido : Report | |
| { | |
| public ReportConsultaPedido() | |
| { | |
| /// <summary> | |
| /// Required for telerik Reporting designer support | |
| /// </summary> | |
| InitializeComponent(); | |
| // | |
| // TODO: Add any constructor code after InitializeComponent call | |
| // | |
| this.DataSource = null; | |
| this.subReport1.ReportSource = null; | |
| } | |
| string _strVarIdPedido; | |
| public string IdPedidoDetalheConsulta | |
| { | |
| get | |
| { | |
| return (_strVarIdPedido); | |
| } | |
| set | |
| { | |
| _strVarIdPedido = value; | |
| } | |
| } | |
| private void ReportConsultaPedido_NeedDataSource(object sender, System.EventArgs e) | |
| { | |
| dal clsDal = new dal(); | |
| StringBuilder strSQL = new StringBuilder(); | |
| strSQL.Append("SELECT CP_PEDIDO_V.ID_PEDIDO, CP_PEDIDO_V.ID_USUARIO, CP_PEDIDO_V.NR_ORDEM_COMPRA, CP_PEDIDO_V.DT_PEDIDO, "); | |
| strSQL.Append(" CP_PEDIDO_V.DT_ENTREGA, CP_PEDIDO_V.TS_INCLUSAO, CP_PEDIDO_V.TS_CONCLUSAO, CP_PEDIDO_V.COD_VENDEDOR, "); | |
| strSQL.Append(" CP_PEDIDO_V.TS_ENVIO_SAP, CP_PEDIDO_V.NR_CONTROLE_PORTAL, CP_PEDIDO_V.ID_TIPO_DOCUMENTO, CP_PEDIDO_V.ID_CONDICAO_PAGTO, "); | |
| strSQL.Append(" CP_PEDIDO_V.DT_FATURAMENTO, CP_PEDIDO_V.DS_OBSERVACAO, CP_PEDIDO_V.COD_CLIENTE_VENDA, CP_PEDIDO_V.NM_CLIENTE_VENDA, "); | |
| strSQL.Append(" CP_PEDIDO_V.DS_CIDADE_VENDA, CP_PEDIDO_V.UF_VENDA, CP_PEDIDO_V.COD_CLIENTE_ENTREGA, CP_PEDIDO_V.NM_CLIENTE_ENTREGA, "); | |
| strSQL.Append(" CP_PEDIDO_V.DS_CIDADE_ENTREGA, CP_PEDIDO_V.UF_ENTREGA, CP_PEDIDO_V.TS_CANCELADO, CP_PEDIDO_V.NOME_VENDEDOR, "); | |
| strSQL.Append(" CP_PEDIDO_V.DS_OBSERVACAO_PEDIDO, CP_TIPO_DOCUMENTO.DS_TIPO_DOCUMENTO, CP_CONDICAO_PAGTO.DS_CONDICAO_PAGTO, "); | |
| strSQL.Append(" (SELECT SUM(COALESCE(cp_pedido_item.vl_item_total, 0)) "); | |
| strSQL.Append(" FROM cp_pedido_item "); | |
| strSQL.Append(" WHERE cp_pedido_item.id_pedido = cp_pedido_v.ID_PEDIDO) AS VL_TOTAL "); | |
| strSQL.Append(" FROM CP_PEDIDO_V, CP_CONDICAO_PAGTO, CP_TIPO_DOCUMENTO "); | |
| strSQL.Append(" WHERE CP_PEDIDO_V.ID_CONDICAO_PAGTO = CP_CONDICAO_PAGTO.ID_CONDICAO_PAGTO AND "); | |
| strSQL.Append(" CP_PEDIDO_V.ID_TIPO_DOCUMENTO = CP_TIPO_DOCUMENTO.ID_TIPO_DOCUMENTO AND (CP_PEDIDO_V.TS_CANCELADO IS NULL) "); | |
| strSQL.Append(" AND (CP_PEDIDO_V.NR_ORDEM_COMPRA in (" + _strVarIdPedido + "))"); | |
| clsDal.CreateCommand(strSQL.ToString(), CommandType.Text); | |
| System.Data.DataSet ds = clsDal.GetDataSet(); | |
| this.DataSource = ds; | |
| } | |
| private void subReport1_ItemDataBinding(object sender, System.EventArgs e) | |
| { | |
| Telerik.Reporting.Processing.ReportItemBase item = ((Telerik.Reporting.Processing.ReportItemBase)sender); | |
| try | |
| { | |
| if (null != item) | |
| { | |
| ReportDetalhePedido pedidoDetalhe = new ReportDetalhePedido(); | |
| pedidoDetalhe.IDPedido = "'" + item.DataObject["NR_ORDEM_COMPRA"].ToString().PadLeft(5, '0') + "'"; | |
| subReport1.ReportSource = pedidoDetalhe; | |
| } | |
| } | |
| catch { } | |
| } | |
| } | |
| } |
My SubReport
| namespace Eorder_Reporting | |
| { | |
| using System.ComponentModel; | |
| using System.Drawing; | |
| using System.Windows.Forms; | |
| using Telerik.Reporting; | |
| using Telerik.Reporting.Drawing; | |
| using Report.dal; | |
| using System.Text; | |
| using System.Data; | |
| /// <summary> | |
| /// Summary description for ReportDetalhePedido. | |
| /// </summary> | |
| public partial class ReportDetalhePedido : Report | |
| { | |
| public ReportDetalhePedido() | |
| { | |
| /// <summary> | |
| /// Required for telerik Reporting designer support | |
| /// </summary> | |
| InitializeComponent(); | |
| // | |
| // TODO: Add any constructor code after InitializeComponent call | |
| // | |
| this.DataSource = null; | |
| } | |
| string _strVarIdPedido; | |
| public string IDPedido | |
| { | |
| get { return _strVarIdPedido; } | |
| set { _strVarIdPedido = value; } | |
| } | |
| private void ReportDetalhePedido_NeedDataSource(object sender, System.EventArgs e) | |
| { | |
| dal clsDal = new dal(); | |
| StringBuilder strSQL = new StringBuilder(); | |
| strSQL.Append("SELECT CP_PEDIDO_ITEM.ID_PEDIDO_ITEM, CP_PEDIDO_ITEM.ID_PEDIDO, CP_PEDIDO_ITEM.QTD_ITEM, CP_PEDIDO_ITEM.TS_INCLUSAO, "); | |
| strSQL.Append(" CP_PEDIDO_ITEM.TS_CANCELADO, CP_PEDIDO_ITEM.COD_PRODUTO, CP_PEDIDO_ITEM.NM_PRODUTO, CP_PEDIDO_ITEM.DS_BU, "); | |
| strSQL.Append(" CP_PEDIDO_ITEM.DS_UNIDADE, CP_PEDIDO_ITEM.COD_CLASSIFIC_PIG_POULTRY, CP_PEDIDO_ITEM.ID_TABELA_PC_PIG, "); | |
| strSQL.Append(" CP_PEDIDO_ITEM.ID_TABELA_PC_POULTRY, CP_PEDIDO_ITEM.VL_ITEM, CP_PEDIDO_ITEM.FL_FINS_AGROPEC, "); | |
| strSQL.Append(" CP_PEDIDO_ITEM.VL_ITEM_TOTAL, CP_PEDIDO_V.NR_ORDEM_COMPRA "); | |
| strSQL.Append(" FROM CP_PEDIDO_V, CP_PEDIDO_ITEM "); | |
| strSQL.Append(" WHERE CP_PEDIDO_V.ID_PEDIDO = CP_PEDIDO_ITEM.ID_PEDIDO AND (CP_PEDIDO_V.NR_ORDEM_COMPRA = " + _strVarIdPedido + ") "); | |
| strSQL.Append(" ORDER BY CP_PEDIDO_ITEM.DS_BU, CP_PEDIDO_ITEM.NM_PRODUTO"); | |
| clsDal.CreateCommand(strSQL.ToString(), CommandType.Text); | |
| System.Data.DataSet ds = clsDal.GetDataSet(); | |
| this.DataSource = ds; | |
| } | |
| } | |
| } |
Someone can help me?
Thanks
Steve
Telerik team
answered
on
30 Apr 2009
2 answers
191 views
Hi,
I have created a report using the telerik reporting tool.
In detail section i set the property columncount = 3 to show three columns in detail section.
I was surprised to see that this is working right in Preview but it goes off in HTML Preview.
Please help me, what will be the possible causes for the misbehavior? How i can overcome this problem?
I want to show three columns in detail section using the Column Count property.
Thanks.
I have created a report using the telerik reporting tool.
In detail section i set the property columncount = 3 to show three columns in detail section.
I was surprised to see that this is working right in Preview but it goes off in HTML Preview.
Please help me, what will be the possible causes for the misbehavior? How i can overcome this problem?
I want to show three columns in detail section using the Column Count property.
Thanks.
shadow
Top achievements
Rank 2
Rank 2
answered
on
30 Apr 2009
4 answers
179 views
Hi.
After upgrading to Q1 2009 of Reporting I cannot send the parameters to the report.
My code is as follows:
Dim report_generalAudit = New ReportsCL.GeneralAuditReport
report_generalAudit.DataSource = resultsDataTable
Me.viewer.Report = report_generalAudit
Me.viewer.Report.ReportParameters("StartDate").Value = startDate
Me.viewer.Report.ReportParameters("EndDate").Value = endDate
I get the following exception:
Input string was not in a correct format.
on
Me.viewer.Report.ReportParameters("StartDate").Value = startDate
Am I doing something wrong?
Thanks in advanced.
Steve
Telerik team
answered
on
29 Apr 2009
2 answers
139 views
hi there, I am using the Report Q1 3.0.9.311
I have included telerik.reporting, telerik.reporting.design, telerik.reporting.interfaces and telerik.reporting.Processing, as well as telerik.reportviewer.design and webforms in the assmbily BIN Folder
The Preview is fine, however, When i try to export it to PDF or other formats, it only generates a blank page
I have a dev server and local dev enviroment all fine....
do you know what can cause this problem?
=====================================
Problem Found, it's the known issue that when hiding HTML textbox, PDF generate blank
waiting for new version
I have included telerik.reporting, telerik.reporting.design, telerik.reporting.interfaces and telerik.reporting.Processing, as well as telerik.reportviewer.design and webforms in the assmbily BIN Folder
The Preview is fine, however, When i try to export it to PDF or other formats, it only generates a blank page
I have a dev server and local dev enviroment all fine....
do you know what can cause this problem?
=====================================
Problem Found, it's the known issue that when hiding HTML textbox, PDF generate blank
waiting for new version
Steve
Telerik team
answered
on
29 Apr 2009
4 answers
215 views
Is it possible to change the parent item of an item from within the designer? If not, how can it be done in code?
I created a Panel inside of a Panel (let's call it Parent1). However, I would like to move it to a different Panel (Panel2) without having to recreate it since its contents are pretty complex. I'm not sure how to do this - when I drag the Panel, its parent is still Panel1 even if it is physically located inside Panel2.
Thanks.
I created a Panel inside of a Panel (let's call it Parent1). However, I would like to move it to a different Panel (Panel2) without having to recreate it since its contents are pretty complex. I'm not sure how to do this - when I drag the Panel, its parent is still Panel1 even if it is physically located inside Panel2.
Thanks.
Steve
Telerik team
answered
on
28 Apr 2009
