Telerik Forums
Reporting Forum
0 answers
151 views
I'm using Telerik Reporting version 5.1.11.928. I bind the sql data source through the Telerik table wizard, then I called it from my code. Here is what my codes look like

 private void MachineStatusReport_ItemDataBinding(object sender, EventArgs e)
        {
           
                    uint pcGroupId = 0;

string sql = " // some sql query here..";
 
   sqlDataSource1.SelectCommand = sql;


          sqlDataSource1.Parameters.Clear();
            sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
           
          new Telerik.Reporting.SqlDataSourceParameter("ParameterDaysNumber", System.Data.DbType.Int32, ReportParameters["numDay"].Value),
            new Telerik.Reporting.SqlDataSourceParameter("ParameterPcGroupID", System.Data.DbType.String, "= Parameters.pcGroupId.Value"),
            new Telerik.Reporting.SqlDataSourceParameter("ParameterPcGroupLevel", System.Data.DbType.String, 0 < pcGroupId ? Common.GetPcGroupLevel(pcGroupId) + "-%" : "%")
  

  });


            DataSource = sqlDataSource1;


}

Next I bind  the table to this datasource using ' = ReportItem.DataObject'. and created a group based on some fields from the sql.

It works fine. Now I need to add new table on the same report, selecting specific data from report datasource which I have been using above and using the same grouping. However I cant use the same datasource result as I need to do another select statement to get the data from sqlDataSource1 result.  So how should I go about it.?


Fadhli
Top achievements
Rank 1
 asked on 06 Dec 2011
2 answers
1.4K+ views
I have a Silverlight project with a Telerik Rad Control Rich Text Box. The content of the rich text box is first exported in a string variable like this 

public string ExportToXAML(RadDocument document)  

XamlFormatProvider provider = new XamlFormatProvider();  

return provider.Export(document);  

}
After this, it is converted to a byte[] datatype and stored in an Oracle Database with a WCF webservice as a blob datatype (large business object). This works fine without problems. The content which is saved in the database is also shown in the rich text box with a get method of the webservice.
My question is: Is it possible to display the content of the rich text box in a Telerik report. I have constructed a Dataobjectmethod as a separate class, build an objectdatasource with the Dataobjectmethod and at last bound the report´s datasource to the objectdataource. Now when I try to generate the report preview an error is thrown: "Object reference not set to an object instance"
Actually it is not only the large BLOB object which is not displayed, but also the normal text is not shown. Do you have any idea about the error and how to handle it?
And: Is there a rich text box in the reporting or if not, how can I display the content of a rich text box in the report?

Peter
Telerik team
 answered on 05 Dec 2011
1 answer
68 views
When I selected print button in design no problem texts but When I selected print button on another reportviewer, Texts is damage,
Steve
Telerik team
 answered on 05 Dec 2011
0 answers
88 views
Hi there,

I'm looking for an feature that allow user easily customize (drag/drop) report column before export to an report file.

Does Telerik Reporting support this?

thanks.
fsoft_dungtv2
Top achievements
Rank 1
 asked on 05 Dec 2011
1 answer
171 views
I am setting the ShowZoomSelect to False and the zoom select still shows up in IE. The Browser version is 9.0.8112.16421.
This is my mark up.
<telerik:ReportViewer ID="ReportViewer1" runat="server"  Width="100%"
            DocumentMapVisible="False"  BorderColor="#AABFD6" BorderStyle="Inset" BorderWidth="1px"
            Height="800px" ShowParametersButton="False"  
            ParametersAreaVisible="False" ShowRefreshButton="True" Visible="False"
            meta:resourcekey="ReportViewer1Resource2" ReportBookID="">
            <resources documentmaptooltip="Show document map|Hide document map" />
        </telerik:ReportViewer>

please let me know what might be wrong?

regards
Yash
Steve
Telerik team
 answered on 05 Dec 2011
4 answers
373 views
Hello,

how can I make duplicate of pages in Telerik Reporting?
The report is showing one page, which is good, but I'd like an exact copy of the first page, as the second page. Can this be done in an easy step? Or will it be faster to just copy/paste all the page contents(in designer) so that 2 pages will appear?

Best regards,
Thomas
Patrick Saunders
Top achievements
Rank 1
 answered on 05 Dec 2011
1 answer
267 views
Hi, 

I'm creating a report in which I need to display a list of point, I've categories and subcategories. 

I looked at your ProductSales report, which seems to do almost the same thing that I need, but it's not the case:

In my case, I've a collection of Categories, which have a proprty that is a collection of subcategories:

List<Category>
\-->Category
        \-->List<SubCategory>
                \-->SubCategory

And in yours, you have only one object which contains all elements.

I can do a "Group", but I will only have one Item per group(the Category), and I can't display the subGroup in the same table. So how should I do this?

Another problem:
I've a "business key" for both category and subcategory, it's on this key that I can Group, and I need them on the same collumn, I also didn't found this.

It's one of the last piece I miss to create 20+ reports, so I will really be happy if you can explain me how I should do this.

Maybe it's more explicit if I give you a screenshot of what I'm hopping to do with telerik Screenshot of the hopped result

Elian
Telerik team
 answered on 02 Dec 2011
1 answer
191 views
I'm new to all of this and I"m just trying to add the report viewer into LIghtSwitch.

Is this up to date?
How To: Telerik Reporting in Microsoft LightSwitch Beta 2

I get to the place of adding the reference in the report viewer control. The example shows this:

Example

I'm getting this:

My Screenshot


I'm using Reporting Q3 2011


Elian
Telerik team
 answered on 02 Dec 2011
14 answers
1.0K+ views
Hi,

when i used telerik reporting when the records are less we are not getting the bottom border.

same way we are not getting the right border also.

 please find the screenshot.


In our application we are using Reports.
In that we've using sub reports. In Sub Report  while exporting to excel its works fine
but when we merge that report in Main report ,then export to excel its Showing error -"Error.Png". 


Pls have a glance on the attached snapshots and provide me some solution.


Thanks & Regards,
Karthik
Squall
Top achievements
Rank 1
 answered on 02 Dec 2011
1 answer
140 views

I am having a problem with my syntax when I try to use a Bitwise operation.

 

= iif(Fields.test Or 256,’true’,’false’)

I am getting an Type mismatch on ‘Or’ 

What am I doing wrong?

Thanks, Dan

Elian
Telerik team
 answered on 02 Dec 2011
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?