Telerik Forums
Reporting Forum
0 answers
85 views
Our ASP.NET/Silverlight 4 application has 75k clients and potentially millions of transaction records over time. Has anyone successfully run Telerik Reports on large datasets; i.e. 10,000 to 1,000,000 records? I've heard that there are problems with as little as 1,000 records.  If I access our client dataset (75k records) and query it with the Query Builder in VS 2010, it will begin returning records almost immediately at an extremely acceptable rate.  If I try and run a Telerik Report on it, it throws an meaningless exception almost immediately from inside the adapter's Fill method which it displays on the ReportViewer screen. 

Does anyone believe that Telerik Reporting can or should be used in this sort of situation; and if so, what modifications have you made to the base code to accomplish this, and if not, does anyone know of an alternative?  I'm becoming desparate.

Thanks,
Steve
Steve
Top achievements
Rank 1
 asked on 09 Mar 2010
1 answer
212 views
I'm trying to style the crosstab table.
For the table data, i have a grey line under each row  (Normal.TableBody ) ,
for the Subtotal I have a double black line as the top (Normal.SubTotal ) .

When it prints, I'm getting the double black line and the grey line,
since the data before the subtotal is also the table data

I've deduced it's because one textbox uses Normal.TableBody, which has the grey line at the bottom
and the other textbox uses Normal.SubTotal which is defined as a top border with a double line.
So how would i make the Subtotal Box be the main one?

please see image.


Also, in the stylerule, how come I don't see a place to add a style name in the TypeSelector Collection Editor when adding a new rule (newstyle.png) ?

If I edit an existing (existingstyle.png) rule the stylename box is there.

Here's the export of the Styles

