Telerik Forums
Reporting Forum
1 answer
188 views
Hi,

We need to know if there is any workaround for printing each Table Group on New page. Basically our Report Datasource is already bind and having Group with setting Page Break After in Group Footer.  Report contains a Table having different Datasource also having Grouping. Now it is required that each Table Group should appear on next Page addition to existing Report group. 

Please advise any way to address the requirement...

Thanks,
devoas.
Steve
Telerik team
 answered on 12 Apr 2012
3 answers
146 views
I want to print multiple pages with a predesigned format (blank pages with no detail, only header and footer) and in the bottom I put the page number. for example, tell you the order number (parameter), how many pages I want to print, and when I click a button to show me or send me to print the format and page in top the order number I gave him and in the page footer print: page 1 of 5, etc..

Can we do this?

Thanks
Steve
Telerik team
 answered on 12 Apr 2012
3 answers
787 views

Good morning.

ASP.Net front end, telerik reporting, MS SQL 2008 Database.

I'm trying to pass in multiple pkeys as parameter into a telerik report tableadapter.  First, I tried passing them as integers, then I converted the integer keys to a string.  One integer works fine, one string item works fine, but when I try to pass in more than one, the report displays a blank page.  I tried a system array, blank page.  I tried an arraylist, blank page.

I would prefer to pass in the integers (not having to convert them) but at this point, I'll try anything.

First, the code from the app, second, the code from the report:

 ' run through the XML document passed by the client and post all of the  
        ' "checked" rows  
        inputXML = New XmlDocument  
        inputXML.LoadXml(Server.HtmlDecode(DETAILS_XML.Value))  
        rowNodes = inputXML.SelectNodes("ROOT/Receipt")  
        postCount = 0  
        confirmedKeys = New StringBuilder("")  
        'rKeyStr = CStr(confirmedKeys.ToString)  
        For Each rowNode In rowNodes  
            If rowNode("Print").InnerText = "Y" Then 
                postCount += 1  
                If confirmedKeys.Length > 0 Then 
                    confirmedKeys.Append(",")  
                    rKeyStr = rKeyStr & "," 
                End If 
                confirmedKeys.Append(rowNode("PKey").InnerText)  
                rKeyStr = rKeyStr & rowNode("PKey").InnerText  
            End If 
            '  
        Next 
        '  
        '  
        sKey = Session(SESSION_SKEY)  
        '  
        '  
        btnPost.Visible = True 
        '  
        '**********************************************************************************  
        rvReceipt.Report = New SCOReports.Receipt(sKey, rKeyStr)  
        rvReceipt.RefreshReport()  
        rvReceipt.Visible = True 
        '**********************************************************************************  
 
'  REPORT CODE IS NEXT....  
 
Public Sub New(ByVal sk, ByVal rKeys)  
        InitializeComponent()  
 
        'TODO: This line of code loads data into the 'DatReceipt.datReceiptTable' table. You can move, or remove it, as needed.  
        Try 
            Me.DatReceiptTableAdapter1.Fill(Me.DatReceipt.datReceiptTable, sk, rKeys)  
        Catch ex As System.Exception  
            'An error has occurred while filling the data set. Please check the exception for more information.  
            System.Diagnostics.Debug.WriteLine(ex.Message)  
        End Try 
 
 
        'TODO: This line of code loads data into the 'DatRecDet1.DatRecDetTable' table. You can move, or remove it, as needed.  
        Try 
            Me.DatRecDetTableAdapter2.Fill(Me.DatRecDet1.DatRecDetTable)  
        Catch ex As System.Exception  
            'An error has occurred while filling the data set. Please check the exception for more information.  
            System.Diagnostics.Debug.WriteLine(ex.Message)  
        End Try 
    End Sub 
End Class 
 
'  THE SQL FOR THE TABLE/TABLEADAPTER...  
SELECT     RM.PKEY, RM.SKEY, RM.REC_NBR, RM.REC_DATE, RM.REC_CASH, RM.REC_CHECK, RM.REC_CREDIT, RM.AMOUNT, RM.RECEIVEDBY,   
                      RM.CHKREF, S.LNAME + ', ' + S.FNAME + ' ' + ISNULL(S.MNAME, '') AS STUDNAME, ISNULL(P.FNAME, '') + ' ' + ISNULL(P.LNAME, '') AS PNAME,   
                      SCH.NAME AS SCH_NAME, D.TAXID, RM.PKSTR  
FROM         RECEIPTMASTER AS RM INNER JOIN  
                      STUDENT AS S ON RM.STUDKEY = S.PKEY LEFT OUTER JOIN  
                      PARENT AS P ON S.PRI_PGKEY = P.PKEY INNER JOIN  
                      SCHOOLS AS SCH ON RM.SKEY = SCH.PKEY INNER JOIN  
                      DISTRICT AS D ON SCH.DISTRICTKEY = D.PKEY  
WHERE     (RM.STATUS = 'C') AND (RM.PEND_REC_NBR = 'PRINT') AND (RM.SKEY = @SKEY) AND (RM.PKSTR IN (@Keys))  
ORDER BY RM.REC_NBR  
 

Thanks in advance for taking a look.

LEBREW

Randa
Top achievements
Rank 1
 answered on 11 Apr 2012
