Telerik Forums
Reporting Forum
0 answers
181 views
Hi,
Sorry if this is a newbie question, but I need to change the database schema depending on the customer login.
We have a multi tenant Saas application and I want to use a standard set of reports for all customers.  We are using a single database separate schema database approach.
Specifically I need to know if or how I can change the schema for each report depending on the customer.
Thanks for your help on this,
Andy
andy
Top achievements
Rank 1
 asked on 10 Mar 2012
1 answer
201 views
HI,

I'm attempting to create a report for a silverlight client using the Silvleright Reporting Service proxy class, in particular the RenderAsync method which takes a NameValueDictionary as the report parameters. My problem is that when I add a parameter in with the key "reference", and call the method for a particular report (which resides in the WCF application housing the Reporting Sevice, the passed parameter does not populate the corresponding parameter value in the report.

If the parameters created in the report are not meant ot be automatically popualted using this method, how can I retrieve the passed in parameters? I have a breakpoint in the constructor of the reporty I am trying to generate and I want to call a method to populate an object DataSource using the passed in parameter.

Kind Regards

Ben
Peter
Telerik team
 answered on 09 Mar 2012
1 answer
350 views
Our reports use the non-standard font "Helvetica Condensed" and on our development environment (Windows 7) generated PDFs have the font embedded as "HelveticaCondensed" and display correctly, I can also copy-paste from the PDF to Word and the font is maintained.

On our server (Windows Server 2008), the font IS installed and generated PDFs have the font embedded in the same way, but viewing the PDF the font is actually Arial. Also copy-paste from the PDF to Word, the font name is "HelveticaCondensed" (without any space) and shows as Arial.

The corporate policy dictates use of this font so it is very important that the PDF renders correctly.

Also, is there a way to get a custom font like this to display in the Silverlight ReportViewer on users machines that do not have the font installed?

We are using Telerik Reporting Q3 2011

Thank you.
Elian
Telerik team
 answered on 09 Mar 2012
3 answers
187 views
Hello,

I am tryng to develop a tag report, at design time i see 3 columns of labels connected to database; the first one column to design the template of label and columns 2 and 3 as well.

Whe i switch to preview just one column were rendered, and in the interactive mode three columns are there.

But in none of the cases the three column prints, just one.

Any ideas?

Thanks

Gilberto


Steve
Telerik team
 answered on 09 Mar 2012
8 answers
212 views
Hi,

I´ve updated the telerik DLLs for Silverlight RadControls and Reporting.
Opening a Report results now in a XamlPaseException telling me that the Type "TextBoxEx" is missing.
So whats wrong here?
Steve
Telerik team
 answered on 09 Mar 2012
6 answers
356 views
I have a parameter with Multivalues. I would like the parameter do default to Select all and have therefore implemented a AllValue function (as shown in another post in this forum) to set the Value property. This works very well as log as the value only has unique values. Example:

SELECT

 

fullname FROM employee


value=AllValues(fields.fullname)

This works wothout problem.But if I get the value from a table that contains the same value more than once I got problem. Example:

SELECT

 

activity.startdate,employee.fullname FROM activity INNER JOIN employee ON activity.employeesignature=employee.signature
value=AllValues(fields.fullname)

The result of this is that the parameter is shown with the unique values and all values is selected. But, if i deselect all, only some items is deselected. And if I click on the others they could not be deselected at all.
The problem occurs to be that the second example could result in several rows with the same value in employee.fullname. OPnly the rows that have only one row with the same value is handled correctly.

So, how can I solve this problem?

R
Torbjörn 

Steve
Telerik team
 answered on 09 Mar 2012
1 answer
93 views
I am creating a set of reports, each with 1-2 charts.  How do I set the title at run time using the reportviewer?

Sample of my aspx code:

 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Dim report As New MyReports.RevByOffice
            ReportViewer1.Report = report
        End If
End Sub

