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

Good day,

I'm using value from database as a HTMLTextBox value and it displays it 'as is' (as a plain text). However, if I use the same HTML as HTMLTextBox value (add it directly, not from database) it displays it correctly. This is HTML:

HOw can I fix it?

Regards,
Alex

Hi,

I am looking for an easy way to navigate to a bookmark in another report but can't find one. Currently I have an extra report parameter on the report I want to navigate to, in this parameter I put the bookmarkID. On the propertychanged event of this parameter I can receive the ID but can't find a way to navigate to this ID from my code behind.

Any help would be appreciated!
Sven

Hello Guys

I am working with the crosstab, but it just shows the headers in the first page, the reports has around 100 pages, so is complicated to read, for that reason i want to know if Are there any possible to repeat the header columns in all pages to make easier the user read.

Regards

CM

Is it possible to navigate to a table containg the project details for the click event on pie chart (Both pie chart and table in same report.)?

That is the pie chart use to display number of process associated with each project.
So when click on one slice (represent a project) it should navigate to a table with project details in the same report.

I am trying to create a report where in i am fetching records from database and in report we are using grouping to group particulars records.

After the records are grouped, i want to show the records in dual tabular form instead of a single table on every page. 

I have added an image format for exact output that is required.

Please help.

We have a report which is grouped and showing the information as needed, only the problem is page header is having a field (Customerid) to show the value on top of every page, all information is showing correctly on all pages except that first customer id is displayed on every page ,which means the customer id is repeating not changing.fyi, this report also has a group added to segment the related data of customer.

Thanks & Regards,
Babita

Telerik has been a great tool for me for a long time now, but I am struggling with a growing problem my customers are bringing to me. I'm not looking for a fix to a bug, more like advice or suggestions on how the tool can help me.

So, my customers like the reports I create but need two things: 1) More columns and 2) the ability to export to Excel, CSV or something so they can massage the data how they would like.

An example - I have a Product Utilization report that is very full that currently contains 9 columns, is in landscape format and includes lengthy columns like Description (which already wraps) and Manufacturer Name. They want to add 5 more columns. I can move columns to another row, but I think that looks messy. And more importantly, when you export this to Excel the data is not kept on one row for the customer to massage.

How do you guys handle this? What clever ideas have you come up with to address this.

Exporting is also causing a little grief - Excel seems to work OK but numeric columns are exported as strings so my customers can't easily sum columns, etc. CSV would work better, but it captures all kinds of crazy characters, shows summation fields as giant text strings of the column values instead of the actual calculation results. I'm toying with the idea of writing some additional code and tying the dataset to a grid and exporting the raw data myself, but I was really hoping I could avoid that. If I did go that route is there a way to override the export button so it will run my code instead of Telerik's code?

Thanks for the advice and suggestions!

I've had a lot of need recently to use checkboxes on my reports. I've been using an example that I found on the forum where I actually place a picturebox where I want the checkbox, then load an image that is checked or unchecked depending on some logic in the databinding event handler for the detail section of the report. That works just fine for a few checkboxes, but I have several reports with 50-60 checkboxes each and it creates a lot of very cumbersome code.

Is it possible to create a custom control, inherited perhaps from picturebox, that I could then place on a telerik report? I would want to just add the logic to it to show the checked or unchecked image based on a Field it is bound to (boolean).