Telerik Forums
Reporting Forum
1 answer
73 views
i have upgraded my deployed server to Q3 and now all i get on the viewer is a display saying Submit Query Submit Query (see attached image)



any ideas
kevin



Steve
Telerik team
 answered on 09 Nov 2009
0 answers
58 views
Hello Sir
am new in the report. I have an application with master(Invoice Header) and details(invoice details). I tried with subreport as per your sample attachment(http://www.telerik.com/community/forums/reporting/telerik-reporting/master-and-subreport.aspx) given.(I could not saw the vidio becase its url showsing error). but the master report and detail working  fine in seperately.

    when i'm, merge the subreport to the master, the parameter cantaines null values in detail report. can u help me for this issues.

thanks in advance.
subbiee.
subbarayan
Top achievements
Rank 1
 asked on 09 Nov 2009
8 answers
322 views
Greetings,

I seem to be having a problem when using the web based Report Viewer when I set the report parameters at run time.


Here's a summary of the problem:

I have a report that is generating a data source in the NeedDataSource event. 
The data source is being generated using data from the ReportParameters collection.

I have an aspx page that has a viewer control that is not bound to a report at design time.
My report page has a series of input controls that can be used to change the report parameters. 
After the user enters his report parameters and clicks the submit button, the code behind creates a new report object, assigns the parameters and then assigns the report to the viewer control.

This works fine the first time the user generates the report.  If the user changes his parameters and regenerates the report, the report is always generated using the first set of parameters. 

Here is some of the sample code:

GenerateReport(p1,p2) is called when the user clicks a "submit" button.  I've simplified the parameters for ease of reading. 
ToplineMaster and VerbatimMaster are the report objects.  Based on the input from the user, we determine which report to show (but this only happens on the first load of the page, the user does not change report types on the fly)
private void GenerateReport(List<int> p1, List<int> p2)  
{  
  if(Mode == 1)  
  {  
    ToplineMaster report = new ToplineMaster();  
    report.ReportParameters["p1"].Value = p1;  
    report.ReportParameters["p2"].Value = p2;  
              
    rv_Rpt_Viewer.Report = report;  
  }  
  else if (Mode == 2)  
  {  
    VerbatimMaster report = new VerbatimMaster();  
    report.ReportParameters["p1"].Value = p1;  
    report.ReportParameters["p2"].Value = p2;  
              
    rv_Rpt_Viewer.Report = report;
  }  

Both report types use a similar NeedDataSource method.  I changed it a bit to keep things simple, but basically I'm generating report line items based on data generated from my business logic layer and then binding those line items to the report.  The report works fine when I run it the first time.
private void ToplineMaster_NeedDataSource(object sender, EventArgs e)     
        {     
            // given the question ids, load the questions from the database     
            // and bind the list to the report     
            List<int> p1 = new List<int>();     
            p1 = (List<int>)(sender as Telerik.Reporting.Processing.Report).Parameters["p1"];     
   
            List<int> p2 = new List<int>();     
            p2 = (List<int>)(sender as Telerik.Reporting.Processing.Report).Parameters["p2"];     
    
            List<BusinessDataObject> lineItems = new List<BusinessDataObject>();  
   
            foreach (int id in p1)     
            {    
                // generate data from business objects/database  
                lineItems.Add(Data);   
            }     
    
            (sender as Telerik.Reporting.Processing.Report).DataSource = lineItems;     
                 
    
        }    
 

I did some searching around today, but couldn't find the magic google/forum search query to find an explanation which leads me to believe that I'm doing something wrong.

Can anyone offer a hand?

Thanks!

Rick
Top achievements
Rank 2
 answered on 07 Nov 2009
1 answer
140 views
It seems to me like the support for Parametrized Queries is severely lacking.  If you choose to go the route of using an sqldataAdapter with parameters you can no longer use the table or cross-tab wizards and most of the report has to created by hand.

As far as I can see the performance difference between using a filter to select certain data over using a parameter in the sql query is minimal, but I am test on such a small scale I don't know if it will truly make a difference.

I need to know how the filters work.  I assume that the query pulls all of the data into the dataset and then the filter selects the needed data from that.  This seems very inefficient to me because we are pulling a large amount of data from the DB then grabbing the small chunk we need and throwing the rest away.  While a PQ will only pull the data you need from the DB, eliminating the need for a secondary filter.

Is this how it works, if so that just seems silly to me that there is such lacking support for PQ's in the designer.
Hrisi
Telerik team
 answered on 06 Nov 2009
1 answer
107 views
Hey

Is there any good example for building report dynamic. I can't find very much information about this. Only ifnormation i found was this: http://www.telerik.com/help/reporting/programmatic-control-of-reports.html

My problem is that the report would change depending on the data.

Here are some of mye problem:
- Add controls dynamic. I know i can add controls in design mode and look at the "code behind". But it looks like i need to place control with a absolute position. I need to use sections. I tried to use panels, but this is useless if i need to give the panel a absolute position, because the content length of every panel will be different.
- How can i control page break? I would like every new section to start on a new page.

Thanks

Steve
Telerik team
 answered on 05 Nov 2009
1 answer
117 views

 

Hi

I'm trying to fill a HTMLTextBox on a subreport programatically in order to change appearence depending on the data. I managed to get line breaks working by changing from BR to DIV tags, but I can't get the styles to work. Since I have a lot of subreports I really don't want to include FONT tags into the code and risk creating a maintenance nightmare. Is there a way to set styles programatically?

I've tried adding the HTML using a script that is called from the HTMLTextBox, such as
...
PositionLine = "<DIV Class='PositionCompany>'" & PositionLine & "</DIV>"
Return PositionLine

but this only gives me linebreaks, not the formatting. "'PositionCompany" is a style rule defined in the master report.

How do I call the CSS formatting? (By the way, I can't set it directly since I use several different style rules inside the same HTMLTextBoc depending on data.

Thanks in advance!

Re
Dennis

   Public Shared Function Position(ByVal Company As StringByVal City As StringByVal Country As StringByVal CompanyType As StringByVal Title As StringByVal DetailLong As StringByVal DetailShort As StringAs String 
 
        Dim PositionLine As String = Company.ToString  
 
        If City <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += ", " & City.ToString  
            Else 
                PositionLine = City.ToString  
            End If 
        End If 
        If Country <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += ", " & Country.ToString  
            Else 
                PositionLine = Country.ToString  
            End If 
        End If 
        If CompanyType <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += " (" & CompanyType.ToString & ")" 
            Else 
                PositionLine = CompanyType.ToString  
            End If 
        End If 
        If PositionLine <> "" Then 
            PositionLine = "<DIV Class='PositionCompany'>" & PositionLine & "</DIV>" 
        End If 
        If Title <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionTitle'>" & Title.ToString & "</DIV>" 
            End If 
        End If 
        If DetailShort <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionDetails'>" & DetailShort.ToString & "</DIV>" 
            End If 
        End If 
 
        If DetailLong <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionDetails'>" & DetailLong.ToString & "</DIV>" 
            End If 
        End If 
 
 
        Return PositionLine  
 
    End Function 
 
Steve
Telerik team
 answered on 05 Nov 2009
1 answer
114 views
Hello there!
           When i export my generated report to Web Archive format in IE7 all my datas are exported correctly How ever when i try to export it to Web Archive format in Mozilla3.5 format it is displaying binary datas. Is there any solution for this problem? I have attached images for your understanding.
Kindly help me ASAP...

Many thanks
Steve
Telerik team
 answered on 05 Nov 2009
0 answers
79 views
Our application allows a user to generate a Telerik report.  Sometimes when the report is generated, the application is not fully maximized.  When in fact the application does get fully maximized, the top of the report has fallen off the page and there is no way to close it.  The functionality we are aiming to achieve is to implement a context menu that can be accessed by a right click, so when this happens they can simply right click and close the report.  Any suggestions?
Lindsey Kelly
Top achievements
Rank 1
 asked on 04 Nov 2009
4 answers
246 views
I am looking for a way to make the size of the parameter window always large enough to show the parameter input controls. Currently I have some reports that work nicely and others that generate a scroll bar that must be used to see all the parameter input controls. I cannot seem to find the setting or property that controls this. Can someone point me in the correct direction? Thanks!!
Bryan Strader
Top achievements
Rank 2
 answered on 04 Nov 2009
2 answers
168 views
Hi,


  I would like to apply the skin for Report Parameters.Report parameters may be date picker, dropdownlist.

Please help me how to do it?

Thanks for your help,
Steve
Telerik team
 answered on 04 Nov 2009
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?