Telerik Forums
Reporting Forum
0 answers
105 views
Hey guys,
  
I am working on a .NET 4 Windows Forms application. The application reads data from a VistaDB 4.1 database located in the installation directory, and display a report using Telerik Reporting. The data is phone usage statistics for different people. The db therefore contains a Client table identifying the people in the system and Statistics table, with a foreign key of the client ID and containing the usage statistics for the user.
  
I want to display a listbox on the report allowing the user to select a client from the Client table. Then, the report should only view the data that pertains to this selected client from the Statistics table. The user should be able to keep switching between clients to get a different report.  
  
I know about report parameters, but how exactly do I use them to achieve this goal while working with VistadB? I am working with a manual connection to Vista and NOT a dataset (using the VistaDBConnection object).  
  
Thank you!
John
Top achievements
Rank 1
 asked on 16 Jan 2012
2 answers
173 views
I have an application that uses Silverlight for it's UI front end.
RIA Services (with Entity Framwork) is used for fetching and changing the Entities to POCO objects.

I have 4 projects (Not the actual names of the projects, but suffixes are correct):
Application (Main SL application)
Application.Web (startup Web project)
Domain (SL Class library)
Domain.Web (Main RIA service project with all the services and EntityModels)

There is a RIAService Link between Domain and Domain.Web.
There is a reference to Domain.Web from Application.Web.
There is a reference to Application.Domain from Application.

I am now adding a new ClassLibrary project "ReportLibrary" to house all the reports. I want to use the POCO objects returned by my methods in the services as the source of the reports, but I'm having trouble making the connections needed.
This application is to be deployed to many clients, so the connection string is being stored in the web.config of Application.Web.

My question is:
How do I set up the ReportLibrary project to work with the RIA Service structure I have?

I have looked at this blog Using Telerik Reporting with RIA Services but I don't seem to be able to replicate it. It doesn't really have the same Solution structure.
I tried adding a reference to Domain.Web in ReportLibrary, but when I test the report, it gives the following error:
"The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider..."
I also tried adding the EntityFramework connection that I used on the web.config in Application.Web, but it did not fix it.

Thanks,
Elian
Telerik team
 answered on 16 Jan 2012
3 answers
182 views
I have a table which is bound to a dataset using the NeedDataSource event.  Within the table layout I have a SubReport which requires a value to be passed to it (SignItemId) which is taken from the data.

I have worked through all the binding events for the table and for the SubReport but try as I might I am unable to find a way to pass this value to the SubReport.

This is what I am trying at the moment in the SubReport ItemDataBinding event.  It dosent matter where I place the code the DataObject is always returned as nothing.
Dim subReport As Telerik.Reporting.Processing.SubReport = TryCast(sender, Telerik.Reporting.Processing.SubReport)
 
        Dim processingTable As Telerik.Reporting.Processing.Table = TryCast(subReport.Parent, Telerik.Reporting.Processing.Table)
 
        Dim dataRow As System.Data.DataRowView = TryCast(processingTable.DataObject, System.Data.DataRowView)
        If dataRow IsNot Nothing Then
            MastDetails1.SignId = CInt((dataRow("SignItemId")))
        End If
Elian
Telerik team
 answered on 16 Jan 2012
2 answers
187 views
I have a current report that works fine when using a single parameter. I attempted to change the gunnumber parameter to multivalue, but can not get the selections to work I changed the = to In, but the dropdown checkbox will not accept the selection.

I have attached pictures of the my parameter and filter. Can someone tell me how to properly convert this to a Multivalue parameter?
Elian
Telerik team
 answered on 16 Jan 2012
1 answer
86 views

Hi,

I am using Telerik Reports Q2 2011 with Silverlight 4. I added an empty chart in a report without specifying a DataSource and with Default Type “Pie”. I assigned a Chart Series to this chart in NeedDataSource Event. In this way, chart successfully created and loaded in silverlight report viewer. But, whenever I try to export that report in any format I get an empty chart in the resulting file with the message “There is no or empty series”. Please, suggest a possible solution for this.

Thanks!

Adil

Steve
Telerik team
 answered on 16 Jan 2012
0 answers
83 views
hi,

i have a parameter its name is namesurname.its datasource is employees which

select command text is ="SELECT DISTINCT EMPID, NAME + ' ' + SURNAME AS NAMESURNAME, BRANCHID
FROM            EMPLOYEES
WHERE        (BRANCHID = @BRANCHID)"

its display text and value is both NAMESURNAME

how can i assign branchid(Guid) value from session while on pageload?
Teoman
Top achievements
Rank 1
 asked on 15 Jan 2012
1 answer
151 views
hi,

i have a parameter which filters product name  and its multi value property is true.when i select only one product from parameter it works.but when i select multiple value or select all it gives incorrect syntax near ','.Can you help me please?
Teoman
Top achievements
Rank 1
 answered on 15 Jan 2012
4 answers
368 views
I have assigned a business object to a report's datasource, select a data source member (a method returning the object), and configure the data source parameter,  but when I go into the data explorer I don't see it. What do I need to do to make this happen?
Thanks.
Ron
Lane
Top achievements
Rank 1
 answered on 13 Jan 2012
3 answers
182 views
We are using WPF Telerik Reporting to print onto pre-printed forms that our customers use to submit to government agencies. For the vast majority of our users this works just fine, but some are having print alignment issues where the report doesn't align well enough to the pre-printed form and their submissions are being rejected. We thought we might be able to nudge the report printing a little in either a horizontal or vertical direction to account for this, but haven't found a great solution to this.

So far we have only looked at setting the print margins, but if we do that then the report print engine will realize the report no longer fully fits on a page and then will print overflow pages. What is the best way to tell the report engine at runtime to just nudge its content over by a small amount and still prevent overflow onto extra pages?

Btw, we tried making custom paper sizes with custom margins, but then that still prints extra pages.
Steve
Telerik team
 answered on 13 Jan 2012
15 answers
1.1K+ views
Hello,

I've created a library of reports as described in the documentation.
When building the report library, I've used a certain connection string for each report. However at runtime, the report connectionstring needs changing to reflect the current environment settings.
Searching through the documentation, I couldn't find such an example.

Your help is needed.

Regards,
T.
Steve
Telerik team
 answered on 13 Jan 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?