Telerik Forums
Reporting Forum
2 answers
402 views
Hello All,


I have a technical question on telerik report.

On my report, I have two parameters("State" and "City")--They are setup in "cascading" way. Meanwhile, I setup "0" as default values (display value as "All") for both of them.

In the first load, if I choose "MN" for State, the city will list as below and "All" as a default value automatically is selected, which is expected.
CityID         CityName
0                     "all"
120                  "St paul"
121                   "Minneapolis"  

At this point, if I choose "St paul" for city and hit "run report" button, the report will be presented decently.

The issue is in the second round, however. If I change my state value from MN to PA, I expect the city list will reload all cities from PA(which is correct and includes default value "0, All") abd the default value still keeps as "All"(cityID=0) (which is in list but not selected automatically for me this time). I have to click this dropdown list again to choose "all" by myself.

Who can share some lights on this---how to make the default value still working even in the first round you have specified the value for this?

Thanks
 
 
Steve
Telerik team
 answered on 03 Dec 2012
5 answers
91 views
Hi,

I used telerik report Telerik_Reporting_Q2_2010_v4_1_10_921 version for developing my report pages. I develeloped reports with using Telerik report wizard and I used Civic style in my reports. When I upgrade my telerik reports to Q3, some problems in telerik report wizard were seen. I choose Civic style but when I clicked the finish button, reports look like they do not have any style. I am sending the screenshot of the report in the attachment.  What is the problem? 

Thanks  
Steve
Telerik team
 answered on 03 Dec 2012
2 answers
1.4K+ views
When opening a report in xlsx using Q1'12 controls, this is throwing an error:  Thread was being aborted.  It then prompts me to open or save it, then says "it couldn't be downloaded".  But when I click "retry" it opens fine in excel as xlsx.

Here is my code: 
var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("xlsx", reportToExport, null);
 
                string fileName = reportName + ".xlsx";
                Response.Clear();
                Response.Charset = "";
                Response.ContentType = "application/vnd.xlsx";
                Response.Cache.SetCacheability(HttpCacheability.Private);
                Response.Expires = -1;
                Response.Buffer = false;
                Response.AddHeader("Content-Disposition",string.Format("{0};FileName=\"{1}\"", "attachment", fileName));
                Response.OutputStream.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
                Response.End();
David
Top achievements
Rank 1
 answered on 30 Nov 2012
1 answer
120 views
I'm converting some reports from SSRS to Telerik as a business case to migrate to Teleirk Reporting, but I'm having problems getting the table to stack its groups properly.

I can only find examples that show example that do this:
Group 1 Header, Group 1.1 Header, Details .........................................................................

But I need it to do this:
Group 1 Header
                            Group 1.1 Header
                                                           Details ........................................................................

Can this be done in the designer, and if so, how?
Would this be done with static groups, and if so how do those groups stack in the Row Heirarchy.


Then is it possible to collapse the Group Header columns widths to get this
Group 1 Header
Group 1.1 Header
Details.......................................
Group 1.1 Footer


I know that the table may not be the correct control, but we've got a tone of SSRS reports to convert and I've created a RDL converter that gets me 90% of the conversion done and then I just need to cleanup the expressions and bind the SSRS Group Expressions to ItemDataBound events.

I know that hacks to get data formatted in SSRS do not mean I need to do them in Telerik Reporting, so If the table is wrong, then I could change my Converter to map these messy tables to Lists instead or attach it to the Report itself if only one exists.

Thanks
Steve
Steven
Top achievements
Rank 1
 answered on 30 Nov 2012
3 answers
168 views
I have an interesting situation.  I have a report that has a chart on it.  The web form (ASP.NET) determines what data is going to the chart itself.  In the telerik report I build the chart programmatically based on the data passed in. This means I have to set a public member as a datatable and refresh the report to have the chart recall the need datasource event.  The need datasource event fires off the function that builds the chart.  Now I recreated this in a windows app and it works perfectly.  It just isn't working in the web.  I am using 2012 Q1.  Here is my code to call below:

In Telerik Report:
Public ChartSource As New DataTable

  Private Sub Chart1_NeedDataSource(sender As System.Object, e As System.EventArgs) Handles Chart1.NeedDataSource
        GetSeries(ChartSource)
  End Sub

In ASP.NET VB:
 Dim rpt As New clsQT9Reports.rptCARBarChart()
 rpt.ChartSource = DT1  'this is the chart data
 rpt.DataSource = dt  'this is a single record datatable that literally just loaded the header on the report
 rptVWR.Report = Nothing
 rptVWR.Report = rpt
  rptVWR.RefreshReport() 
Steve
Telerik team
 answered on 30 Nov 2012
1 answer
79 views
Hi All,

I have a reporting page with a crosstab on it. Toggle Visibility action has been assigned to the Category field to drillthrough the Subcategory fields. Everything works well at this point. However, the report refreshes everytime the Category toggle mark is clicked.
I would like to ask if there is any option to store all retreived data by the first report generation to prevent the report being refreshed everytime the toggle mark is clicked.  

Thank you.
Steve
Telerik team
 answered on 30 Nov 2012
0 answers
134 views
I created a POC report in the designer and it is working properly.  I am now trying to implement this in a WPF application and have the report opening, just showing no data.  (I am up to date using the Q3 2012) assemblies.

The ReportContent is being retrieved from a database.  I am replacing the ConnectionString at runtime and have verified that it is being updated appropriately.  At runtime ConnectionString="" is being updated to a valid connection string.

Also, I am not sure why, but if I do not remove "xmlns="http://schemas.telerik.com/reporting/2012/2" from the XML it will not even display the report and tell me that I have an invalid connection.  Simply removing this at least allows the report to display, just with no data.

