Telerik Forums
Reporting Forum
3 answers
523 views

Hello!
I'm currently upgrading Telerik reporting in my application from version 5.1.11.928 to version 8.2.14.1204. I am using Visual Studio 2010, using C#.

 

I'm encountering a problem with a report parameter using a sqlDataSource. At first, I was encountering a problem because an arraylist was being used in a parameter (as an ansistring). This caused an error with XML serialization. So I realized that an arraylist wouldn't work anymore. However, the query its using is relying on accepting a collection of values.
    (e.g. (Where number.ID IN (@ValueType) )

 

I saw that I can change the parameter to accept multiple values from:
    http://www.telerik.com/help/reporting/designing-reports-parameters.html

 

However, I can't seem to get it to work correctly. For some extra context I have also changed the collection to a hashset<int>.
The report parameters are being set with code that uses the reportviewer.
Example:
var genericReport = new GenericReport();
genericReport.ReportParameters["ValueType"].Value = hashValueGenerator("Selector");
//hashValueGenerator returns a hashset of integers based upon its selector
//This used to be an arrayListGenerator

From there, the code would then take the report that was generated and add it to the reportSource. (This part works fine.)
I believe I am setting up my value type incorrectly to accept the new collection I'm creating.

 Here is the parameter as it existed before the upgrade:
    Name: @ValueType
    DbType: AnsiString
    Value: =Parameters.ValueType.Value

 

This is my attempted fix to my problem:
    Name: @ValueType
    DbType: Int32
    Value: //Shown below as created in the Report Parameter Editor
    //Only the bolded (non-default) changes are being displayed
    //Organized to look like pseudocode, but I am using the editor
    //Quotes are for readability, they are not used in the actual editor boxes
Report Parameter{
AvailableValues {
    DataSource = sqlDataSource,
    //The same as shown as the data source on the report designer.
    ValueMember= "=Parameters.ValueType.Value"}
MultiValue= true,
Name= ValueType,
Text= ValueType,
Type= Integer,
Visible= true
}

I get the following error in my Report Viewer: "Missing or invalid parameter value. Please input valid data for all parameters."
Can anyone give me any insight as to what I'm doing wrong?

Thank you very much!

Stef
Telerik team
 answered on 10 Jun 2015
1 answer
376 views

I have a report which I view via a ReportViewer on a web page.  In the viewer, I can choose to export to CVS.  In the resulting CVS file, the headers do not show the names of the header textboxes like I want them to.  Instead, they show the default names that were given to the textboxs when the report was created.

 For instance, initially a header textbox was named "prodOrderDataTextBox" automatically.  In the properties of the textbox, I renamed it to "ProdOrder" and it is this name that I want to appear in the CVS file.

 How can I change this?

Nasko
Telerik team
 answered on 10 Jun 2015
8 answers
373 views
Hi Everyone,
I need help on Telerik Report Error after publishing to my local web server

I have a web application and running this on local machine is perfectly fine.
XAML is 
<my:ReportViewer  x:Name="ReportViewer1" Width="1000"
              ReportServiceUri="../ReportService.svc"
              Report="ReportsLib.Report1,ReportsLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">
</my:ReportViewer>

Fiddler says after report is showing .

#   Result  Protocol    Host    URL Body    Caching Content-Type    Process Comments    Custom 
162 500 HTTPS    localhost:1807  /ReportService.svc  834 private     text/xml; charset=utf-8 iexplore:5752          
163 500 HTTPS    localhost:1807  /ReportService.svc  1,116   private     text/xml; charset=utf-8 iexplore:5752          
164 500 HTTPS    localhost:1807  /ReportService.svc  1,332   private     text/xml; charset=utf-8 iexplore:5752          
165 200 HTTP    localhost:1807  /ReportService.svc/resources/getrenderstream?instanceID=c07b6ca8-bd44-48cd-8e2f-56718e3e5283&name=5a214af8d59c4e86ad6b023d69ea4307  25,661  private     image/png   iexplore:5752          


Now, after publishing this to my local web server;

Web site= https://unowos/demo
root folder on local web server is C:\WOS\WOSDEMO

this is my XAML
<my:ReportViewer  x:Name="ReportViewer1" Width="1000"
              ReportServiceUri="../ReportService.svc"
              Report="ReportsLib.Report1,ReportsLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">
</my:ReportViewer>

Error is after previewing the report.

Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
 
------------- InnerException: -------------
 
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_6.EndListRenderingExtensions(IAsyncResult )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndListRenderingExtensions(IAsyncResult result)
   at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
 
------------- InnerException: -------------
 
System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
 
------------- InnerException: -------------
 
System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
   at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)

Fiddler says : on redmark