4 answers
157 views
I have tried to set the changes to my line chart programatically.  This is the code I have edited inside of my .cs file.  I pushed through the changes, but nothing has shown up on my work.  I am guessing that these strings do not change the colors of the lines, then?


Telerik.Reporting.Charting.ChartSeries chartSeries1 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.Charting.ChartSeries chartSeries2 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.Charting.ChartSeries chartSeries3 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.Charting.ChartSeries chartSeries4 = new Telerik.Reporting.Charting.ChartSeries();
chartSeries1.Appearance.FillStyle.MainColor = System.Drawing.Color.Blue;
chartSeries2.Appearance.FillStyle.MainColor = System.Drawing.Color.Red;
chartSeries3.Appearance.FillStyle.MainColor = System.Drawing.Color.Green;
chartSeries4.Appearance.FillStyle.MainColor = System.Drawing.Color.Yellow;
Matt
Top achievements
Rank 1
 answered on 11 Apr 2012
5 answers
151 views
Good Morning,

I've been working on a line chart for a project, and managed to solve all o fmy questions, save one.  I changed the font size of the chart's X and Y axis labels to 15, then hit save.  I noticed that on the designer, the changes were shown.  However, when I hit preview to test those changes, the font remains the same 8.25 it was before.  The properties field shows the font size I asked for as well.  Needless to say, I am little confused as to why Telerik is refusing to accept changes.  Does this have to happen programatically, instead of the properties interface?

Thanks!
Steve
Telerik team
 answered on 11 Apr 2012
3 answers
69 views
Hi, 

In one of my report I receive a custom business Object in the constructor, containing all needed data for the report.

I basically set the DataSource to the object I receive in the constructor.

For simple textbox it works quite good, but in my report I'm using a table, not because I receive a list of data that I want to display in a tabular form, but because I've a lot of "Label-> text" to display, two of them per line, and sometimes one line will be to large to stay on one line, so I want that other fields take the same offset.

So here is what I got now: http://screencast.com/t/r7dLQZlTB

All fields which aren't in the table are working good, but I can't make any of the field in the table working.

I tried to set the DataSource of the the table to Fields(through binding), but It doesn't works.

What is my best shot to do this?
Steve
Telerik team
 answered on 10 Apr 2012
0 answers
61 views
I want to make report like this :

Fields AAAA
ModifiedBy        Value
ecaron                1
ecaron                5
Fields BBBB
ModifiedBy        Value
ecaron                A
sparadis             B

My Datasource contain : FieldName, ModifiedBy, Value

How I can make this. I want to create report in designer not dynamically

Thanks
ericc34
Top achievements
Rank 1
 asked on 10 Apr 2012
1 answer
127 views
Hi,

I have posted this issue yesterday as well. But has been removed from the forum. I am using date parameters with a report and cannot post the selected value back to the report for filtering. I have tried several ways.

Case 1:
I allow null values and set a default value to the parameter in the constructor. When I select a value from the date picker and click the preview button, the default value is passed and not the one that I selected.

Case 2:
I allow null values but do not supply a default value. I can select a value from the date picker but the preview button is not enabled.

Please be kind enough to supply a solution.

Regards,
Priyan
Steve
Telerik team
 answered on 10 Apr 2012
4 answers
252 views
This should be very simple but I can't figure out how to do it.  I have spent hours looking for a solution and trying different options.

I have a sql datasource with data as:

Period     |  Avg_Total
1/1/2011  |  $1000
2/1/2011  |  $1500
3/1/2011 |  $2000
...
...
12/1/2011 | $ 1200

I set my Chart's properties as:
- PlotArea.XAxis.AxisLabel.DataLabelsColumn = Period
- Series collection with DataYColumn = Avg_Total

I keep getting the error message.  Unable to cast object of type 'System.DataTime' to type 'System.String'.  All I want is a line chart with X-Axis with date value and Y-Axis for the avg_total.  I even upgraded to the latest version, Telerik Q1 2012, and is still getting the same issue. 

Help??
Hadib Ahmabi
Top achievements
Rank 1
 answered on 09 Apr 2012
1 answer
230 views
I just got through my first major experience with Telerik reports, and I hope this can prove to be some constructive criticism.  While the API and the documentation & forum were very good, I was trying to do something very specific that I simply had the most difficult time completing.  I was trying to use a table (as a sub-report) and dynamically remove *some* header rows while keeping others depending on the number of rows returned by the underlying stored procedure.  I really, really, really, really wish there was an easy way to programmatically get at the number of rows returned in a Telerik SqlDataSource object.  I also wish it was made more clear that the DataObject property referred to the *parent*'s data source.  

Also, it seems that there are some unknown (unknowable?) rules about what table cells can and cannot be merged - something I find completely bizarre.  I sort of hope that in the future there is some better documentation that clearly explains how rows can be removed from a table.  Also, I think that this functionality relied on having the table set up absolutely perfectly in the designer screen.  Is it possible that a checklist could be set up of items to look for to insure that my table is set up correctly to allow me to remove rows?  I greatly appreciate that you allow options to be set at runtime via the event handlers like Table_ItemDataBound, but man... finding simple, reliable answers to row counts, and turning off/making invisible/removing table rows was very difficult to come by.   
Steve
Telerik team
 answered on 09 Apr 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
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?