Telerik Forums
Reporting Forum
0 answers
121 views
I've been asking for this for a long long time, but I thought I'd just mock up what I mean (see attached)...

Everytime I need to find the syntax for the filter to only use the parameter if there's a value, I need to google it...and that sucks :)  This checkbox could solve that...so internally it gets handld\filtered without me needing to remember the proper IsNull syntax inside those boxes.

What do you think?

sitefinitysteve
Top achievements
Rank 2
Iron
Iron
Veteran
 asked on 28 Mar 2012
1 answer
160 views

How to group table programically?

I’m using AutoGenerateColumns project  

And add code for group table but I getting  error  “.object reference not set to an instance of an object”

 

  SqlConnection cn = new SqlConnection("Data Source=PC\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True");
 
     cn.Open();
 
                SqlCommand command = new SqlCommand(“ProcName”, cn);
                command.CommandType = CommandType.StoredProcedure;
 
                SqlDataAdapter sqlAdapter = new SqlDataAdapter(command);
                DataSet ds = new DataSet();
                sqlAdapter.Fill(ds);
 
                Telerik.Reporting.Processing.Table processingTable = (sender as Telerik.Reporting.Processing.Table);
                processingTable.DataSource = ds.Tables[0];
 
                Telerik.Reporting.HtmlTextBox textboxGroup;
                Telerik.Reporting.HtmlTextBox textBoxTable;
 
                this.table1.ColumnGroups.Clear();
                this.table1.Body.Columns.Clear();
                this.table1.Body.Rows.Clear();
                this.table1.ColumnHeadersPrintOnEveryPage = true;
                int i = 0;
                float widthMid = 0;
 
                if (PageSettings.Landscape)
                    widthMid = (this.PageSettings.PaperSize.Height.Value - GetAsMm( this.PageSettings.Margins.Left) - GetAsMm( this.PageSettings.Margins.Right) ) / (ds.Tables[0].Columns.Count);
                else
                    widthMid = (this.PageSettings.PaperSize.Width.Value -  GetAsMm(this.PageSettings.Margins.Left) - GetAsMm(this.PageSettings.Margins.Right) ) / (ds.Tables[0].Columns.Count);
 
                ///////////////////////////////////////////////////////////////
               
                for (int x = ds.Tables[0].Columns.Count - 1; x >= 0; x--)
                //foreach (DataColumn dc in ds.Tables[0].Columns)
                {
                    DataColumn dc = ds.Tables[0].Columns[x];
                    Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();
                    this.table1.ColumnGroups.Add(tableGroupColumn);
                    this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Mm(widthMid)));
 
                    textboxGroup = new Telerik.Reporting.HtmlTextBox();
                    textboxGroup.Style.BorderColor.Default = Color.Black;
                    textboxGroup.Style.BorderStyle.Default = BorderType.Solid;
                    textboxGroup.Value = Equivalent.GetEquivalent(dc.ColumnName.ToString());
                    textboxGroup.Size = new SizeU(Unit.Cm(0.2), Unit.Inch(0.3));
                    textboxGroup.Style.TextAlign = HorizontalAlign.Center;
                    tableGroupColumn.ReportItem = textboxGroup;
 
                    textBoxTable = new Telerik.Reporting.HtmlTextBox();
                    textBoxTable.Style.BorderColor.Default = Color.Red;
                    textBoxTable.Style.BorderStyle.Default = BorderType.Solid;
                    textBoxTable.Value = "=Fields." + dc.ColumnName;
                    textBoxTable.Size = new SizeU(Unit.Cm(0.2), Unit.Inch(0.3));
                    textBoxTable.Style.TextAlign = HorizontalAlign.Right;
                    this.table1.Body.SetCellContent(0, i++, textBoxTable);
                    this.table1.Items.AddRange(new ReportItemBase[] { textBoxTable, textboxGroup });
                }
 
              ///////////////////////////////////////////////////////////////
///grouping part
                 
              Telerik.Reporting.TableGroup group1 = new Telerik.Reporting.TableGroup();
              group1.Name = "IDGroup";
              group1.Groupings.Add(new Telerik.Reporting.Data.Grouping("=Fields.ID"));
              
              Telerik.Reporting.TextBox textBox1 = new Telerik.Reporting.TextBox();
              table1.Items.Add(textBox1);
              group1.ReportItem = textBox1;
 
              table1.RowGroups.Add(group1);           
                  
              ///////////////////////////////////////////////////////////////

 

