Questions on Reporting Forum

3 answers

219 views

Report refreshes do not reflect updated data from database

I am trying out Telerik Reporting component and currently have a problem that I hope to get some help with.

I have everything setup in my application and the report seems to work on first pass. After I make changes to my database via the application, e.g. My application assigns an asset to a person, none of my associated reports show the changes in the database. Other portions of my application do reflect the change indicating that the changes are successful, but my Telerik reports do not see the changes. The only I can get the reports to reflect the changes is by restarting my application. This obviously will not be an acceptable behavior.

I was hoping someone can help me with this.

Thanks in advance. Prompt responses are definitely appreciated.
KNana

General Discussions

answered on 04 Apr 2009

5 answers

174 views

Export shows Html Markup

Hi,
I've been trying the report tool (v1.1). My data was generated by the radeditor which has embedded html markup in it. When the report is generated it shows the data just fine. When I try to export the data to pdf or tiff, the html markup is shown literally. When I attempt to export to a web archive, the html markup is ok (as expected), except I have <img> tags that are not resolved (I get the red X). I have the HtmlRendering.dll, ImageRendering.dll and WebForms.dll in my bin directory of the app.

I'm I missing something required to have my markup rendered correctly including images?

Thanks,
Bruce

General Discussions

answered on 03 Apr 2009

2 answers

274 views

Q1-2009 Table control Questions

I have an existing web report that I want to convert to use the table control in order to get better column alignments and to fix some exporting issues. I've looked at the new demos, which all look to use the crosstab control, and not the table. My current report binds the datasource to the report of the reportviewer in an aspx page by using something like:

_report = ReportViewer1.Report

_report.DataSource = ds.Tables(0).DefaultView

The current report also uses groups to group hierarchial data. I would like to either convert this report, or create a newer report class for the above mentioned reasons. So I have some questions about the table control.
1) Initially, it looks like I have to bind a datasource to the table and not to the report anymore. Is that true and if so, how do I programmatically bind the datasource defined in my aspx page to the table in the report of the reportviewer?

2) Some column headings from the original report span multiple columns of the detail section. I would assume to get the same effect with the table control I could merge columns. However, I was unable to figure out how to merge adjacent cells in either the table header or detail. How is that accomplished?

3) When I added a row grouping to group by a field in my datasource, the designer appeared to bunch the grouping into a single column that spanned a couple of rows. I just have 2 layers of simple grouping I need to perform for the report, and I would expect for the group row to span the length of the table, but it doesn't. What is the proper way to add row groupings to the table control?

4) My current report has aggregate sums and calculations in the group headers of the different groupings. How do I associate those cells with the same grouping scope?

5) It appears that the demos use the crosstab and not the table control. I understand they are similar, but the crosstab has sections that I don't feel I need for this type of report. Is there an example of a table report that uses groupings that I could download and learn from?

An example layout of the report I am working is similar to this:
Segment 1 total1   total2 total3 total4
Division 1 total1   total2 total3 total4
      Plant 1 data1 data2 data3 data4
      Plant 2 data1 data2 data3 data4
Division 2 total1 total2 total3 total4
      Plant 2 data1 data2 data3 data4
      Plant 2 data1 data2 data3 data4
Any answers, help, or examples would be most appreciated.
-kenf-

General Discussions

answered on 03 Apr 2009

1 answer

92 views

Zoom dropdown mising when running Telerik Reporting tool in firefox browser

Hi all

I am facing a rather strange problem while using the Telerik Reporting tool.I have enabled the show zoomselect property to true in my code. When i view the report in Internet Explorer the zoom dropdown is visible as it should be but when i open the same report in a Firefox browser,Surprisingly the zoom dropdown is missing......

Has any 1 come across a problem like this......Please help/Suggest how to get arround this problem.

Thanks and regards
Rahul GCT

General Discussions

answered on 03 Apr 2009

4 answers

202 views

Creating reports outside vs.net?

Active Reports had a winform tool that people could use to build reports outside of VS.net. This would allow people other than developers to create reports. These reports could be saved in their xml format (.rpx I think), which could be loaded up at runtime, bound, ran, then exported as PDF, etc. Does Telerik plan to support this type of scenario in the future? If so, would there be a winform or wpf report designer app for this? I am not very familiar with Telerik Reporting so far, but did not find anything like this on your site or documentation.

General Discussions

answered on 03 Apr 2009

1 answer

71 views

After Q1 2009 Upgrade reports show as .vb files

