Hello supports,

I want to create subheader that display on every page. I found only settings for header RowHeadersPrintOnEveryPage and ColumnHeadersPrintOnEveryPage. I set these values on true and header is display on every page. Do we have such settings for the subheader or some way to display these subheaders?

Thank you 

I have an ASP.Net Core application (MVVC) which will run on Azure.

I need to create a PDF report which mimics the add/edit (View) page.  Only one report would be created at a time and it is anticipated that this will be a low volume requirement.

Can anyone point me to any demos/samples that I could follow to create the report?

Thanks

Using the WPF report viewer, I see this message

Where is this 100 seconds defined?  Its not a command timeout as I have those either on the default of 30 or set to 120.  Is there a client side timeout set on the web requests to the server?

I have a razor page in my Blazor server app with a report viewer control on it (named AllowanceDetailViewer in the code below). I gather the desired parameter values for this report from the user on page 1 and then launch page 2 and pass it those values. On page 2 I want the report to display using the passed values when the page loads.

The issue is where do I put the call to the Refresh() function on page 2? If I put a call in OnInitializedAsync() I get an error that the AllowanceDetailViewer object is null (so it hasn't loaded yet). If I put a call in OnAfterRenderAsync() I get an internal error from the viewer control. Is there a page event I can use where the report viewer is fully loaded and ready for use?

Note: if I add a button to the page and call the Refresh() function from the button click it works fine. That tells me the code in the Refresh() function is working. What I want is to call that code during the initial page load so it happens automatically without the user needing to click on something first.

        
<ReportViewer @ref="AllowanceDetailViewer"
                      ViewerId="rv1"
                      ServiceUrl="api/reports"
                      ReportSource="@(new ReportSourceOptions
                                {
                                    Report = "BlankReport.trdp"
                                })"
                      ScaleMode="@(ScaleMode.Specific)"
                      Scale="1.0"
                      ViewMode="ViewMode.Interactive" 
                      ClientEvents= "@(new ClientEventsOptions() {Ready = "ReportReady"})" 
        />
 

        async Task Refresh()
        {
            rso.Report = "AllowanceDetail.trdp";
            await AllowanceDetailViewer.SetReportSourceAsync(rso);

            rso = await AllowanceDetailViewer.GetReportSourceAsync();

	    //code here setting a bunch of parameters, this is just a stub
            rso.Parameters["parameter1"] = "new parameter value";

            await AllowanceDetailViewer.SetReportSourceAsync(rso);
        }

I have a datasource that returns data similar to:

MemberId,
MemberName,
PurchaseItem,
PurchaseDate,
PurchaseAmount

Naturally, the MemberId is going to be repeated in the results, once for every purchase.  That's expected because I'm grouping by MemberId in the report.

But when setting up the query using the Configure SQL DataSource wizard, if I execute the query on the "Preview Data Source Results" step of the wizard I get the error "Column MemberId is constrained to be unique. Value '25' is already present'".

Why is this even being checked?  There's nothing wrong with a value appearing on more than one row. I'm not inserting to the actual table where the constraint would certainly apply. I'm just selecting data.

Is there a setting I'm missing?  If I just ignore the error and don't show any preview, the report itself works fine. It seems to be a bug in the preview.

I'm using MySql as the database.

Hi,

Is there a way to determine the subreport name where the pageheader is being renedered?

I need to make items (textboxes) on the pageheader invisible depending on the subreport it is being rendered on.  Is this possible?

Please contact me at mrogers@saberindustries.com

Thank you for your help

Mark Rogers

Is it possible to control the sorting direction of the table via report parameter?

I want to pass Asc or Desc value as Report Parameter and sort the table rows.

Please advice.

Thanks

BV

Hi,

How can I pass Column names via Report Parameters to Filter the records in a table?

The report has 5 columns. I need to filter the table based on a Column. This column needs to be passed to the report dynamically from a screen.

I can pass the filter value via the Report parameter and successfully filter a Column. But my requirement is the Column (Field) that will be used is not known prior and needs to be passed into the report via Report Parameter. The column names are dynamic.

I am using Expression in Filters, but am not able to make this happen.

Please advice.

Thanks,
Balaji. V

Hi,

We use web report designer to modify some reports. Mainly we use Standalone report designer to create report.

In our case, we don't need Menu>New menu. Is it possible to somehow disable or hide New menu?

Thank you,  

We're building an Azure Web App using an Azure SQL Server database.  It will incorporate Telerik Reporting.  We have no plans to use Report Server at this time.  The target framework is .NET Core 3.1.

Currently, we're building reports using the standalone desktop report designer, with SQL data source connections.  The intention is to integrate these as another project in the solution at a later date.

Is this the best way to proceed?    Are we better off using the EntityDataSource component? 

More to the point, what are the architectural decision criteria and best practice patters for this kind of development?  Where might I find them documented?

For example, we could set up a data access layer as a separate project in the solution, and then it could be built as an external assembly to make it available for designing reports.  This would have the great benefit of decoupling the database from the solution and providing a single common interface to the data for all projects (and indeed, any future other solutions).

But it is clearly more work.  What are the criteria to choose the approach to use?

Should we even be using the standalone report designer?  Should we be using the Visual Studio Report Designer instead?  I do understand that we currently can't use this, but I also understand that .NET Core 3.1 support is coming real soon now.  (Roughly when, please?)

When should we use the HTML5 Report Viewer and when should we use the HTML5 ASP.NET MVC Report Viewer?  What are the advantages and disadvantages of both?

Again, what is the best pattern, the recommended approach?  And using what criteria?

I realise I'm asking a set of very open-ended architectural questions; I'm hoping that you might provide some general guidance here as it would certainly be extremely useful for us right now, and quite likely for a lot of other folk in the future.

Best wishes, Donna Kelly