I have successfully created reports with additional Table items (i.e. in the report footer) that share the same main report datasource, and avoid having it re-execute.  This works well.

However I now have a different scenario.  We use just Designer for building reports, and entity datasources which are all calls to SQL Server stored procedures.

I have a Master datasource, call it M, which is the main report datasource.  The detail section has a few fields from M, plus a small Table.  I use a Table as you recommend that as more efficient than a subreport.  I have a second datasource for details fetched for all master rows call it D.  The Table is assigned to D, and I can get a filter condition on the table by referring to a Key field in M.  This all actually displays properly, each Table displays the proper 2 or 3 rows filtered out of the entire D result set.

However, the datasource D is being re-executed for every master Detail section being displayed.  I somewhat expected that, but still is very bad.

Also just as a bonus, I have one additional table in the report Footer and refers to the same datasource D and summarizes that data, and of course it causes the datasource D to execute yet one more time.

I have read many articles here but I have not seen a master-detail example using entity data source, and just Report Designer, and avoiding the multiple re-executions of the D datasource.  I have done a similar layout in SSRS and the detail datasource is executed only once then shared, but I can not find the equivalent implementation using your Report Designer.  Thanks.

I'm having an intermittent issue where calls to the reporting REST API service are failing with a 500 error (below).

The steps that are occurring are:

1. Report run is initiated.
2. Can see successful POST to the instances URL: ~/api/reports/clients/113946-7092/instances.  Responds with: {"instanceId":"105138-bc13"}.
3. Can see successful POST to the documents URL: ~/api/reports/clients/113946-7092/instances/105138-bc13/documents. Responds with: {"documentId":"114313-ce58114313-a5ac"}
4. Can see unsuccessful GET to the info URL: ~/api/reports/clients/113946-7092/instances/105138-bc13/documents/114313-ce58114313-a5ac/info.  Responds with the below 500 error.

If I keep clicking the Preview button (with the same parameters set), eventually, one of the requests will complete successfully and the report runs.  Otherwise, the above happens.

Has anyone run into this before?

500 error being returned:

Hello, 

i have a table and want to set the backcolor of my cells to the Hex-Value that is stored in my Fields. Is this even possible and if yes, how can i do this?

Greets, Philipp

We just upgraded from Sept 2016 to Oct 2016.  The user said he did not have this issue with the previous version.  The only thing I changed in the app was that it updated it when I upgraded the controls.  I compiled and this is what we are seeing:  (makes it hard for users to sort)

Morning.

I am wondering if this is possible using the standalone designer.

I have a report already built that I need to insert a subreport into. However, the sub report needs to use a CSV file as its datasource (main report is using SQL Native). The path to this CSV is stored as a STRING in my main report query. So the MainReport has a SQL statement similar to:

Select Field1, Field2, ....'Path to CSV File' as dsCSV  From SomeTable

I know need to tell the subreport that the field dsCSV is the path to the file it should use.

Any ideas as to if this is possible (good program so I assume everything is possible) and how it would be done (looking for an example).

Note that I only have the standalone designer.

Thanks,

Brian

I have big report that take around 2 min until finish generating the report, while the report is processing, I am unable to load another page.

I read it could be session blocking issue, so I tried to use async Task in the .NET to get the Data from the server, but still I am unable to  load another page in  the same time.

I am trying to load another page while report viewer is generating the report

Please Help !

When i preview a report in the Designer I get an error in a PictureBox that has some conditional formatting depending on the values from the Datasource (see attach).

It's weird because if i render this report to pdf, I get no errors (I just supply parameters to the report, I dont set any datasources).

How can I fix this in the designer?

Hi.

I need to change connection string in my reports dynamicly, sinse different users might have different databases.

I saw this article http://www.telerik.com/support/kb/reporting/details/changing-the-connection-string-dynamically-according-to-runtime-data and everything worked great, but now we have a report with sub report section. In SubReport section we have a path that depends on a value selected in the main report:

ReportSource: ="./Content/reportDefinitions/"+Replace(Parameters.ReportType.Value, " ", "_")+".trdp"

Problem is that solution suggested in the article above fails. It tries to desirialize path wich is "./Content/reportDefinitions/"+Replace(Parameters.ReportType.Value, " ", "_")+".trdp" and of cause can't find it.

I also tried to hardcode subreport name and than use Unpackage method.

var report = reportPackager.Unpackage(sourceStream);

But if I do so, I get another error. Both reports Main one and sub report depend on the same parameter ReportId, and some how subreport claims that this parameter was not passed, main section works fine.