Telerik Forums
Reporting Forum
1 answer
304 views

Hi,

I have a table where I’d like to selectively hide one or multiple columns based on a report parameter.

To do this I’ve created a column group in the table and have added a filter to it.  For the parameter I am building a short CSV list of the names of the columns that should be in the table so for example parameterA may equal “columnA, columnC, columnE, columnD”

In the filter I’ve used syntax to say:

Fields.columnA = If parameter like ‘%columnA%’ then Fields.columnA else null

AND

Fields.columnC = If parameter like ‘%columnC%’ then Fields.columnC else null

This approach works fine for the first column, but even if I change the report parameter applicably it’s always the first column that gets supressed and not any of the others.

Anyone got any ideas on it, or been able to suppress various multiple columns dynamically with a different approach?

Many thanks,
Steve

Simon Keeton
Top achievements
Rank 1
 answered on 15 Nov 2012
1 answer
88 views
I have a table of data in a report with columns that have a 1px (repeat-y) image to produce a sort of gradient on each column.  The table looks great in HTML but when converted to PDF, the gradient seems to override the table's 1px borders and things start looking funky (no border).

Attached is an HTML sample and the converted PDF.  The PDF is a screenshot at 100%.  

Can you think of any setting that would resolve this?

Hadib Ahmabi
Top achievements
Rank 1
 answered on 15 Nov 2012
6 answers
236 views
Hello

I have created a WPF report service in my web services solution but I cannot find anyway of connecting my WPF client using the ReportViewer to this service. The Silverlight equivalent has a ReportServiceUri property which I have used to test out my web services. Why doesn't the WPF control have the same properties? Is this something that is being added?

This is a bit of a show stopper for us as all our application is written in WPF. Is there an alternative method?

Would really appreciate any help you can give.
Regards
Steve
Arne
Top achievements
Rank 1
 answered on 14 Nov 2012
7 answers
731 views
I created a Telerik Report using the EntityDiagram ORM model to pull information from a Sql Server table.  I added a Telerik Report Viewer to my webpage, Default.aspx, and when I run it I get this error:

Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'voa_keygen'.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
   at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
   at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
   at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)
Ivailo
Telerik team
 answered on 14 Nov 2012
1 answer
94 views
dear support team,

is it possible to show/hide items from the report when exporting to excel (or powerpoint)? when exporting I need to show an extra information block of the report, is something like this possible?

kind regards
Squall
Top achievements
Rank 1
 answered on 14 Nov 2012
5 answers
906 views
I know that when you export to CSV, the Column Headers are just the "Names" of the text box.  I want to have descriptive Column Headers, but since the name is can't have spaces, special characters, etc., I'm pretty limited. 

I'm wondering if there is any other way of specifing Column Headings that would allow me more flexibility? 

It would be great if you could add a property to TextBox that is the text to use for that TextBox's Column Header if it is exported to CSV.  I know that might be a lot to go through for just one Export Format and for just one improvement, but I can't think of any other way to have good Column Headers that aren't tied to the name of the textbox in code.

Any help would be appreciated.

Thanks,
-Stephen
Steve
Telerik team
 answered on 14 Nov 2012
3 answers
128 views
I have embedded the asp.net web viewer into my application and am finding that the chart control does not render correctly in either IE9 (compatibility on or off) or Chrome.
I have attached several images to this issue:
1. VS Preview.jpg - Shows the chart rendering correctly in Visual Studio 2010 Preview.
2. VS WebPreview.jpg - Shows the chart rendering correctly in Visual Studio 2010 Web Preview.
3. IE Web Preview.jpg - Shows the chart not rendering correctly in IE9 with compatibility mode off.
4. IE Web Preview CM.jpg - Shows the chart not rendering correctly in IE9 with compatibility mode on.

I have tried all kinds of things such as AutoLayout, Margins etc and none of these make any difference. The chart always renders incorrectly in the browser.
Can somebody help me with this as this issue essentially makes telerik reports unusable for my customers at the moment.

Many thanks

Steve
Telerik team
 answered on 14 Nov 2012
2 answers
67 views
Hi..
How do I create a marked zone that is a polygon?
I can only seem to create squares or rectangles ?

Need to create a marked zone based on 10 points.

thx in advance
Igor
Top achievements
Rank 1
 answered on 13 Nov 2012
1 answer
76 views
We're having quite a few problems with the Telerik reporting tools. Perhaps these issues are all just something we're doing wrong (and frankly we'd be happy if they were), but we're starting to believe that it's really a series of bugs in the product. This one we refer to internally as "Are We There Yet?".

Are We There Yet?
The Incredible Shrinking WPF ReportViewer is certainly a problem, but what led us to it in the first place is that there doesn't seem to be a way to host the ReportViewer in a RadWindow and accomplish the following:

  1. Position the window in the center of the owner (or even center screen) AFTER the report is actually rendered
  2. Ensure that the window is smaller than the screen resolution AFTER the report is actually rendered so that users can do things like click on the "Close" button

If we could set the ZoomMode to FullPage and then programmatically size and position the host window AFTER the report was rendered then we might be okay, but we can't find an event or other reliable way to know precisely when the ReportViewer is finished rendering so we're kind of stuck. Are we missing an event? How else can we generate the report and make sure the user can actually interact with it?

Greg
IvanY
Telerik team
 answered on 13 Nov 2012
1 answer
95 views
We're having quite a few problems with the Telerik reporting tools. Perhaps these issues are all just something we're doing wrong (and frankly we'd be happy if they were), but we're starting to believe that it's really a series of bugs in the product. This one we refer to internally as "The Incredible Shrinking WPF Report Viewer".

The Incredible Shrinking WPF Report Viewer
In our product, we host the Telerik WPF Report Viewer in a custom WPF user control (a Telerik RadWindow actually) and expose a ShowReportViewer method. What we would like to do is to activate (show) our control with the child Report Viewer and adjust the window size and placement so that the report is always clearly visible and, ideally, centered on the owner window.

Nothing exotic, right?

/// <summary>
/// Shows the report viewer.
/// </summary>
/// <param name="modal">if set to <c>true</c> [modal].</param>
public void ShowReportViewer(bool modal = false)
{
    this.WindowStartupLocation = WindowStartupLocation.CenterScreen;
    this.TelerikReportViewer.ViewMode = ViewMode.PrintPreview;
  
    //// Uncommenting this line results in the problem...
    ////this.TelerikReportViewer.ZoomMode = ZoomMode.FullPage;
  
    this.ShowWindow(modal);
    this.window = ParentOfTypeExtensions.ParentOfType<Window>(this);
    this.window.Topmost = true;
    this.window.ShowInTaskbar = true;
    this.window.Activate();
}

If we uncomment that ZoomMode line, our window will open then the ReportViewer will then immediately begin shrinking the report down to 0% one step at a time and continue to do so which means the user has to force close the app. It behaves the same as it someone were to open the window then immediately began clicking the zoom decrease arrow as fast as they could. Note that the zoom percent always starts at 13% (we have no idea why) and the behavior is the same no matter if we set the ZoomMode property value in XAML or in the code-behind.

Greg
IvanY
Telerik team
 answered on 13 Nov 2012
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?