Telerik Forums
Reporting Forum
1 answer
82 views
Hello,

I try to connect with a SqlDatSource to a Acces 2003 query with parameters. I get the following error message

Retrieving procedure parameter information is not supported by the 'Microsoft.Jet.Oledb4.0' provider

Does the SqlDataSource not support Acces queries?

Here's the code

Dim report1 As New ReportName()
        report1.ReportParameters.Add("NumeroPersonne", ReportParameterType.Integer, 4)
        Dim sqlDataSource2 As New SqlDataSource()
        sqlDataSource2.ProviderName = "System.Data.OleDb"
        sqlDataSource2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Erisk\RiskAssessment\data\RiskAssessment.mdb"
        sqlDataSource2.SelectCommand = "std_KYC_BO_NoParam"
        sqlDataSource2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
        sqlDataSource2.Parameters.Add("@NumeroPersonne", DbType.Int32, "=Parameters.NumeroPersonne")
        report1.DataSource = sqlDataSource2
        rvClients.Report = report1
        rvClients.RefreshReport()


Peter
Telerik team
 answered on 27 Apr 2010
0 answers
105 views
Hi..
Do you have any examples with a Master / Detail... Like your Invoice / Sales Order example that uses Linq?

Object binding to an object that looks something like this

class Customer
    string  _name
    EntityRef<orders>  _orders

How do you handle the subreport parameters?

Do I need the subreport parameters?

thanks again for your help
 
Jon
Top achievements
Rank 1
 asked on 27 Apr 2010
1 answer
57 views
When I run any report with my web application session "InProcess" mode, everything looks fine, when I change the mode to "OutOfProcess" using a state server, my images are broken. I checked the properties of the image and it's a handler called

Telerik.ReportViewer.axd

here's what I get when i put the link on my browser:

http://laptop01:8002/Telerik.ReportViewer.axd?instanceid=45d46da60fbb4619ae271d8bb9180196&optype=ReportImage&StreamID=33j1dllerds

HTTP Error 404.0 - Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Please help.

Steve
Telerik team
 answered on 27 Apr 2010
2 answers
302 views
Hello,

I'm searching how can i count with a condition, For example:

GROUP 1 
       NUMBER 
       1 
       0 
       1 
       0 
       0 
       Total 0 = 3/ Total 1 = 2 
GROUP 2 
      NUMBER 
       1 
       1 
       1 
       0 
       0 
       Total 0 = 2/ Total 1 = 3 
TOTAL GROUPS Total 0 = 5 / Total 1 = 5 
 
 
 
Total 0 = 3 (it counts when the FIELDS.NUMBER = 0
Total 1 = 2 (it counts when the FIELDS.NUMBER = 1


I didn't find an example for that, I think is very simple but I don't know how to do it.

I want to do it in a group footer sections.

Thanks,
Daniel Botero Correa
Daniel Botero Correa
Top achievements
Rank 1
 answered on 27 Apr 2010
0 answers
151 views
Hi Team,

This is regarding creating a table of contents page in a telerik report. As telerik reporting is not supporting table of contents I had to find another solution for this. I was able to identify the book marked topics and page numbers by creating a pdf for the report. And what I need to do is if I will pass the table of contents as object collection (object may contain topic and page number of bookmark) as a parameters to a report. Can we generate the report's pre-designed table using that data collection as data source? This is urgent matter. Hope your assistance asap.

Thank you.
Lasantha Ranasinghe
Top achievements
Rank 1
 asked on 27 Apr 2010
1 answer
202 views
Hi,

Im createing a subclass of StyleRule to apply on all reports of my project and i want to set borderStyle bottom to solid,
the problem is that borderStyle is read only,  is there another way to set the border style in a generic way?

thanks.
Chavdar
Telerik team
 answered on 26 Apr 2010
1 answer
210 views
I have the following code sample in while I want to access the reportparameter name "Data" 's value.  However, it shows up empty at runtime.  If I leave out this subroutine, my DatahtmlTextBox would show value from :

Me

 

.DatahtmlTextBox.Value = "{Parameters.Data.Value}" set inside the Private Sub InitializeComponent()

 


What am I missing here that I don't get any data within my DatahtmlTextBox_ItemDataBinding sub?
Private Sub DatahtmlTextBox_ItemDataBinding(ByVal sender As ObjectByVal e As System.EventArgs) Handles DatahtmlTextBox.ItemDataBinding  
Dim HtmlTextBox As Telerik.Reporting.Processing.HtmlTextBox = DirectCast(sender, Telerik.Reporting.Processing.HtmlTextBox)  
HtmlTextBox.Value = "<b>" & Me.ReportParameters("Data").Value & "I then</b> decided to open the word doc and save it as a .jpg." 
End Sub 
 
Peter
Telerik team
 answered on 26 Apr 2010
0 answers
60 views

hi all!
I'm trying to use a user-defined function in Telerik Reporting Q2 2009. but i get an error message "Undefined function call" when i use float or double as an argument in the function.
My function is
public static float Myfloat(float x)
        {
            return x;
        }

which i call using
=MyFloat(16.5)

BTW, if a change it like this

public static float Myfloat(int x)
        {
            return x;
        }

which i call using
=MyFloat(16)

it works fine.

What may be the problem? Thnx so much.

 

 

Abiri Masoni
Top achievements
Rank 1
 asked on 26 Apr 2010
4 answers
211 views
Hi All

I am trying to bind a report to an ObjectDataSource as in this: http://www.telerik.com/help/reporting/object-data-source-how-to-bind-to-business-object.html

the issue is that this form what I can see, will only work with winforms or asp.
  1. No Reference to ObjectDataSource
  2. Cannot reference a non silverlight class library in a silverlight app so therefore cannot get a reference directy to the report as in this section of the example code:
var report = new Report1(); 
 
            // Assigning the ObjectDataSource component to the DataSource property of the report. 
            report.DataSource = objectDataSource; 

Is there anyway to do this in sliverlight??

What I am trying to do is bind to the ItemSource of a GridView in silverlight so that the user can filter, group, etc at runtime on the GridView and the report will be bound to the changes.

Please help me?!

Nick
Peter
Telerik team
 answered on 26 Apr 2010
1 answer
335 views
Is it possible to change a reports PageSize at Runtime?
Peter
Telerik team
 answered on 23 Apr 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?