Hi,

We have few reports where there is a crosstab which shows product details with segments and values for the segment. There is a column grouping on segmentname column. Data shown by the report will be as follows

___________________________________________________________________________________________

ID   Code      Description            Barcode     Active?  Sellable?   Redeemable?   Size   Color    Class   Department

__________________________________________________________________________________________
1    ABC123  Pink Teddy             ABC123    'Y'           'N'              'Y'                     'S'       'Pink'    B1       N1
2    XYZ456  Blue Teddy             XYZ456    'Y'           'N'              'Y'                     'S'       'Blue'    B1       N1
3    CBV256  Chota Bheem        CBV256    'Y'           'N'              'Y'                     'S'       'Brown' B2       N1
3    NIV256  Ninja Sword            NIV256     'Y'           'N'              'Y'                     'M'       'Brown' B2       N2

4    BBN267 Big Basket Ball       BBN267    'Y'          'Y'               'Y'                     'B'       'Orange' B3     N3

___________________________________________________________________________________________

Columns up to 'Reemable?' are static columns. All columns after 'Reedeemable?' are segments. Segments are defined in a different table and are dynamic. Column grouping on segmentname is used to get all segment details for a product in a single row. There are filters on crosstable to see if only active products should be shown or only redeemable or sellable products should be shown.

We have clients who have a big list of products. They would want to look for details with different combinations of segmentname and segment values. For example the filter could be  as follows

((segmentname = 'Color' and  value = 'Brown') or  (segmentname = 'Class' and  value = 'B3'))

Since the segments are dynamic and there could be different combinations, adding segments as a parameter to the report will not help. We did not find anyway to add the filters to a string variable and append the string variable to the crosstab's datasource commandtext. Is there anyway in telerik reports for the user to open a window from the report where he could create such combinations and the filter string thus formed in addition to filters in the report could be passed to the crosstab? Please suggest what could be done.

We are using Report designer and creating reports for windows forms applications. The same reports are being used by Asp.net webforms.

After the the report initialization when I call the reportViewer.RefreshReport() my screen resolution and size stays the same, but my application dimension (screen size) changes, causing my application to become smaller.

any idea what is causing this ?

Hi,

I am trying to set my report datasource at runtime but it always seems to be recreated each time the report is refreshed. Basically I need to pass some complex parameters into my object's constructor (meaning that using report parameters wont be sufficient as they aren't basic types). I'm using the WinForms viewer and Q1 2016 reporting.

            var report = new MyReport();
            var ds = new MyReportDataSource();
            var objDs = new ObjectDataSource(); // I want to be able to pass some complex parameters here to initialize the object - this is just a trivial example
            objDs.DataSource = ds;
            objDs.DataMember = "Text";
            report.DataSource = objDs;
            var reportSource = new InstanceReportSource();
            reportSource.ReportDocument = report;
            ctl_Report.ReportSource = reportSource;
            ctl_Report.RefreshReport(); // This causes the constructor of MyReportDataSource to be called again

I have also tried setting the report.DataSource property to null, which causes the NeedDataSource event to fire - but this doesn't help as even if I set the datasource in the event callback, the constructor of MyReportDataSource gets called AGAIN when calling RefreshReport().

Is there a way to "inject" data into the report without it explicitly calling the constructor of the ObjectDataSource's data member?

Thanks,

Phil

Hi,

When creating a report programmatically, using the old charts for reporting I could populate the data for the chart directly using eg. series.Items.Add(mydataitem) - this way I could build a chart by simply inserting data items manually without any datasource. I am now using the new Graph object and I cannot figure out how to dot his - is it even possible?

Hi,

I have a custom resolver working with my html report viewer to display trdx's just fine. Some reports though are not trdx though so I will create these purely in code (in my resolver?) and pass the report to the viewer. I have tried the code below and it seems to work but I just need to confirm that I am doing it the correct way?

ie. is it correct to return a report object instance from the custom resolver?

Hi,

We are evaluating telerik reports.

The below code snippet is defined in the Report Controller. Report works fine. But when a report is generated, the number of open connection of the telerikSession (used only for cache) is high and they do not get closed. I tried with one user, running one report and the number of openconnections is 30. Can you help me sort out this issue?

static ReportServiceConfiguration preservedConfiguration;
static IReportServiceConfiguration PreservedConfiguration
{
get
{
if (null == preservedConfiguration)
{
preservedConfiguration = new ReportServiceConfiguration
{
HostAppId = "ABC",
Storage = new MsSqlServerStorage(ConfigurationManager.ConnectionStrings["TelerikSession"].ConnectionString),
//Storage = new FileStorage(),
ReportResolver = new OrgnResolver(),
ReportSharingTimeout = 0,
// ClientSessionTimeout = 15,
};
}
return preservedConfiguration;
}
}

Thanks

If I have the Reporting WebAPI setup so that it's working, ie http://localhost:56200/api/v1/report/ is returning:

[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLS","localizedName":"Excel 97-2003"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"MHTML","localizedName":"Web Archive"},{"name":"XPS","localizedName":"XPS Document"}]

What would cause a 404 when attempting to retrieve a template? ie:

http://localhost:56200/api/v1/report/resources/templates/telerikReportViewerTemplate-html

  We are using Telerik Reporting to generate our report, we are facing following problems.