Telerik Forums
Reporting Forum
4 answers
141 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
178 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
108 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
267 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
282 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
76 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
175 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
189 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
1 answer
163 views
There is a problem in our report pages. long text fields looks bad.
Not: All fields multiline have to be.

Page view screenshot: http://prntscr.com/25ozvf

Designer and "Açıklama" textbox properties: http://prntscr.com/25p0ls
Designer and Other textbox screenshot: http://prntscr.com/25p193

Thanks
Stef
Telerik team
 answered on 22 Nov 2013
1 answer
167 views
Hi Telerik Team,

i have a WPF application with several Reportviewers,
each in a RadTabItem (inside an RadTabControl).

The Report in the active (visible) RadTabItem is rendered properly. However, when the user selects another RadTabItem
(so the ReportViewer is hidden) the ReportViewer loses its rendering. When the RadTabItem with the reportviewer inside is selected again,
(so the ReportViewer becomes visible again) the Report is rendered newly from the scratch.

This is very annoying because a) rendering takes some time and b) i render a reportbook, so the second time the ReportViewer renders the report, the position of the selected report is lost.

Is there any possibilty to prevent the ReportViewer from losing the rendering when hidden? Some kind of caching..

Best regards.
Stef
Telerik team
 answered on 22 Nov 2013
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?