Telerik Forums
Reporting Forum
8 answers
552 views
Hello,
Can someone please help me out with displaying a series of graphs on a webpage? Essentially, what I want to do is have a webpage that clients can log into to view visual statistics of a web survey. But I can't find any information about how to do this using reporting -specifically, how to get the graphs working in a web page. Is there any tutorials on this?

Tris
Ivan Hristov
Telerik team
 answered on 27 Nov 2013
7 answers
670 views

In some reports we use the background image.
Sinds the update from Q2 2012 to Q3 2013 SP1 we needed to change the way to set a backgound image.

From
report.Style.BackgroundImage.ImageData = imageData
to
report.PageSettings.BackgroundImage.ImageData = imageData

Sinds this change the backgroundimage is not fully visible anymore. The data from a detail section / subreport is now a overlayer above the backgroundimage.

How can i prevent this?

Peter
Telerik team
 answered on 27 Nov 2013
4 answers
122 views
I'm having trouble passing an integer parameter to a user defined function. I've read all of the posts and the kb article, but I can't seem to pass an interger to my function. I can pass a string, but not an integer. 

Here's what I've got:

public static string GetInt(int orgId)
{
    return "Get Int: " + orgId.ToString();
}
 
public static string GetText(string orgId)
{
    return "Get Text: " + orgId;
}

My binding expressions are:

= GetText(Parameters.ParmString.Value)

= GetInt(Parameters.ParmInt.Value)

Integer Parameter: AllowBlank: True, AllowNull: False, MultiValue: False, Type: Integer, Value: 9999

String Parameter: AllowBlank: True, AllowNull: False, MultiValue: False, Type: String, Value: Test String


Thanks. All help is appreciated.
Ivan Hristov
Telerik team
 answered on 26 Nov 2013
3 answers
157 views
I have a pie chart which can have a large number of legends, when this happens, the legends becomes several columns and seems to push the pie chart outside the plot area, thus the chart is either partly or fully invisible.

Is it possible to make the legend expand vertically, rather than horizontally?

In Visual Studio, I have the legend overflow as column (Visual Studio > Properties > Legend > ItemTextAppearance > Overflow > Column) currently. Setting the Overflow as Row doesn't help either.

Edit:
Ignore the % in the legend, I know it's incorrect.
IvanY
Telerik team
 answered on 26 Nov 2013
2 answers
104 views
Hello,
I have added parameters through coding. and set visibility false. These parameters visibility depend on other parameter value. When the parameter value changes I set visibility to true but on preview button first click these parameters doesn't display. I need to click once again.

please help.
Thanks Satish
Satish
Top achievements
Rank 1
 answered on 26 Nov 2013
1 answer
252 views
Hi,

I am facing some issues to disable the Report parameter drop down in Telerik Report Viewer. I want to disable report parameter drown based on another Report Parameter value. Example: I have two report parameters like Country and States. If i select a country form country drop down corresponding states should be filtered(this is achieved) and if i select "ALL" in the country drop down States drop down should be disable. I am not able to disable the states drop down.

Any help would be appreciated. Thanks in Advance.

Thanks,
Satya 
IvanY
Telerik team
 answered on 26 Nov 2013
1 answer
268 views
SqlDataSource seems to work fine with an Oracle DB connection string but I cannot get the EntityDataSource component to work with Oracle.  Is this supported please?  I do not see any document for this combination.

I set up the EntityDataSource component using the wizard and then when I click on the Preview tab the following error appears:

An error has occurred while processing Report 'Report1':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
------------- InnerException -------------
The provider did not return a ProviderManifestToken string.
------------- InnerException -------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
------------- InnerException -------------
The network path was not found


It seems to show a SQL rather than Oracle error!

Thanks
Peter
Telerik team
 answered on 26 Nov 2013
1 answer
72 views
Good Afternoon,

I am currently trialing the Reporting DevTool with a view of purchasing it providing it can acheive what i am trying to achieve.  I have been having a look on the forums and the Help files for the reporting to try and solve an issue that i am having, however at the minute i am unable to find a complete solution.  Hence the post in here.

Basically what i have is a report that i have designed and is previeving exactly as i would expect it to in the .Net design viewer in VS2012.  However what i am trying to achieve is changing the datasource at runtime for that report before displaying it.  I have found out the following links:

http://www.telerik.com/help/reporting/programmatic-creating-report.html
http://www.telerik.com/help/reporting/winforms-report-viewer-embedding.html

which i believe detail what i am trying to acheive however when i try and put them together i dont seem to get anything and i cant set the report to open in the viewer.  Could someone please provide me with some advice and guidance as to how i can achieve this. 

Thank you in advanced

Luke Frost
Peter
Telerik team
 answered on 26 Nov 2013
1 answer
161 views
We have just started to evaluate Telerik Reporting. One of the criteria is to be able to convert the old report files which were created in Crystal Reports 11.5.

I am able to convert the old .rpt files from Crystal to a Telerik Report after I followed this KB article for binding redirection: http://www.telerik.com/support/kb/reporting/general/converting-reports-from-various-versions-of-crystalreports.aspx however, not all the sections are getting converted. Major issue is with the group sections. For all the group sections I get the following error in the Report Conversion Summary:

Error: Error converting group: Component of type Group could not be created.  Make sure the type implements IComponent and provides an appropriate public constructor.  Appropriate constructors either take no parameters or take a single IContainer parameter.. [Report5]

Has anyone run into this situation? Does Telerik have a work around or solution to overcome this problem?



IvanY
Telerik team
 answered on 25 Nov 2013
3 answers
174 views
We have created a set of reports in VS that run just fine.  There is a listing of Orders with a button that launches each report based upon the row selected in the listing.  Now they would like me to add another button to simply email out the report for the selected row.  So what I have done is:
  1. Taken existing VS report and imported them into the StandAlone Designer.
  2. Saved the .tdrx files to the app_Data folder.
  3. Used the XML Deserializer to get the report.
  4. Render the report as a PDF. (See issue below)
  5. Attached the PDF to an email and send.

The basics work, however I am having trouble fully rendering the report due to the data connection. 

Issue:
I can't seem to figure out if the connection string from the original VS report; the string needs to be modified in the .tdrx or (as in my code below) programically added just before rendering????

If needed at run time, I have 2 SQL data sources in the original report, how do I do multiples in my code?

