Telerik Forums
Reporting Forum
6 answers
168 views
Hi I have a problem with Telerik Reporting or a challenge ;-)

I have a report of 3 records in a table as shown below and need to display based in value, and total up based upon value...
Field name is Fields.Amount

Description                            Debit                Credit
Product X                                120.00        
Product Y                                240.00
Payment A                                                    200.00
========================================
Totals                                    360.00            200.00
Balance                                160.00


Any help appreciated.

Desmond.
Desmond
Top achievements
Rank 1
 answered on 28 Apr 2011
3 answers
142 views

Friend I have query in Drillthrough Report I have two report Rone and Rtwo , I add report two as Drillthrough Report so when we open Rone we can go at Rtwo.
Now I want to know how I can come back again , when it open Drillthrough Report , Rtwo , how I can come back again on previous report , Rone.

I hope my question is clear.

Thanks

Steve
Telerik team
 answered on 28 Apr 2011
2 answers
182 views
I'm having a problem with Page Breaks.

I have a MasterReport which is simply an empty report that contains a standard Header, Footer that I want to use on all reports and maintain in only one location.  The master report has a subreport object on it.

I then dynamically bind reports to the subreport at run time inside of the ASPX page.

When the reports are rendered and or exported the paging isn't honored.   If I just render the sub reports directly then the paging is done correctly.

I have the subreport inside the Detail Section on the Master Report(See reportexplorer.png).  The subreport has a subreport as well.  Its report explorer is shown as well.  I've also included images of the two renderings. The correct rendering is when the subreport is bound to the viewer directly.   the incorrect rendering is when the master is bound to the viewer.

Thanks
  Marcus
Peter
Telerik team
 answered on 27 Apr 2011
9 answers
1.2K+ views

I'm wokring on an application for a client that wants some high res print media PDFs generated. I am trying to use telerik reports for this.

