Good Day all 

i have done a basic report using telerik Reporting a long time ago , i think its been 3 years if i remember correctly and the report was so basic that it was simple to do. i have a  requirement now for a Finance system or Accounting System. I have the Data that comes already calculated via my SP.

My Requirement is as Follows , i want to display the Following format 

	Audited	Audited	Audited	Un-audited
BALANCE SHEET	Mar-08	Mar-09	Mar-10	Mar-11
NET FIXED ASSETS	23 159 616	24 968 321	24 352 332	23 198 353
DEFERRED ASSETS	0	0	0	0
INTANGIBLE ASSETS	0	0	0	0
OTHER ASSETS	50 000	50 000	50 000	50 000
TOTAL NON CURRENT ASSETS	23 209 616	25 018 321	24 402 332	23 248 353
CASH	36 354	80 101	148 987	521 611
ACCOUNTS RECEIVABLE	11 756 559	11 365 227	9 223 685	7 562 145
INVENTORY	4 708 984	4 269 738	3 941 538	4 613 054
OTHER CURRENT ASSETS	51 478	0	0	0
TOTAL CURRENT ASSETS	16 553 375	15 715 066	13 314 210	12 696 810
TOTAL ASSETS	39 762 991	40 733 387	37 716 542	35 945 163
LONG TERM DEFERRED TAXES	3 054 804	4 889 626	3 058 807	3 017 438
LOANS FROM SUBSIDARIES	0	0	0	0
SENIOR LONG TERM DEBT	106 862	132 275	64 002	23 208
LOANS FROM SHAREHOLDERS/DIRECTORS	0	0	0	0
SUBORDINATED DEBT	0	0	0	0
OTHER LONG TERM LIAB	0	0	0	0
PENSION PROVISIONS	0	0	0	0
OTHER PROVISIONS	0	0	0	0
TOTAL NON CURRENT LIABILITIES	3 161 666	5 021 901	3 122 809	3 040 646
SHORT TERM DEBT	6 490 204	3 134 461	760 328	0
ACCOUNTS PAYABLE	4 916 314	5 443 842	7 549 264	6 847 010
TAXES PAYABLE	0	80 553	327 398	344 951
CURR MAT OF LONG TERM DEBT	115 259	111 210	72 718	35 740
OTHER CURRENT LIABS	102 974	488 242	0	26 436
TOTAL CURRENT LIABILITIES	11 624 751	9 258 308	8 709 708	7 254 137
TOTAL LIABILITIES	14 786 417	14 280 209	11 832 517	10 294 783
SHAREHOLDER'S FUNDS	24 976 574	26 453 178	25 884 025	25 650 380
MINORITY INTEREST	0	0	0	0
TOTAL EQUITY	24 976 574	26 453 178	25 884 025	25 650 380
TOTAL LIABS AND EQUITY	39 762 991	40 733 387	37 716 542	35 945 163
BS TEST (S/B 0)	0	0	0	0

now each financial year (Mar-08 ) is stored as a record in the db, all this are calculated already i only want to display them, OK my challenge here is that i have a maximum of 4 financial years 

Mar-08

Mar-09

Mar-10

Mar-11

i want to generate the financial years based on the data that comes , so there might be 2 or 1 or 3 or 4 so i need to bind this dynamically , how can i achieve this with Telerik report. 

Thanks  

Hi Telerik Team,
I created RadChart and text report programmatically. I need to move my chart and text report inside of a ReportViewer for exporting that to Excel,pdf etc... 
But I am not sure how to make that and please help.
Please get the attached  sample.

  

hi,
    is there any body lucky in finding out wpf report  viewer in telerik reporting tool.
    1. I installed  telerik reporting tool after that i started to create a sample report that i kept in a control library project.
    2.then I added a wpf application project in the same solution.after that i added references  teassemblyref://Telerik.ReportViewer.Wpf, control library ( a report is created inside before).
    3. then i added the same(Telerik.ReportViewer.Wpf) in my xaml code file and given the alias.
    4.after that ,inside the  grid tag i added a tag and entered the alias and called report viewer and given aname and closed the tag.

 but no report viewer is added inside the wpf window.

but after installng RAD Control tool  report viewer is displaying in case we following the same procedure discussed above.

 if i am right,then my question is why wpf report viewer is not available in telerik reporting tool and for that only we have to purchase RAD control also why?

waiting for a reply thanks for taking care of this thread
Adil

Hi,

I want to generate .docx file at runtime from telerik reporting. But it is giving error message "DOCX file format is not supported." while rendering.
Rendering is fine with "RTF". But telerik says that we are able to export in to .docx.

