Does the designer support connection to postgres SQL server? Couldn't figure out a way to construct a working connection string...

Hi All,

I'm trying to build a report that accepts parameters during run time and the parameter is a String, i.e the user needs to select the Type of Transaction from a list of available types in the database and then I run a query to fetch all the records from the database which belong to the types of transactions selected by the user. When I enable MultiValue property in the Report Parameter Collection Editor I get the following error: "Object must implement IConvertible"
Please help, I need to fix this issue ASAP.
Thanks in advance!

Hello - I've a report that uses Garamond in the Report Header.

When I view the report in the browser it has the right font and it preserves the font when I export it in any format but PDF.
When exported in PDF format, not only does it loose the font, it looses some of the Font formatting too, I've the Header underlined, however in PDF the complete header is not underlined.

I've attached a screenshot of this, the screen shows first the report header in the browser and then the report header when exported to PDF.

Please advise.

Thanks.

I can view preview the report just fine in the preview tab of the designer for the report. But I get an error when the report viewer tries to load the specified report. I suspect that it has to do with the Report Server or Service in some way. When I set a break point at the point where the Report Viewer has been made I can see that the ReportServiceURI property of the Report Viewer has no real data associated with it. The properties of the ReportServiceURI and the ReportServerURI(ie Absolute Path, Absolute URI, Local Path, and anything that doesn't have a value of true, false, or an enum) all say that they threw an invalid operation exception. Is this normal?

I've been trying to figure this out for a while now and have seen many other forum posts and tried many things to fix this to no avail.

Some more info:
I'm using an Entity Data Model so the connection string is a little different than the other methods of connecting to data. I copied this connection string straight from the Web.Config file of the Web project of my silverlight application, which is where the data model is. If the preview works like it should(showing correct data from the data model) does this mean my connection string is correct and working?

The preview in the designer doesn't work (nor can I find data objects to use) when the connection string is messed up.

What are some of the things that could cause the Report to show correct data in the preview at design time, but not at execution time? How can I verify that my Report Service is working correctly for the client side connection to the entity model?

Any other information you need from me I'd be happy to provide.

Someone already asked this question a few years ago, and I wanted to know if now it is possible:

Is there any functionality available in Telerik Reporting to manage automated generation and devlivery of reports according to a schedule (for example, sending a daily report or monthly report)?

Thank you very much,
Inbal.

Hi,

I have just downloaded the latest version of the reporting tool: Telerik_Reporting_Trial_Installer_Q1_2012_v6_0_12_215 and once it opens it tries to install but I see always this screen (see attached image InstallerError.jpg)

Looks like there is a configuration error in the installer. Is there a way to get this working so I can install the reporting tools?


Thanks,
Manuel

Guys,

This is a simple issue I am having.   I have a Panel with a table within,   under certain conditions I need to stretch the panel to full page width,  besides stretching the panel during data binding, I explicitly tell the table that its width is now the report width  (table.Width = report.Width)      The panel stretches fine,   the table remains static.  

So my question is,   can tables be resized dynamically?    and if so,   how can this be accomplished.

Thanks.

I was working on a report that had a sub report that displayed in multiple columns. From what I understand Telerik Reports do not currently support multiple columns in sub reports so I came up with this hack.

1)      Create master report

2)      Create a sub report for as many columns you need

3)      For the sub reports you will need to return a rownumber value. From that you can use the modulus function to filter what is displayed. For example:

 Report1 filter would be

Me.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("= Fields.RowNumber Mod 2", Telerik.Reporting.Data.FilterOperator.Equal, "0")})

        Report2 filter would be

Me.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("= Fields.RowNumber Mod 2", Telerik.Reporting.Data.FilterOperator.NotEqual, "0")})

This splits the sub report columns to odds and even based on row count.

I wanted to make the solution a little more robust and move some processing to the server so I ended up using the stored procedure below. You pass in the total number of columns and which column the call is being made from. For example for a two columns-

subreport1 would pass @NumberofColumns=2, @ColumnNumber=1, @MultiColumn=True
subreport2 would pass @NumberofColumns=2, @ColumnNumber=2, @MultiColumn=True

I hope this helps and if anyone has ideas on improving this please post them.

CREATE PROCEDURE [dbo].[NET_sp_PullBuildingSubDept2]

(

      @BuildingIdnt int=0,

      @NumberofColumns int=0,

      @ColumnNumber int=0,

      @MultiColumn bit =0

)

AS

BEGIN

      SET NOCOUNT ON;

If (@MultiColumn =0)

BEGIN

      SELECT    REPLACE(REPLACE(EntityName,'(COM)',''),'(RES)','') as EName, EntityName as EntityName, DepartmentType, PoliticalSubdivision, ApprovalDate, BuildingIdnt,Row_Number() OVER (ORDER BY EntityName) as RowNumber

      from dbo.NET_vw_Building

      where PrimaryBuildingIDnt=@BuildingIdnt

      order by entityname

END

ELSE

BEGIN

      If (@ColumnNumber =@NumberofColumns)

      BEGIN

            Set @ColumnNumber =0

      END

      ;With MyCTE as

      (

      SELECT    REPLACE(REPLACE(EntityName,'(COM)',''),'(RES)','') as EName, EntityName as EntityName, DepartmentType

      , PoliticalSubdivision, ApprovalDate, BuildingIdnt

      ,Row_Number() OVER (ORDER BY EntityName) as RowNumber

      from dbo.NET_vw_Building

      where PrimaryBuildingIDnt=@BuildingIdnt

      )

      SELECT EName, EntityName, PoliticalSubdivision, ApprovalDate, BuildingIdnt, RowNumber

      FROM MyCTE

      WHERE RowNumber %  @NumberofColumns = @ColumnNumber

      order by entityname

END

END

GO

Hi there. 
I try to access the ReportProcessor and receive the following three Exceptions:



To translate this it means the , Telerik.ReportConverter.ActiveReports, Crystalereports and XtraReports could not be found. The telerik reporting dll 5.1.11.928  is added as a reference. I also tried another (newer) version of reports. The code area looks like this:

private RenderingResult RenderClearingArchivedReport(int clearingId, string culLang)

       {

           RenderingResult result = null;

 

           rptClearingArchived reportClearingArchived = new rptClearingArchived(culLang, this.DocumentTitle);

           reportClearingArchived.ReportParameters["clearingId"].Value = clearingId;

           result = new ReportProcessor().RenderReport("pdf", reportClearingArchived, null);

 

           return result;

       }

the line "result=" is throwing the exception.

The code was working on my collegues machine (who is on holidays currently) so there MIGHT be a configuration issue he did not check in.

Probably something really stupid.

I currently have a standard report that is working well and looks something like the following:

-----------------------------
Product: Foo
-----------------------------
Date      Itmes Sold    Total
Feb 01    5             14.95
Feb 03    2             5.98
Feb 04    10            29.90
-----------------------------
Total     17            50.83 [1]
-----------------------------

-----------------------------
Product: Bar
-----------------------------
Date      Itmes Sold    Total
Feb 01    7             34.94
Feb 03    1             4.99
-----------------------------
Total     8             39.92 [1]
-----------------------------

//...
more products
//....

-----------------------------
Report
Totals    26            90.75
-----------------------------

I've been asked to include a summary at the bottom of the report.  The summary will list the totals for each product (the information marked [1] above) similar to the following:


-----------------------------
Summary
-----------------------------
Foos      17            50.83
Bars       8            39.92
-----------------------------
Total     26            90.75
-----------------------------


As there is only one item detail per report, can this be done?  How would I create the summary?  Do I need to create a sub report?

Any help would be appreciated.