public void MailReportWparam(string Neededreport,
            string param,
            string paramValue,
            string reportNames,
            string from,
            string to,
            string subject,
            string body)
        {
            ReportProcessor reportProcessor = new ReportProcessor();
 
            System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
            settings.IgnoreWhitespace = true;
 
            using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("C:\\Development\\PFSc2\\PFSc2\\PFSc2\\App_Data\\" + Neededreport + ".trdx", settings))
            {
                //Generate Report from XML Template
                Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
                    new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
 
                Telerik.Reporting.Report report = (Telerik.Reporting.Report)
                    xmlSerializer.Deserialize(xmlReader);
                    report.Name = reportNames;
                //Set Database connection
                //Edit for Production
                    Telerik.Reporting.SqlDataSource dataSource = new Telerik.Reporting.SqlDataSource();
                    dataSource.ConnectionString = "Data Source=ITDESKTOP\\PFS;Initial Catalog=PFS;Persist Security Info=True;User ID=########;Password=##########";
                    dataSource.SelectCommand = "SELECT        KF_Procurement.ID, KF_Procurement.Vendor_ID, KF_Procurement.Receiving_Date, KF_Procurement.Create_Date, KF_Procurement.BOL_ID, KF_Procurement.BOL_Date, KF_Procurement.PO_ID, KF_Procurement.PO_Date, KF_Procurement.Rec_Del_Method_ID, KF_Procurement.Temperature,KF_Procurement.Confirm_Date, KF_Procurement.Sent_Date, KF_Procurement.POType_ID, KF_Procurement.Revision_Date, KF_Procurement.warehouse_ID, KF_Procurement.VendorAddressID, KF_Procurement.Trucking_PackType_ID, KF_Address.TypeID, KF_Address.IsActive AS Expr2, KF_Address.Street1, KF_Address.Street2, KF_Address.City, KF_Address.StateID, KF_Address.State, KF_Address.CountryID, KF_Address.Country, KF_Address.Postal, KF_Address.Start_Date AS Expr3, KF_Address.End_Date AS Expr4, KF_Address.ID AS AddrID, KF_Address.Ven_ID AS AddrVenID, KF_Address.Store_ID, KF_Address.Cust_ID, KF_Address.Ware_ID, KF_Address.Person_ID, KF_Address.Owner_ID AS Expr5, KF_Address.IsPrimary, KF_Address.Owner_Type, KF_BOLs.ID AS BOLID, KF_BOLs.Date, KF_BOLs.Number, KF_BOLs.POType_ID AS BOLPOtypeID, KF_BOLs.POType, KF_BOLs.Status_ID, KF_BOLs.OwnerType_ID, KF_BOLs.Owner_ID AS BOLOwnID, KF_BOLs.DeliveryDate, KF_BOLs.Comment, KF_BOLs.Issued, KF_BOLs.Date_Issued, KF_BOLs.InsertDt, KF_BOLs.InsertBy,  KF_BOLs.UpdateDt, KF_BOLs.UpdateBy, KF_BOLs.Old_Sys_Num, KF_Person.FName, KF_Person.LName, KF_Person.FullName, KF_Person.OwnerID,  KF_Person.IsActive AS PerIsActive, KF_Person.Start_Date AS PerStartDt, KF_Person.End_Date AS PerEndDt, KF_Person.Vendor_ID AS PerVenId,  KF_Person.Cust_ID AS PerCustID, KF_Person.Store_ID AS PerStoreID, KF_Person.ID AS PersonID, KF_Person.WrHse_ID, KF_Person.IsPrimary AS PerIsPrimary,  KF_Person.UserID, KF_Phone_Email.Owner_ID AS PhEmOwnId, KF_Phone_Email.Phone_Number AS PhEmPhNum, KF_Phone_Email.EmailAddress AS PhEmEmail,  KF_Phone_Email.IsActive AS PhEmIsActive, KF_Phone_Email.Start_Date AS PhEmStartDt, KF_Phone_Email.End_Date AS PhEmEndDt, KF_Phone_Email.Type_ID,  KF_Phone_Email.ID AS PhEmID, KF_Phone_Email.Cust_ID AS PhEmCustID, KF_Phone_Email.Ven_ID AS PhEmVenID, KF_Phone_Email.Person_ID AS PhEmPerId,  KF_Phone_Email.Ware_ID AS PhEmWarID, KF_Phone_Email.Store_ID AS PhEmStoreID, KF_Phone_Email.IsPrimary AS PhEmIsPrimary, KF_Vendor.ID AS VenID,  KF_Vendor.Name FROM            KF_Procurement LEFT OUTER JOIN KF_Vendor ON KF_Procurement.Vendor_ID = KF_Vendor.ID LEFT OUTER JOIN KF_Person ON KF_Vendor.ID = KF_Person.Vendor_ID LEFT OUTER JOIN KF_Phone_Email ON KF_Vendor.ID = KF_Phone_Email.Ven_ID AND KF_Person.ID = KF_Phone_Email.Person_ID LEFT OUTER JOIN KF_BOLs ON KF_Procurement.BOL_ID = KF_BOLs.ID FULL OUTER JOIN KF_Address ON KF_Vendor.ID = KF_Address.Ven_ID AND KF_Procurement.VendorAddressID = KF_Address.ID AND KF_Person.ID = KF_Address.Person_ID WHERE        (KF_Procurement.ID = @ProcID) AND (KF_Person.IsPrimary = 1)";
                    dataSource.Name = "ProcDataSource";
 
                    report.DataSource = dataSource;
                //Feed report paramaters
                    report.ReportParameters[param].Value = paramValue;
                //Create PDF of report
                    RenderingResult result = reportProcessor.RenderReport("PDF", report, null);
                    MemoryStream ms = new MemoryStream(result.DocumentBytes);
                    ms.Position = 0;
 
                //Create Email Message with Attachments
                    MailMessage msg = new MailMessage(from, to, subject, body);
                    Attachment attachment = new Attachment(ms, report.Name + ".pdf");
                    msg.Attachments.Add(attachment);
                    SmtpClient client = new SmtpClient();
                    client.Send(msg);
           }
}


Peter
Telerik team
 answered on 25 Nov 2013
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?