I am using Reporting Q3 2011.  Once I have all the reports designed, then I will put all the reports into a ReportBook.
Steve
Telerik team
 answered on 09 Mar 2012
2 answers
165 views
I have created a reportbook which shows sales information at the highest level of a client. If a client-structure contains several departments, a sales report for each department is created, and will be added to the reportbook.

The structure of a client is stored outside telerik, in an AD-database. The parameters are passed to the report in the code-behind (department is item in a list of departments items):

foreach (var item in items)
{
    RptAnalyseOmzetTotaal rptAnalyseOmzetTotaal = new RptAnalyseOmzetTotaal();
    rptAnalyseOmzetTotaal.ReportParameters["customer"].Value = item.TrimStart('0');
    rptAnalyseOmzetTotaal.ReportParameters["year"].Value = year;
    rptAnalyseOmzetTotaal.ReportParameters["periodFrom"].Value = periodFrom;
    rptAnalyseOmzetTotaal.ReportParameters["periodTo"].Value = periodTo;
    reportBook.Reports.Add(rptAnalyseOmzetTotaal);
}

The problem is if a department doesn't have sales for the asked period, an empty report is added to the reportbook.
I need to do a check if a department contains data. Does the report-class rptAnalyseOmzetTotaal have a method to check if it contains data for the given parameters?

I'm using Reporting Q1 2012 in a Umbraco Portal.
Peter
Top achievements
Rank 1
 answered on 09 Mar 2012
1 answer
262 views
I can't find this anywhere.  Your help is appreciated.

I want to change the font and color of the series item label in my chart.  The properties all seem to be exposed as I have changed every font in the chart so far except this label.

I have tried it several different ways in the code behind as well with no luck.

I can go in and set it via properties, series collection, items but that does not display in the report (just the VS preview).  I am databinding in the code behind in new:    Chart1.DataSource = _ds.Tables(0) 

Suggestions greatly appreciated.

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound
    Chart1.Series(1).Appearance.TextAppearance.TextProperties.Color = Color.Red
 
    Dim myseries As ChartSeries
    Dim myitem As ChartSeriesItem
 
    For Each myseries In Chart1.Series
        myseries.Appearance.TextAppearance.TextProperties.Color = Color.Red
 
        For Each myitem In myseries.Items
            myitem.Label.TextBlock.Appearance.TextProperties.Color = Color.Red
            myitem.Label.TextBlock.Text = "xxxx"
        Next
    Next
 
 
End Sub
Steve
Telerik team
 answered on 09 Mar 2012
2 answers
147 views
Hey All

Today is my first day trying this reporting product and as usual , I have spent allot of time scratching my head. I'm used to that and it's part of taking on new projects and learning. ( and being self employed and having to take on new things all the time!!)
I have been looking at Demo's, reading forums and watching videos most of the day! ( along with trying things)

I normally just bash my way through things till I get it working, but since we have this great resource I thought I would try for some advice please. It should save me going down a path that wont work!. 

The requirement is a report on employers performance. The user will select the month  and the team.

The report layout is multiple page, with a page for each team member.

Report Header: Report for Team Member X

Dates           performance data 1,performance data 2 ,performance data 3  ,total for PD , total@work
01/01/2012      A                                B                                   C                          A+B+C+D          E
01/02/2012      A                                C                                   C                          A+B+C+D          E
  etc ...

Report Footer:
                     Total A                        Total B                        Total C         Total (A+B+C+D)  ,Total E    

               % totals A / E                 % totals B / E            % totals C / E           % totals ALL / E 

I have tried the only 2 report wizards ( table and crosstab) and neither can do the grouping by page, so I asume I need to use the footer for the percentage calculations..

My assumption is that I need to create a parameterised report for the above that is passed the month and the team member ID. Then use a Report Book and dynamically add the report for each team member , passing the month and member ID 

Is that the right approach or is there some way to group into pages that I cannot see?

I'm using 2012 Q1 release

Cheer guys!
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
 answered on 08 Mar 2012
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?