<?xml version="1.0" encoding="utf-8"?> 
<StyleSheet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  <StyleRule> 
    <Style> 
      <BackgroundColor>White</BackgroundColor> 
      <Color>Black</Color> 
      <BorderStyle> 
        <Default>None</Default> 
      </BorderStyle> 
      <BorderColor> 
        <Default>Black</Default> 
      </BorderColor> 
      <BorderWidth> 
        <Default>1px</Default> 
      </BorderWidth> 
      <Font> 
        <Name>Arial</Name> 
        <Size>8pt</Size> 
      </Font> 
    </Style> 
    <Selectors> 
      <StyleSelector> 
        <Type>Table</Type> 
        <StyleName>Normal.TableNormal</StyleName> 
      </StyleSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <TextAlign>Center</TextAlign> 
      <VerticalAlign>Middle</VerticalAlign> 
      <BorderStyle> 
        <Top>Solid</Top> 
        <Bottom>Solid</Bottom> 
        <Left>None</Left> 
      </BorderStyle> 
      <BorderColor> 
        <Top>41, 86, 153</Top> 
        <Bottom>41, 86, 153</Bottom> 
        <Left>Black</Left> 
      </BorderColor> 
      <BorderWidth> 
        <Top>3px</Top> 
        <Bottom>3px</Bottom> 
        <Left>0pt</Left> 
        <Right>0pt</Right> 
      </BorderWidth> 
      <Font> 
        <Size>11px</Size> 
        <Bold>True</Bold> 
      </Font> 
      <LineWidth>3px</LineWidth> 
    </Style> 
    <Selectors> 
      <DescendantSelector> 
        <Selectors> 
          <TypeSelector> 
            <Type>Table</Type> 
          </TypeSelector> 
          <StyleSelector> 
            <Type>ReportItem</Type> 
            <StyleName>Normal.TableHeader</StyleName> 
          </StyleSelector> 
        </Selectors> 
      </DescendantSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <Visible>True</Visible> 
      <TextAlign>Right</TextAlign> 
      <VerticalAlign>Top</VerticalAlign> 
      <BorderStyle> 
        <Default>None</Default> 
        <Bottom>Solid</Bottom> 
      </BorderStyle> 
      <BorderColor> 
        <Default>Black</Default> 
        <Bottom>41, 86, 153</Bottom> 
      </BorderColor> 
      <BorderWidth> 
        <Default>1px</Default> 
        <Bottom>4px</Bottom> 
      </BorderWidth> 
      <Padding> 
        <Top>5px</Top> 
      </Padding> 
    </Style> 
    <Selectors> 
      <DescendantSelector> 
        <Selectors> 
          <TypeSelector> 
            <Type>Table</Type> 
          </TypeSelector> 
          <StyleSelector> 
            <Type>ReportItem</Type> 
            <StyleName>Normal.TableGroup</StyleName> 
          </StyleSelector> 
        </Selectors> 
      </DescendantSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <TextAlign>Right</TextAlign> 
      <VerticalAlign>Middle</VerticalAlign> 
      <BorderStyle> 
        <Default>None</Default> 
        <Top>Double</Top> 
      </BorderStyle> 
      <BorderColor> 
        <Default>Black</Default> 
      </BorderColor> 
      <BorderWidth> 
        <Default>0px</Default> 
        <Top>4px</Top> 
      </BorderWidth> 
      <Font> 
        <Bold>True</Bold> 
      </Font> 
      <Padding> 
        <Top>0px</Top> 
      </Padding> 
    </Style> 
    <Selectors> 
      <DescendantSelector> 
        <Selectors> 
          <TypeSelector> 
            <Type>Table</Type> 
          </TypeSelector> 
          <StyleSelector> 
            <Type>ReportItem</Type> 
            <StyleName>Normal.SubTotal</StyleName> 
          </StyleSelector> 
        </Selectors> 
      </DescendantSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <TextAlign>Right</TextAlign> 
      <VerticalAlign>Middle</VerticalAlign> 
      <BorderStyle> 
        <Top>None</Top> 
      </BorderStyle> 
      <BorderColor> 
        <Top>41, 86, 153</Top> 
      </BorderColor> 
      <BorderWidth> 
        <Top>3px</Top> 
      </BorderWidth> 
      <Font> 
        <Bold>True</Bold> 
      </Font> 
      <Padding> 
        <Top>0px</Top> 
      </Padding> 
    </Style> 
    <Selectors> 
      <DescendantSelector> 
        <Selectors> 
          <TypeSelector> 
            <Type>Table</Type> 
          </TypeSelector> 
          <StyleSelector> 
            <Type>ReportItem</Type> 
            <StyleName>Normal.GrandTotal</StyleName> 
          </StyleSelector> 
        </Selectors> 
      </DescendantSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <TextAlign>Right</TextAlign> 
      <VerticalAlign>Middle</VerticalAlign> 
      <BorderStyle> 
        <Default>None</Default> 
        <Bottom>Solid</Bottom> 
      </BorderStyle> 
      <BorderColor> 
        <Default>Black</Default> 
        <Bottom>153, 153, 153</Bottom> 
      </BorderColor> 
      <BorderWidth> 
        <Default>1px</Default> 
      </BorderWidth> 
    </Style> 
    <Selectors> 
      <DescendantSelector> 
        <Selectors> 
          <StyleSelector> 
            <Type>ReportItem</Type> 
            <StyleName>Normal.TableBody</StyleName> 
          </StyleSelector> 
        </Selectors> 
      </DescendantSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <Color>Blue</Color> 
      <TextAlign>Right</TextAlign> 
      <Font> 
        <Size>20px</Size> 
        <Bold>True</Bold> 
      </Font> 
    </Style> 
    <Selectors> 
      <TypeSelector> 
        <Type>ReportHeaderSection</Type> 
      </TypeSelector> 
      <TypeSelector> 
        <Type>HtmlTextBox</Type> 
      </TypeSelector> 
    </Selectors> 
  </StyleRule> 
  <StyleRule> 
    <Style> 
      <TextAlign>Right</TextAlign> 
      <Font> 
        <Size>14px</Size> 
        <Bold>True</Bold> 
      </Font> 
    </Style> 
    <Selectors> 
      <TypeSelector> 
        <Type>PageHeaderSection</Type> 
      </TypeSelector> 
    </Selectors> 
  </StyleRule> 
</StyleSheet> 









Peter
Telerik team
 answered on 08 Mar 2010
1 answer
181 views
    Hi, Telerik!
The NeedDataSource event of my report don't run, when i fill DataSetTableAdpter! Can you tell me the reason?
sitefinitysteve
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 06 Mar 2010
1 answer
124 views
Hi,