Hello, for some time I have been pulling my hair out trying to resolve a reference error when I upgraded my Telerik Reporting to the latest version.  Everytime I run my web app on my client's network I get a message stating Telerik.OpenAccess version 2011.3.1129.2 could not be found, but on refreshing the page, this error would disappear.

I searched for hours trying to find the incorrect reference and finally found it, but not in my code.

The incorrect reference is in version 6.1.12.611 of Telerik.Reporting.DatabaseSession.dll and if I use Just Decompile, I can see a missing reference to Telerik.OpenAccess version 2011.3.1129.2 and also to Telerik.OpenAccess.35Extensions version 2011.3.1129.2, at least in my version of the reporting dll.

How can there be a reference to 2011 Q3 OpenAccess in the 2012 Q2 Telerik Reporting dll?

Regards, Jonathan

I have inherited an application that was using a old version of the reporting tool.
Good news: I've gotten the above version installed on my machine (where none was installed previously).
Bad news: I got a number of compile errors now and I really haven't found anywhere to go where I can figure out what the code was/is doing.

I have made some changes to other methods (SWAGS trust me), but NO changes here.  Here is the method that is currently causing me headaches, although I'm sure there is more coming:

 

 

 

    Private Sub DetailSection1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailSection1.ItemDataBound
        Dim section As Processing.DetailSection = TryCast(sender, Processing.DetailSection)
        Dim typeText As Processing.ReportItemBase = section.Items.Find("txtType", False)(0)
        Dim mfgText As Processing.ReportItemBase = section.Items.Find("txtMFG", False)(0)
        Dim catalogText As Processing.ReportItemBase = section.Items.Find("txtCatalog", False)(0)
        Dim qtyText As Processing.ReportItemBase = section.Items.Find("txtQty", False)(0)
        Dim leadTimeText As Processing.ReportItemBase = section.Items.Find("txtLeadTime", False)(0)
        Dim notesText As Processing.ReportItemBase = section.Items.Find("txtNotes", False)(0)

        Dim row As DataRowView = TryCast(section.DataItem, DataRowView)
        If row IsNot Nothing Then
            Dim val As Object = row.Row("LINE_TYPE")
            If Not (TypeOf val Is DBNull) AndAlso _
              val.ToString.ToUpper = "GRP" Then
                typeText.Visible = False
                mfgText.Visible = False
                catalogText.Style.Font.Bold = True
               
            End If
        End If

    End Sub

Any help will be greatly appreciated!

Rich

 

 

Telerik,

I got a small problem with the background image for textboxes see screenshot below.
http://screencast.com/t/fNRZWVqLIJih

I use the following properties:
http://screencast.com/t/pDsNSRml4N3o

Is it possible to align the image to the right side?

Occasionally my report generates an exception which I wish to catch and handle in my web page.
I had a look at the post : http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-handle-errors-exceptions.aspx
which provides a nice piece of c# code.
I have translated this to VB to get this :
          
 AddHandler _rptBody.[Error], Sub(innerSender As Object, eventArgs As ErrorEventArgs)
      Me.ReportViewer.Report = Nothing
       Me.Label1.Text = eventArgs.Exception.Message.ToString()
End Sub

But sadly Visual Studio informs me that :

Error is not an event of object.

I have to say that c# is my language and not VB but sadly I have to do this in VB.

Am I doing something wrong here?

Hi,

i would bind a report with datas. i have a DAL method returns a collection of A objects contains a B object list.
List of A object contains properties and a list of B object.

i would fill my report's textboxes  with A properties and a table with A list of B object.
the DAL method is called from a aspx page with a reportviewer and a reportbook.

my reportviewer is correctly displayed but with empty reports.

Filling the report with A object properties works. but filling the table of the report with A object's List<B> does'nt work.

i fill my cells with =Fields.property

in the aspx page, i bind my report with the object with : report.Datasource = A object;

How can i fill my table?
thanks

I have a report that I am trying to create a cross tab for.

I can get it to creat the report fine but for some reasons the pages will repeat for the toalt number of records I have.
So when I print a report for 65 records it formats and creats the record and the first page is correct, but it creates 65 pagas all of them exaclty the same.  What am I missing?

my seltect is as follows

what I would like is to group on CategoryDescription and GroupDescription
then display SecutirityMasterDescription and Total

then pivot so the FamilyMemberName becomes the dynamic headers with the eTotal as the detail under the FamilyMemberName

The report formats to this design, but it displays it 65 times.
Also one other issue, there are time where there are no matching FamilyMembers so iti si getting a null value and printing an empty column, is their a way to suppres the blank column.