Telerik Forums
Reporting Forum
1 answer
202 views
Hello,
We are using Telrik reporting 2008 and we want to make it bilingual in French and English.
We have report classes in App_code folder and report viewer on an aspx page in the root of the directory.
We have created the resx files.Like for AllOrders.cs ,we created AllOrders.resx and AllOrders.fr-FR.resx by following telrik support and added the namespaces threading and globlization in the page containing report viewer.
We added required localization  code in the  same viewer page.
But when we run it we get always this error.

Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "AllOrders.resources" was correctly embedded or linked into assembly


Can you please guide us how make it bilinguial in our case, the steps please?
Steve
Telerik team
 answered on 10 Jul 2009
1 answer
148 views
Hi

I know, there are already a lot of article in this forum, that covers this topic.
I read a lot of them, and the documentation and watched a few videos ... i don't get this to work!
Please help.

Scenario:
MasterReport:
public partial class repRegisterConfirmMaster : Telerik.Reporting.Report  
  {  
    private int iBenutzerId = -1;  
    public int PARAMETER_BenutzerId  
    {  
      get { return iBenutzerId; }  
      set { iBenutzerId = value; }  
    }  
 
    private int iOrderId = -1;  
    public int PARAMETER_OrderId  
    {  
      get { return iOrderId; }  
      set { iOrderId = value; }  
    }  
 
    private sbyte iSpracheId = -1;  
    public sbyte PARAMETER_SpracheId  
    {  
      get { return iSpracheId; }  
      set { iSpracheId = value; }  
    }  
 
    public repRegisterConfirmMaster()  
    {  
      InitializeComponent();  
    }  
 
    public void loadReportData()  
    {  
        this.dsBenutzerKundeAdresseKontaktTableAdapter1.Fill(this.dsBenutzerKundeAdresseKontakt.dsBenutzerKundeAdresseKontaktTable, iBenutzerId);  
    } 

I have in the dataset "@BenutzerId" included in the query and this is used when filled the DataTable. Works fine.

The Subreport just looks the same:
public partial class subRegisterConfirmModul : Telerik.Reporting.Report     
  {     
    private int iOrderId = -1;     
    public int PARAMETER_OrderId     
    {     
      get { return iOrderId; }     
      set { iOrderId = value; }     
    }     
    
    private sbyte iSpracheId = -1;     
    public sbyte PARAMETER_SpracheId     
    {     
      get { return iSpracheId; }     
      set { iSpracheId = value; }     
    }     
    
    public subRegisterConfirmModul()     
    {     
      InitializeComponent();     
    }     
    
    public void loadReportData()     
    {     
      this.dsKundenModulByOrderIdTableAdapter1.Fill(this.dsKundenModulByOrderId.dsKundenModulByOrderIdTable, (byte) iSpracheId, iOrderId);  
    }    
 

Now, from an aspx-page, i call the report, set the values of the master-report and calling the loadReportData() of the master.
...
        
ReportViewer1.Report = new repRegisterConfirmMaster();  
        (ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_BenutzerId = 77;  
        (ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_OrderId = 94;  
        (ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_SpracheId = S.SpracheId;  
        (ReportViewer1.Report as repRegisterConfirmMaster).loadReportData(); 

The report shows up, but only the report-header (filled thru master) is filled with datas. The detail section (filled thru subreport) generates an error or the whole subreport is invisible.
I try these things as well:
- using NeedDataSource in master (subreport_needDataSource) and/or subreport
- ItemDataBinding in master (detail_ItemdataBinding)
- Calling SubReport.loadReportData() from within the Master.loadReportData(), with setting the appropriate values of the subreport first
- Every combination af the aboved mentioned, and a few helpless tries more
- I even recoded the whole thing, trying to work with the integrated Report.Parameters as described in the help documentation ... no luck: designing-reports-master-detail.html
- I get it once to work: I hardcoded the correct values of "iOrderId" and "iSpracheId" in the subreport. So i think passing the parameters at the right time, in the right place, the right way, then it should work.
I'm sure, there has to be a simple way to do this.

TIA
Markus
Markus
Top achievements
Rank 1
 answered on 10 Jul 2009
1 answer
264 views
Hi there,

Currently im trying on your reporting tool. I have few questions to ask.

Description:

  1.  Type of project           :  web site application
  2.  Used language           :  (C#)

3.    OS                             :  xp pro service pack 3

       Tools/product            :   Telerik reporting version 2009.2 701 (Jul 1, 2009) 

        Web Viewer version  : 3.0.9.430

 

 

 

i would to know how to call user defined function from mssql to be displayed in a report. Pls provide me an example/documentation regarding this issue. One more thing, im using automatic ui parameterized feature to filter data ( which prompt user input ), i want to use more than one parameter to filter data. When i just tried to add more parameter it failed to work but working well with one parameter. How to address this problem?    Since im working with web application, when i want run the project thru localhost, the page is empty (no data displayed) but i could preview the report. How to solve this portion.

Thank You

Your guidance is much appreciated

Regards

Pat

Steve
Telerik team
 answered on 09 Jul 2009
4 answers
1.0K+ views
Sorry if this is a silly question or if I'm using the wrong terminology. I am not so familiar with the PDF specs.

The report I am exporting to PDF is mostly white space with a little text (as are most reports, I suppose). However, I don't really want it to be "white space". Instead, I want it to be "transparent" or "empty space".

Why?

I have another PDF that we refer to as "Electronic Letterhead". We take the "Electronic Letterhead" and imprint the report "on top of" it. Similar to putting pre-printed letterhead in your printer then printing the report on it. Imagine, however, if your printer actually printed white ink all over your pretty letterhead thereby effectively hiding it. Ouch! That's what's happening when we layer the telerik report (exported to PDF) on top of our "Electronic Letterhead". Is there any way to tell the PDF export to leave the white space "transparent" instead of "white"?

FWIW, we are using ABCpdf to "merge" the two documents.
Steve
Telerik team
 answered on 09 Jul 2009
1 answer
97 views
I recently just upgraded from Telerik_Reporting_2009_1_430_trial.msi to Telerik_Reporting_2009_2_701_dev.msi. I followed all of the steps listed at (http://www.telerik.com/help/reporting/installation-upgrading-trial-to-dev.html) . I have a report called MasterReport.cs that contains various subreports. It appears now when viewing the MasterReport.cs in design time (through VS 2008) the data for the sub reports is not showing. (Header sections for the sub reports do however...)
  Whats even weirder is I view the report through a report viewer on a web page everything (including the data for the sub reports) displays fine. So one thing I noticed right away was in my class library project(the ones containing the reports)  I can no longer reference the telerik.reporting.processing namespace as I was before upgrading. In the trial version ,I believe there was a seperate .dll for this namespace whereas now it exists in the telerik.reporting.dll. (telerik.reporting.dll I have infact already referenced)
  i believe this is where the problem maybe as I have no way to reference the   telerik.reporting.processing namespace. In my masterreport.cs I also use objects from this namespace it in the NeedDataSource even to set datasource for subreports. Still not sure why it works on the web page however. So I guess my questions are 1) Is there a way to reference telerik.reporting.processing    in my class library project? 2) Could it be something else that is causing this weird behavior.
Jason
Top achievements
Rank 1
 answered on 09 Jul 2009
1 answer
124 views
If I create a report using an existing dataset I get "Object reference not set to an instance of an object." when previewing. If I create a new dataset with the report wizard everything works ok.

I'm connecting the SQL Server.
Any ideas?

Thanks!
Steve
Telerik team
 answered on 09 Jul 2009
4 answers
295 views
Hi Everyone,

I read this thread and apply it in order to add several subreports on the same detail section.

My problem is that the first sub report is more than one page and that messes with the render:

The first page is blank
The second page is filled with the first part of the first subreport
The third page is filled with the second part of the first subreport and the second subreport
The fourth page is blank
The last page is filled with the last subreport.

here is my code:
Telerik.Reporting.SubReport subRep;  
Unit unitX = Unit.Cm(0.1);  
Unit unitY = Unit.Cm(0.1);  
SizeU size = new SizeU(Unit.Cm(0.5), Unit.Cm(0.5));  
 
foreach (string wo in woArray)  
            {  
                
 
                //create subreport   
                subRep = new SubReport();  
                subRep.Size = size;  
                subRep.Location = new PointU(unitX, unitY);  
 
                subRep.ReportSource = new Report(wo);  
                unitY = unitY.Add(Unit.Cm(2));  
 
                 
                detail.Items.Add(subRep);  
 
            }  
 

Thank you.
 PS: I would like to have all subreports to begin on a new page regardless of the length of the predecing subreport if any
regis
Top achievements
Rank 1
 answered on 08 Jul 2009
2 answers
185 views
Hi

I need a radar chart in my report, how can i do that with telerik reporting ?
John
Top achievements
Rank 1
 answered on 08 Jul 2009
1 answer
46 views
Hi,

How to set a text of an item in a reportheader section programatically?

Like while during postback need to get values based on user selection in an aspx page and set it in an item of report header section.

Help is very much appreciated.




Steve
Telerik team
 answered on 08 Jul 2009
1 answer
108 views
I have a report that I need to run automatically and generate sets of PDF files to specific folders on a network share drive, each with a unique name. I had setup a quick project with MS Access and was able to do this, although it's a bit buggy. For production I recoded the report into a Winform app using Telerik Reporting Q1 2009. The app does function as intended, but I noted that the machine gobbles all of the memory. I can watch the app run and as it's generating new PDFs, the memory use just continues to climb. I tried to do what I figured would release the memory, but it's not working.

Here's my code, did I miss something? How do I get the application to quit grabbing memory as it runs?

The report has 2 subreports included on the same page.

----Routine start---
        Dim con As New SqlConnection(My.Settings.CCO_MM_DATA)

        Dim sql As String = "usp_RptFaceSheet_ClientList_DIST"
        Try
            con.Open()
            Dim da As New SqlDataAdapter(sql, con)
            Dim ds As New DataSet
            da.Fill(ds)

            'Get Data Table
            Dim dt As DataTable = ds.Tables(0)

            'Display Data
            For Each row As DataRow In dt.Rows
                If Directory.Exists("S:\Development\FaceSheets\" & row(2).ToString) Then
                    Me.ReportViewer1.Report = New TestFaceSheet.Report1

                    TryCast(ReportViewer1.Report, TestFaceSheet.Report1).ReportParameters(0).Value = Int32.Parse(Trim(row(0).ToString))
                    Dim mimType As String = String.Empty
                    Dim extension As String = String.Empty
                    Dim encoding As Encoding = Nothing
                    Dim deviceInfo As Hashtable = New Hashtable
                    deviceInfo("FontEmbedding") = "None"
                    Dim buffer As Byte() = ReportProcessor.Render("PDF", ReportViewer1.Report, deviceInfo, mimType, extension, encoding)
                    Dim fs As New FileStream("S:\Development\FaceSheets\" & Trim(row(2).ToString) & "\[" & Trim(row(1).ToString) & "]ClientInfo.pdf", FileMode.Create)
                    fs.Write(buffer, 0, buffer.Length)
                    fs.Flush()
                    fs.Close()
                    deviceInfo.Clear()
                    fs.Close()
                    ReportViewer1.Dispose()

                End If

            Next
            con.Close()

        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            con.Close()

        End Try
        End
----Routine end----
Steve
Telerik team
 answered on 08 Jul 2009
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?