After upgrading from Q3 2008 to Q1 2009, all my existing reports show up as regular .vb files. I can click on them and view the code-behind but I see no way to get to the designer. Underneath in VS 2008, I see .designer.vb files that seem to open the designer code with the textboxes and such.

If I create a new report, it shows up correctly. So I think the system is just identifying these incorrectly. Any help in changing these so I can design them?

General Discussions

answered on 03 Apr 2009

1 answer

230 views

Change image in picturebox when exporting to pdf

Hi,
I need to change the image when exporting to pdf because I want the image to be 300 dpi when printing and 72 when viewing on the webpage.
I have tried this with no success:

    
            private void pictureBox1_ItemDataBound(object sender, EventArgs e) 
        
                    { 
        
                        HttpContext context = System.Web.HttpContext.Current; 
        
                        System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Profit)); 
        
                        if (context != null) 
        
                            pictureBox1.Value = ((object)resources.GetObject("logo72dpi")); 
        
                        else 
        
                            pictureBox1.Value = ((object)resources.GetObject("logo300dpi")); 
        
                    }

The report is called Profit and the images is in projects resource file.
Can you help me?

/Mattias

General Discussions

answered on 02 Apr 2009

1 answer

96 views

Can not edit the content of a TextBox at the runtime

Hi,

I have a report that prints payment information of employees in a Department. All items are fetched in a DataTable and the is set as the DataSource of the report. So far, everything works OK.

But in the PageHeader section there are a few fields I would like to print according to the selection made. Like Department name, Selectino year and Selection Month. The thing is that I am not allowed to interfere with the DataTable to add relvant columns to call althese necessary information databound and relate it to the TextBox with "Fields.DepartmentName".

So I choose to use this code:

    
            txtDepartmentName.Value = GetDepartmentName(this.DeptID);

in the various method such as:

    
            private void MyReport_NeedDataSource(object sender, System.EventArgs e) 
        
            private void MyReport_ItemDataBound(object sender, System.EventArgs e) 
        
            private void pageHeader_ItemDataBound(object sender, System.EventArgs e)

but unfortunately, none of them worked. What am I doing wrong? Where should I make these assignments. Which method duits this situation fine?

Regards...

General Discussions

answered on 01 Apr 2009

1 answer

273 views

Object not defined in current context

Hi Guys, we working on some reports, going over them again, reading what would be better.

We started creating reports using the wizard, so we had designtime support. Great, that works. But now I want to add some more flexibilitty to the code. So I added a NeedDataSource event to the report including the next code:

    
             this.generalReportDataSetTableAdapter1.Connection.ConnectionString = ConfigurationManager.ConnectionStrings["Report.ConnectionString"].ConnectionString; 
        
                        this.generalReportDataSetTableAdapter1.FillByClientIdAndBetweenStartAndEndDate(this.generalReportDataSet.GeneralReportDataSetTable, 
        
                            Convert.ToInt32(this.ReportParameters["pClientId"].Value), Convert.ToDateTime(this.ReportParameters["pStartDate"].Value), Convert.ToDateTime(this.ReportParameters["pEndDate"].Value)); 
        
                        Processing.Report report = (Processing.Report)sender; 
        
                        Report.DataSource = this.generalReportDataSet;

of course in de constructor I set: this.DataSource = null;

Nou when I set breakpoints, I can see my DS is filled. No problem but all my textboxen throw: the expression contains object 'Name' that is not defined in the current context. Where name is different for every textbox.

The structure of the DS is still the same.

It seems I cannot get the fields in the DB anymore

How is that possible.

General Discussions

answered on 01 Apr 2009

1 answer

208 views

new data source lost fields

I created an elaborate report using a SQL view as a data source. I updated the view in SQL and tried unsuccessfully

1. To get the new fields include in the report by redoing the datasource in VS. (When I updated the data source and tried to run the report I get red boxes saying that I have null values. However, running the datasource and viewing the returned records shows that those fields are not null.)

2. Create a new report with the new data set. Then replacing the dataset in the first report with this new data set and tableAdapter. When I try this I get red boxes with "object not set ot an instance of an object." Additionally, when I try to edit my expressions I get no Fields listings at all. Is seems from this that the old report has not recognized the data returned in the new data source.

I suspect that there is very simple answer. But how do I up date the data the report is looking at when I update the view in SQL server?

Thanks,

Matthew

General Discussions

answered on 01 Apr 2009

	private void MyReport_NeedDataSource(object sender, System.EventArgs e)

	private void MyReport_ItemDataBound(object sender, System.EventArgs e)

	private void pageHeader_ItemDataBound(object sender, System.EventArgs e)