I have all my elements added to the report using cm so the elements will all fit correctly on the page. However when adding the images i have into picture boxes, I have them exported based on 300 dpi, and telerik reports seems to default to 96 dpi, so they do not fit in the designer. If i reduce them to 96 dpi the do fit but come of rat shit on the PDF and when printed (and yes i have read this article http://blogs.telerik.com/blogs/posts/09-01-07/the_strange_case_of_adobe_acrobat_or_why_do_images_in_telerik_reports_get_fuzzy_when_exported_to_pdf.aspx).

Can someone please tell me how to specific the pixels per inch/cm for telerik reports?

Thanks,

Joel

Massimiliano Bassili
Top achievements
Rank 1
 answered on 27 Apr 2011
3 answers
161 views
Hi,
I'm new to Telerik and Telerik Reporting. I was wondering if someone could help me out. I have some RadControls and ASP .Net controls that I need to get values from in order to pass them as parameters to a report viewer.  On the Report itself I don't have the Value property set on any parameters, the parameters in question are boolean. I get the following error:
"An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.
Invalid value of report parameter 'InfoSectionVisible'.
"
Where should I put the logic for grabbing the report parameters from controls on the aspx page so that when users hit the preview button the report reflects the user's input from the controls?
Thanks!
20Below
Top achievements
Rank 1
 answered on 27 Apr 2011
1 answer
179 views
I have a report that requiers a count of users in specific roles.  I am usiing the following expression:
= IIF(Count(Fields.spendSpeakerID) = 1 ,Count(Fields.spendSpeakerID),Count(Fields.spendUserID))

If the user is a speaker the it populates with 1 which is correct however if the user is a none speaker it populates with a 1 also.

I have made two text boxes and used the following Count(Fields.spendUserID) and Count(Fields.spendSpeakerID).  The text boxes show the correct umber 1 and in this case 8.  However I cannot get the text boxes that make up the column to show the correct number of users when I use a conditional statement.

As a side note there will only be a maximum speakerID of 1 in any report.  But the number of non-speaker users will vary.

I thought about using the value of the test Textbox that gives the correct number but I found out I cannot reference that value.  Any help or suggestions?

Russ
Squall
Top achievements
Rank 1
 answered on 27 Apr 2011
6 answers
754 views
Hi,

I have a very basic report, showing about 20 fields with Headers,Details and Footer with aggregates.
The columns are docked left, what aligns them very nicely.
I added them with the wizard and then tested the report, all went fine.

But some fields where simply to narrow so I wanted to make them wider. I marked the header, the detail and the aggregate field of one column and hit SHIFT+Arrow Left, wich made all marked fields 1 pixel wider - fine so far. But after that all fields are unmarked and I couldn 't continue, but instead, had to mark all fields again.
I'm aware that I could resize one and align the other by using "Format->Make Same Size" but this triples the clicks necessary. A realy pain in the a** with 20+ fields.
And after aligning the fiels, they also get unmarked and I have to mark them a second time if I want to align them not only in size but also by position

Same happens when I try to move multiple fields at once with the arrow keys. Here moving the fileds with the mouse is no option, because you can't move fields from different sections with the mouse, all fields but the ones from a single section get unmarked.

Another problem I have is the order in which the columns appear on my report.
I use the "Dock:Left"-Property to align them, but I like to change the order in wich they are aligned.
I already tried to change the order in which my SQL-Select statement retireves them from the database, but that didn't have any effect plus my calculated columns always appear at the end.

Another question would be if there is a option to add aggreagated fields like SUM/AVG fields automatically to a group/report footer.
Again I can do this by hand but work sum pretty much up with many columns.

I hope you can give me some solutions for the problems above, because I was really looking forward to get rid of CrystalReports and replace in with something better, but with my reports mainly consisting of simple data and aggregate footers but with many different columns, using the TelerikReports-Designer is, right now, not very comfortable.

Thanks in advance
Lukas
Steve
Telerik team
 answered on 27 Apr 2011
0 answers
59 views
Hi,

I'm trying to build some reports using an SharePoint 2007 list enclosed in a ObjectDataSource to access the data at design-time. However I can not get the preview function of the reporting designer to work. If I paste the dataobject code in an console application it works perfectly. But if i use it in a reporting project(class lib) I get the following error: "The web application could not be found." I've triple checked everything, but it still gives me the error.

Here is my dataobject code:

namespace ReportingTest2
{
    [System.ComponentModel.DataObject()]
    public class UrenSpecificatieDS : List<UrenSpecificatieItemObj>
    {
        [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select)]
        public List<UrenSpecificatieItemObj> GetUrenBetweenDates(DateTime beginDate, DateTime endDate)
        {
            if (beginDate != null && endDate != null)
            {
                using (SPSite site = new SPSite("http://devserver"))
                {
                    using (SPWeb web = site.OpenWeb())
                    {
                        SPList spUrenSpecificatieList = web.Lists["HourRegistration"];
                         
                        SPQuery query = new SPQuery();
                        query.Query = "<Query><Where><And><Geq>" +
                                      "<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-01T02:18:48Z</Value>" +
                                      "</Geq><Leq>" +
                                      "<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-24T02:18:50Z</Value>" +
                                      "</Leq></And></Where></Query>";
 
                        foreach (SPItem item in spUrenSpecificatieList.GetItems(query))
                        {
                            UrenSpecificatieItemObj ur = new UrenSpecificatieItemObj();
                            ur._Date = getDateField(item, "Date");
                            string[] split = { ";#" };
                            ur.Company = getStringField(item, "Company").Split(split, StringSplitOptions.None)[1];
                            ur.Hours = getDecField(item, "Hours");
                            ur.Distance = getDecField(item, "Distance");
                            ur.Description = getStringField(item, "Title");
                            this.Add(ur);
                        }
                    }
                }
                return this;
            }
            return null;
        }
// omitted the helper methods.
}
So this code works in an console app, but not when previewing the report in a class library.

When I search for the errors about "The webapplication is not found" and there are some mentions about using x64 builds. I've tried to set my project to x64 exclusive, but Visual Studio 2008 gives an error about some assembly's beeing wrong but I guess that is probably of some dependencies of the reporting control. I'm using Windows 2008 x64 as dev platform.

I hope somebody can shed some light on this, as I would like to use the full design time controls to create my report. Any help is grealty appreciated.
Bartdesign
Top achievements
Rank 2
 asked on 26 Apr 2011
2 answers
115 views
Hi,

I am currently using Q1 2011 and with UseNativePrinting set to false.
When running in local machine, print from ReportViewer works fine. After deploying to server, with http it still works, but not work for https.
Click on print button and nothing happens.
Do I need to set up any configurations?

Thanks in advance.
VH
Top achievements
Rank 1
 answered on 26 Apr 2011
1 answer
122 views
Hello,

I see that Telerik has the Sparkline control available for Silverlight and WPF.  I am wondering why this is not included in Telerik Reporting?  It looks to be a very powerful way to display data and would fit in very well in reports.  Or is there a way to make this happen?


Thanks,

Chris
Peter
Telerik team
 answered on 26 Apr 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?