This code have error only I using a grouping part

Elian
Telerik team
 answered on 28 Mar 2012
3 answers
250 views
Hi

Is it possible in Telerik chart Reporting for generating Bar Charts for a Cross tab Report. If it is possible then pls provide me with a link or demo to understand how to implement it.

Actually we are very very dependent on Telerik Reports so its very Urgent !!!!

Thanks in Advance....
Elian
Telerik team
 answered on 28 Mar 2012
3 answers
1.1K+ views

I have read through the documentation and to my understanding it is NOT possible to pass a parameter from an .aspx page directly to the SQL statement in the data table. I need to pull the data in its entirety and use parameters on the report to “filter” out what is not needed. Is this correct?

 

My issue is I need to pass a parameter to the WHERE clause of my SQL query to pull different users by a certain type. Unfortunately, because of the way our tables are setup I must programmatically switch between two separate queries or (data tables) depending on which user type is chosen. Also, pulling everything from our database and filtering at the report level has huge impacts on our report’s performance and I would like to stay away from that if possible.  

Elian
Telerik team
 answered on 28 Mar 2012
1 answer
132 views
I have a report that is slated to contain a URL when the report is generated. This works perfect without a hitch, however, I want the URL to generated only if there is an actual need for it. I'll illustrate the what I need based on the table below:

DescriptionField            FileNameField    
Description 1                filename1.doc
Description 2                NULL
Description 3                filename2.doc
Description 4                NULL

Based on the data above, I'd like to generate a report that would have a field that allows for clicking on a link if the filenamefield is populated. If the filenamefield is null, a URL should not be generated and therefore the generated PDF should not contain it. For example, if I generate the report above, what I want to look like is below:

Description 1 (URL embedded)
Description 2
Description 3 (URL embedded)
Description 4

I would assume that this can be accomplished from codebehind.
Steve
Telerik team
 answered on 28 Mar 2012
3 answers
181 views
Hi,

I'm discovering Telerik Reporting and read the guide : http://www.telerik.com/documents/TelerikReporting-LearningGuide.pdf
I've two different projects in the same solution. One is for the reporting and the other will use that reporting tool.
So i've created a new report in my reporting project, and tested it in Preview mode. It works.

But in my other project, when i put a ReportViewer in my .aspx, i try tu drop down the property "Report" of the control in order to bind my Report. But there's no reports in there.

What could i possibly done wrong?

Thanks
Julien
Top achievements
Rank 1
 answered on 28 Mar 2012
1 answer
136 views
Hi,
I would like to limit the export possibilities. I want to prevent export to RTF. How can I achieve this?
Kind regards
Christian
Steve
Telerik team
 answered on 28 Mar 2012
0 answers
84 views
Hi all,
I have to display year in X axis . For each year there is more than 2 series(company names) and for each company their Appraisal in y Axis.
How can i implement multiple series.I tried "RadChart1.DataGroupColumn " But more than 2 companies not listing for each year..

Eg: Year: 2009 -------Comp:comp1,comp2,comp3---- Appraisal: comp1-->2,comp2-->5,comp3-->8
And for year 2010 ------Comp:comp1---- Appraisal: comp1-->2
etc...

Please reply,,,
Lekha
lekha
Top achievements
Rank 1
 asked on 28 Mar 2012
2 answers
224 views
Hello, 

I was wondering if it was good practice to retrieve data via the code behind and pass it to my reports textboxes.  I would create some properties in the report class that would allow me to pass it a business object.  This business object would contain data needed on the report and via the code behind I can reference the textbox objects for e.g.  this.textbox25.Value = obj.FirstName.

This would allow me to avoid adding more SQLDatasources to the report.  Would this practice be considered ok.

Thanks,

Kerry
Kerry
Top achievements
Rank 1
 answered on 28 Mar 2012
10 answers
423 views
I can't seem to find an answer to this. I have a "Notes" field in a textbox. I want to always show the border around the textbox even if the field is null or empty string. How do I do this? Right now if the there is data in the field the border is displayed. If null or empty, no border.

Thanks.
Steve
Telerik team
 answered on 27 Mar 2012
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?