Hello all, i got problem passing string from default.aspx to report1.vb (telerik report code). Im using session to pass the string but it seems that report1.vb couldn't accept the string even when im using System.Web.HttpContext.Current.Session("name"). This is my code for defaultx.aspx and report1.vb

defaultx.aspx
<code>
 If DropDownList1.Text <> "Select" Then
            Session("name") = DropDownList1.SelectedValue.ToString
            Response.Redirect("Webform1.aspx")
        End If
</code>

report1.vb

InitializeComponent()
Dim valueFromDropdown As String = System.Web.HttpContext.Current.Session("name")
Dim objCommand As New SqlCommand
        
objCommand.CommandText = "SELECT * FROM student where Name='" + valueFromDropdown & "'"
objCommand.Connection = New SqlConnection("Data Source=(local)\FT2010;Initial Catalog=student;Integrated Security=True")
objCommand.Connection.Open()

FYI I have insert telerik reportviewer in Webform1.aspx and also set report location in its properties (telerik reportviewer) but when debugging, the error occured "exception has been thrown by the target of an invocation" and it points me to the System.Web.HttpContext.Current.Session("name") code in report1.vb

What im doing wrong here please guide me. Thanks!

Hi,

I've followed this thread http://www.telerik.com/community/forums/reporting/telerik-reporting/bind-grouping-runtime.aspx and have downloaded the example (which works fine).  I've implemented the same techniques (as far as I know) in my own report, but when doing a preview, instead of getting a drop down box with a list of items that I can group by, I get a free text field.  If I enter a valid column name in this field, it works, but I would like my users to select from a drop down.
I've very likely missed something in your example, but I can't find which thing I need to change.

Thanks

Mick

Hi' I'm working with telerik reporting q2 2010. My problem is the next:
I'm doing a master-detail report wich I generate on a button_click event
Depending of the values of the comboboxes will be the parameters of the report, amd as you can see in the btnGeneraRep_Click event if conditions are valid, it opens a new page whose code behind is the next Here's is where I call the report. Repconcentrado is a Master-Detail report where the master report is called criterioreport(the code below) and reptoteles wich contains the count result of sorted by "Circuito"


What I want to do is when clicking  btnGeneraRep_Click  in the first page send an alert wich says that there's no data under the specified criteria and do not redirect to the second page.

Here's the code of my report

Hope yor help.
Regards Cristian.

Hello,

I have a (hopefully) easy question/problem:

I am using an objectdatasource to populate a Telerik Report. This is working fine. Now I want to change one of the parameters of the select function in the DataSource to accept a multi-value parameter (multiple ints), but regardless what I try as type (object, object[], int[]), I always get the error that the following error during creation of the report:

The last error translates to "an object has to implement IConvertible".

I even changed the parameter of the function in the objectdatasource to type IConvertible, with no luck.

What am I doing wrong to get multivalue parameters to work?

BTW: I am still at Q1 2010 release and have not yet updated to Q2

best regards

Ulrik

I am trying to write a simple report with one parameter. The data field that I am using as a parameter, contains Null values. When I try to run the report, I get the error: An error has occured while processing Report": Object cannot be cast from DBNull to other types.

The field column is a date field.

If I remove the parameter, the report works. How do I get around the Null values?

This is a class in a VB.Net project, not an ASP.Net page.

I have the filters for my textbox set up this way:

             =Fields.LeaseType         =      =Parameters.DealTypeId.Value
AND      =Fields.MedicalEntityId     =      =Parameters.MedicalEntity.Value

However, MedicalEntityId is a nullable value in the database, and I just want it to display the records where the MedicalEntityId is null when I don't specify a value for it in the dropdown list under the preview tab.

When I add in the second parameter and I try to run the report, I get this error: "Object cannot be cast from DBNull to other types." 

My initial thought was to change the second filter expression this way :

AND     =Fields.MedicalEntityId     =       =IsNull(Parameters.MedicalEntity.Value, Null)

but I get the same result with that. What am I missing?

Sorry if I mistake with forum, I don't know where post this question.

So my question is, can I use Telerik Reporting with Oracle APEX.

Again sorry.

Thanks.

Error:
A connection string was referenced by name but could not be resolved through the web.config.

I am running into this on my reporting project.  In my web.config file I have:

And in the sql.config I have:

I create a brand new report, add a OpenAccessDataSource using the wizard and point the connection string to BarcodeEntityDiagrams.  When I go to the Preview tab of the report I get the error:

Again, this is a brand new report using the report wizard. No custom code at all.  Any suggestions? I'm using Reporting 5.1.11.713

I'm evaluating reports and I'm stuck. I need to generate a report over multiple days gathering data from csv files. My plan is to read in all the data and parse it into classes. From there I create a reportbook and add a report per day. On the report I would like to show something like the attached image.

http://www.telerik.com/ClientsFiles/304709_example-report.png

Here are the two data models I was planning to use.


When I create the report I call a setup method that takes a model with all the count data for the date. When the report calls the NeedDataSource event I parse the data into time slices and fill an IntervalApproachModel with all the counts during that time slice. I set the data source to a list of IntervalApproachModels.

I was trying to use a crosstab but I can't seem to get it to appear like the image. Is this the correct way to achieve my goal? How can I set up the crosstab to display correctly?

I have designed my first report. Data connection was created via the wizard and works fine in the preview mode. However when trying to launch the report via a webviewer on an aspx page, it is unable to connect to the database. The error says:

An error has occurred while processing Report 'RTARevenues':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0.

I tried copying the connection string used elsewhere in the project into the app.config file and using it for the report but that did not work either.
What do I need to do to get this to work?
Thanks