#   Result  Protocol    Host    URL Body    Caching Content-Type    Process Comments    Custom 
262 500 HTTPS    unowos  /demo/ReportService.svc  
263 500 HTTPS    unowos  /demo/ReportService.svc  
264 500 HTTPS    unowos  /demo/ReportService.svc  


Notice something different here.
The same website was published on GoDaddy servers and i notice that the ReportService.svc whether running on local machine and Goddady server is only showing /ReportService.svc. And the report is showing the preview.

What am i missing ?....Is this on IIS Server ? or in my development.

Thanks in advance.
Robert



Stef
Telerik team
 answered on 09 Jun 2015
4 answers
486 views

I want to create a report with a specific layout based on a given model, but the dataset it will be based on will be dynamically created via the (application) UI.

I'd rather do this and supply a populated model to the report than to have a report will a gazillion parameters that are populated by the app and then have the report fetch the data all over again.

 Q: Can I do this?

Q: If I can can some one give me an example (Pretty Please)

Q: Can I do this using TRDX files?

Q: Can I do this using *.cs reports?

Q: Can I be really pushy and as for examples of both (Pretty Please with Sugar on).

Stef
Telerik team
 answered on 09 Jun 2015
1 answer
480 views

Hi All,

 I have a report where I use the toggle visibility action on a certain table group.  I have the group visibility set to 'false' so it is collapsed when I run the report.  I can click the '+' button and the details expand.

There is another function that I want on this report that I cannot figure out.  I also want the same detail section from above to be able to 'ShowAll' details based on a parameter.  The user can click true on this parameter which would override the toggle visibility action and show all details in the fully expanded form.

The reason for this is so that if a user wants to see all details, they don't have to go down the list and click every '+' to expand the collapsed sections.

I have attached a screenshot of a sample report where I need this functionality.

 Thanks,

Phillip

Nasko
Telerik team
 answered on 09 Jun 2015
3 answers
161 views

hi!

 I have managed to setup a self-hosted Reporting REST WebAPI server. Now I would like my WPF application to consume a report using that API. Is there a way i XAML to set the reportSource to the WebAPI?

<tr:ReportViewer Margin="10" Height="400" ZoomMode="PageWidth">
   <tr:ReportViewer.ReportSource>
      <trReporting:UriReportSource Uri="Reports\StatusReport.trdx"/>
    </tr:ReportViewer.ReportSource>
</tr:ReportViewer>

 

How can I let the server generate the report and pass it to my application? This would help a lot since I don't want the users of the application to have direct permissions on the database where the report fetches all the data.

All help is appreciated!

Stef
Telerik team
 answered on 09 Jun 2015
5 answers
230 views
What is the best way to not run a section or a subreport?  We have reports where the user can request different levels of detail, we are currently using a binding to make the section/subreport not visible.  While this works visually, it appears, based on timings and breakpoints that the nonvisible components are still being built.  Ideally we would like to completely turn these sections off to avoid the extra overhead.

Thanks

Chris
Nasko
Telerik team
 answered on 08 Jun 2015
2 answers
1.5K+ views

Hi,

 I have a report with 2 groups each with a header.  I want the headers to print on every page, but I cannot get this functionality to work. 

     - I have RowHeadersPrintOnEveryPage set to True.

     - The table header section that is present in the initial table was removed (started from bottom up and deleted the top row at the end).

     - I have expirimented with setting KeepTogether True and False and neither provide the desired result of headers on each page.

 Please help with this issue.  I do not want to have to remake all my reports.  I have attached a screen shot to portray the issue.

     - In the screen shot, I would want the black row 'JCAHO/DNV' and the blue row below it 'Goal Name' to be on the second page as well as any other page where          the group continues beyond one page.

 **This is a sample report with fake data**

Phil
Top achievements
Rank 1
 answered on 05 Jun 2015
1 answer
195 views

We have a web page in our application that displays an instance of the ReportViewer control.

We are displaying the standard Telerik parameter selection box to the user.  If the report we are displaying has data-driven multiselect parameters, we have noticed that, after the postback completes to load the parameter list, the parameters box goes blank.  Resizing the browser window makes the parameter box visible again.  This problem is only reproducible in Chrome.  No such problem occurs when displaying the same page in Firefox.

Is there any known issue with Chrome and parameter selection with the ReportViewer control.  I couldn't find anything in the forum.

 Thanks

 

Paul Marfleet

Nasko
Telerik team
 answered on 05 Jun 2015
3 answers
431 views
Hello Telerik,

We've managed to setup the HTML5 report viewer, it's passing parameters, reports are loading and returning data. I've attached 2 screenshots that show the network sources all load correctly and that the export menu is populated. Everything works except the Toolbar Buttons. Any idea what it might be?

Thanks,
Greg
Stef
Telerik team
 answered on 05 Jun 2015
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?