Telerik Forums
Reporting Forum
2 answers
113 views
Hi

I'm attempting to position my labels for marked zones outside the PlotArea, but I can't see how to do it. Basically my problem is the labels get obscured by the first bar and as they get printed behind the bar I can't see them (if the bar is smaller I can see the labels - however, the first bar always has to be the largest so I'll never see the labels!)

Can I position the labels outside the PlotArea? Alternatively, is there a way to increase the padding between the edge of the PlotArea and the first bar in order for me to see the labels?

Thanks
Rob
Rob
Top achievements
Rank 1
 answered on 18 Nov 2009
2 answers
212 views
Hi,

I just created a few simple reports, used the query builder (data preview shows some records, so data config is ok), specified groups, items etc. When i press preview or just show report on website, it shows no data. I followed a tutorial from learning guide.
Please help, i need to show a report it to customer tomorrow..

Sample solution (using AdventureWorks database)- http://vitexner.eu/testpp.zip

Best regards

Vit Exner
Exi
Top achievements
Rank 2
 answered on 17 Nov 2009
3 answers
681 views

For my application I need to build report parameters programmatically.  I have tried to follow the examples available but I cannot get the parameters to display as a dropdown list of values.  The parameter does show up in the viewer but as a textbox.  Below is the code that I am using to build my parameter -  

 

 

Dim vals As New ArrayList   
 <fill vals with strings of option values> 
 
Dim param As New ReportParameter   
param.Type = ReportParameterType.String  
param.UI.Visible = True   
param.UI.MultiValue = True   
param.Value = vals   
   
Me.ReportParameters.Add(param)  
 
 

This is wrapped in a routine that is called when the report is bound to it's data source.  When I try to call the routine from the report's constructor it results in a run-time error.

My questions are:
1. How do I get my options to show up as a dropdown list?
2. When should this routine be called? 
3. Is it possible to build it with a value/key pair rather than just a list of values? 

----------------------------------------------------------------------------------------------------------------
Upon further investigation, either programmatic definition of parameters is not supported or the documentation is severely lacking because I have tried every example (there are just a few) that I can find and it either results in no parameter or a run-time error.  For example, just trying to add a simple test parameter with the following code results in no parameter in the viewer:

    Public Sub New()  
        InitializeComponent()  
        ReportParameters.Add("Test", ReportParameterType.String"test")  
    End Sub 

Thanks,
Dave

 

 

 

 

 

 

 

Kristy
Top achievements
Rank 1
 answered on 17 Nov 2009
1 answer
201 views
Hi,

I have a table in wich the datasource is loaded in the NeedDataSource event.  It's using a Stored Procedure wich requires as parameter a value that is available in the main report.  How do I access this value ?

I want to either get the value of textbox txtIndividualId or the field IndividualId from the Reports datasource...

Thanks

private void MyTable_NeedDataSource(object sender, EventArgs e)  
{  
    SqlCommand sqlSelectCommand = new SqlCommand  
                                      {  
                                            CommandText = "SP_MyStoredProc",  
                                            Connection = new SqlConnection {ConnectionString = ConnectionString},  
                                            CommandType = CommandType.StoredProcedure  
                                      };  
    sqlSelectCommand.Parameters.Add("@individualId", SqlDbType.Int);  
    sqlSelectCommand.Parameters["@individualId"].Value = txtIndividualId.Value; //This is incorrect  
      
    Telerik.Reporting.Processing.Table tbl = (Telerik.Reporting.Processing.Table)sender;  
    tbl.DataSource = new SqlDataAdapter { SelectCommand = sqlSelectCommand };  
}  
 
Steve
Telerik team
 answered on 17 Nov 2009
1 answer
132 views
I'm having an issue when exporting a report to pdf. The Pie chart mirrors itself. Any ideas?
Steve
Telerik team
 answered on 17 Nov 2009
1 answer
130 views
Hi,

My question is does Telerik Report can use LINQ like integrated Datasource ?

Z. Rusev
Steve
Telerik team
 answered on 16 Nov 2009
0 answers
116 views

Hi,
 I want to print the telerik report from command line instead of using the
Print icon provided on Reportviewer toolbar. Please let me know if it is possible to
print telerik report from command line.

Thank you,
Anita.

anita T
Top achievements
Rank 1
 asked on 16 Nov 2009
4 answers
179 views
Hi,

I'm trying to make subreports visible programmatically with a parameter in the _NeedDataSource event.  This is the code I am using:

            foreach (string filterRow in showHide) 
            { 
                switch(filterRow) 
                { 
                    case "10": 
                        this.textBoxEventTotals.Visible = true
                        this.subReportCommunityEventTotals.Visible = true
                        this.subReportCommunityEventTotals.Report.Visible = true
                        break; 
                    case "20": 
                        this.textBoxEventTotalsByDate.Visible = true
                        this.subReportCommunityEventTotalsByDate.Visible = true
                        this.subReportCommunityEventTotalsByDate.Report.Visible = true
                        break; 
                    case "30": 
                        this.textBoxTotalsByCommunity.Visible = true
                        this.subReportCommunityEventTotalsByCommunity.Visible = true
                        this.subReportCommunityEventTotalsByCommunity.Report.Visible = true
                        break; 
                    case "40": 
                        this.textBoxCommunityAndDate.Visible = true
                        this.subReportCommunityEventsByCommunityAndDate.Visible = true
                        this.subReportCommunityEventsByCommunityAndDate.Report.Visible = true
                        break; 
                    case "50": 
                        this.textBoxDetails.Visible = true
                        this.subReportCommunityEventDetails.Visible = true
                        this.subReportCommunityEventDetails.Report.Visible = true
                        break; 
                } 
            } 
        } 
 

The visibility of everything is set to false.  I don't seem to be able to get to the inner report of my subreport controls. Changing the visiblity of the subreport controls and text boxes works fine.  What am I doing wrong?

I know it sounds a little strange but in the subreport I was going to bail out of getting the data if the subreport wasn't visible.  That's why I want to make the subreport invisible not just the subreport control....

Thanks,
Darren
Darren
Top achievements
Rank 1
 answered on 16 Nov 2009
0 answers
108 views
Hi,
I'm using version 2009 Q3 to create a report and render it as a PDF file.
The report has a table on it. Below that table is a sub report.
In the designer the sub report is straight below the table, but in run time the sub report starts on a new page.
I've set Keep together to false on both the sub report and on the table. I also set page breaks to None, but still this happens.
Is there a way to get the sub report on the same page the table is?
Naphtali
Naphtali
Top achievements
Rank 1
 asked on 16 Nov 2009
1 answer
1.0K+ views
Hello,

Please could somebody point me in the direction of sample code for this? I want my users to be able to select a command link or button from an asp.net page which will download a report straight to PDF.

Many thanks, Carl
Steve
Telerik team
 answered on 16 Nov 2009
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?