Here is a sample of the XML being pulled from the database:
<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="TestConn" Width="6.45833333333333in" Name="Parent">
  <DataSources>
    <SqlDataSource ConnectionString="" SelectCommand="SELECT ID, CreateDate FROM tblTest WHERE ID= 1234" Name="TestConn" />
  </DataSources>
  <Items>
    <PageHeaderSection Height="0.28125in" Name="pageHeader">
      <Items>
        <TextBox Value="Parent" Size="6.41666666666667in, 0.200000027815501in" Location="0.0208333333333333in, 0.0208333333333333in" Name="reportNameTextBox" StyleName="PageInfo" />
      </Items>
    </PageHeaderSection>
    <PageFooterSection Height="0.28125in" Name="pageFooter">
      <Items>
        <TextBox Value="=NOW()" Size="3.19791666666667in, 0.200000027815501in" Location="0.0208333333333333in, 0.0208333333333333in" Name="currentTimeTextBox" StyleName="PageInfo" />
        <TextBox Value="=PageNumber" Size="3.19791666666667in, 0.200000027815501in" Location="3.23958333333333in, 0.0208333333333333in" Name="pageInfoTextBox" StyleName="PageInfo">
          <Style TextAlign="Right" />
        </TextBox>
      </Items>
    </PageFooterSection>
    <ReportHeaderSection Height="1.0290683110555in" Name="reportHeader">
      <Items>
        <TextBox Value="Parent" Size="6.45833333333333in, 0.787401596705119in" Location="0in, 0in" Name="titleTextBox" StyleName="Title" />
        <TextBox Value="Create Date:" CanGrow="True" Size="3.19791666666667in, 0.200000027815501in" Location="0.0208333333333333in, 0.808234930038452in" Name="createDateCaptionTextBox1" StyleName="Caption">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Value="=Fields.CreateDate" CanGrow="True" Size="3.19791666666667in, 0.200000027815501in" Location="3.23958333333333in, 0.808234930038452in" Name="createDateDataTextBox" StyleName="Data" />
      </Items>
    </ReportHeaderSection>
    <ReportFooterSection Height="0.28125in" Name="reportFooter" />
    <DetailSection Height="0.28125in" Name="detail">
      <Items>
        <TextBox Value="=Fields.CreateDate" CanGrow="True" Size="1.58854166666667in, 0.200000027815501in" Location="0.0208333333333333in, 0.0208333333333333in" Name="createDateDataTextBox1" StyleName="Data" />
        <TextBox Value="=Fields.ID" CanGrow="True" Size="1.58854166666667in, 0.200000027815501in" Location="1.63020833333333in, 0.0208333333333333in" Name="iDDataTextBox" StyleName="Data" />
      </Items>
    </DetailSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style Color="28, 58, 112">
        <Font Name="Tahoma" Size="18pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Title" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="28, 58, 112" Color="White" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Caption" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Data" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="8pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="PageInfo" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="Letter">
      <Margins>
        <MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <Groups>
    <Group Name="labelsGroup">
      <GroupHeader>
        <GroupHeaderSection PrintOnEveryPage="True" Height="0.28125in" Name="labelsGroupHeader">
          <Items>
            <TextBox Value="Create Date" CanGrow="True" Size="1.58854166666667in, 0.200000027815501in" Location="0.0208333333333333in, 0.0208333333333333in" Name="createDateCaptionTextBox" StyleName="Caption" />
            <TextBox Value="ID" CanGrow="True" Size="1.58854166666667in, 0.200000027815501in" Location="1.63020833333333in, 0.0208333333333333in" Name="createIDCaptionTextBox" StyleName="Caption" />
          </Items>
        </GroupHeaderSection>
      </GroupHeader>
      <GroupFooter>
        <GroupFooterSection Height="0.28125in" Name="labelsGroupFooter">
          <Style Visible="False" />
        </GroupFooterSection>
      </GroupFooter>
    </Group>
  </Groups>
</Report>
Matthew
Top achievements
Rank 1
 asked on 30 Nov 2012
6 answers
101 views
Hello I have a problem with the Area chart. When i use that type of chart my result is not correct. I mean that the plot not match x-axis values. When i use Stacked Area type the values are correct. I use the same datasource and all settings, i am only changing the type.

I tried to grapchically show my problem, can you tell me how to add attachement?.
This is my grapchic interpretation, i hope someone will understand me.
http://i50.tinypic.com/2qk4046.png

I really appreciate any ideas why this situation is happening.

Regards, Paul.
Steve
Telerik team
 answered on 30 Nov 2012
22 answers
632 views
Does Telerik have any plans to add Qr-codes to the list of available bar codes? They seem to be gaining a lot of popularity (especially for scanning with phones) and are included in some of the competitors products. 

http://en.wikipedia.org/wiki/QR_Code
Vasssek
Top achievements
Rank 1
 answered on 30 Nov 2012
2 answers
345 views
I have an expression that uses division but it always returns zero. Here some examples of what I have tried:

=RunningValue('group1',Count(Fields.[Short Description])) / Exec('Report1', Count(Fields.[Short Description]))
Returns 0

=RunningValue('group1',Count(Fields.[Short Description])) / 64
Returns 0

=Count(Fields.[Short Description]) / Exec('DuplicateCARs', Count(Fields.[Short Description]))
Returns 0

=(3 /15)
Returns 0

The cell is formatted as a number with 2 decimal places assigned.

The running value does in fact return an int every time, I have tested it. So, why does this expression always return a zero? All other math opperators work fine; addition, multiplication and subtraction.
David
Top achievements
Rank 2
 answered on 30 Nov 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?