I have created a report with a conditional format for the background color of the detail section to be set to silver if the row is an odd number. The issue comes when the report is set to landscape equal to false and the last column in the report is on the edge of the report. The background color that is set extends past the last column. I moved each item in the detail section back from the edge by about .02 inches so that it is not imediately on the edge of the report.

If you have any ideas or need more information please just let me know.

Thanks,
Jonathan Simon
Steve
Telerik team
 answered on 05 Mar 2010
0 answers
147 views
Hi,,,

      Now i am using "Telerik_Reporting_2008_3_1402_trial_4" for reports..

i must need the No records found option when the reportviewer contain 0 records....

plz try for it....

By Suriya
Suriya
Top achievements
Rank 1
 asked on 05 Mar 2010
2 answers
118 views
Hi there,

I am having an odd issue when displaying a report with a ReportViewer on an ASP page.

The site was developed using Visual Studio 2010 (beta 2), and when I run the page under the ASP.NET Development Server, the report is displayed perfectly.  However, if I try and open the page normally, only the report header and footer is displayed, and the details of the report is missing.  No error messages appear on the page.

Has anyone else experienced this problem?  Perhaps it is an ASP configuration issue whereby the datasource cannot be accessed? 

I would be grateful for any help!

Alvin
Alvin Ho
Top achievements
Rank 1
 answered on 04 Mar 2010
1 answer
70 views
Hi, Telerik!
I need your help! I use CrossTabWizard im my report. And when the report content is more than page size, the first page of report  is empty. How can I get rid of this problem?
Steve
Telerik team
 answered on 04 Mar 2010
1 answer
98 views
Hi,

I have a winform application where a user can select in a combobox some categories. If a category is selected, the query related to that category will be executed and showed in a radgridview. Now I would like that the radgridview will be showed in a report by clicking on a button.

The clue is that I want different layouts for each category so I made 3 reports by the build-in designer.

Is it possible that when I click on the 'generate report' button, I bind the dataset I get from the radgridview to a report that was pre-made and show that report in a reportviewer on a form ?

I tried with the RadGridReportingLite libary you've provided but I can't get it to work cause there the reports are programmatically build.

Hoping op positive answer.
Thanks in advance.

Greetz
Massimiliano Bassili
Top achievements
Rank 1
 answered on 04 Mar 2010
1 answer
160 views
Hello All,

We're thinking about switching to Telerik reporting for some of our new products, but we have a basic requirement. We have to be able to allow the customers to dynamically change and save off report templates run time. Does Telerik reporting support this? If I have say a report that involves 10 columns in 4 tables, can I allow the customer to add a few columns, maybe a table, change some ordering, and then save that off? Obviously there is coding infrastructure around this web page and the like, but I wasn't sure how flexible telerik reports are. Also, if anyone can point me towards sample code similar to what I've mentioned that would be great.

Thanks a bunch,
Ryan
Steve
Telerik team
 answered on 04 Mar 2010
0 answers
68 views
I am having an issue when trying to create a report, I am using the report wizard. The wizard itself works fine but after the report is generated I am getting over 80 or so build error and no report is shown. I attached a screen shot of one of the errors to which takes me to the .Designer.vb code.

What seems to be happening is the classes might not being named correctly. I had to add the 1 at the end of both class names below.

Partial

 

Public Class CMSC_WEB2DataSet1

 


 

Partial Public Class CMSC_WEB2DataSetTableAdapter1

 

This took all but 2 errors away.

The errors I cannot seem to figure out deals with the line below. The error is with - ds.GetSchemaSerializable.

<

Global.System.Diagnostics.DebuggerNonUserCodeAttribute()> _

 

Public

 

Shared Function GetTypedDataSetSchema

 

Dim dsSchema As Global.System.Xml.Schema.XmlSchema = ((ds.GetSchemaSerializable)) **Error

 



<

Global.System.Diagnostics.DebuggerNonUserCodeAttribute()> _

 

 

 

Public

 

Shared Function GetTypedTableSchema

 

 

Dim

 

dsSchema As Global.System.Xml.Schema.XmlSchema = ((ds.GetSchemaSerializable)) ** Error

 



Would anyone have an idea as to why this might be happening?
Why the report is not naming the class correctly?
Could I be doing something wrong?

thanks
Dwayne Starkey
Top achievements
Rank 1
 asked on 03 Mar 2010
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?