Hello,

I am trying to refresh the dataset at the Data Explorer window of the Report Designer so that it reflects the changes made to the database on the tables and views used as the data source for the report.

But it does not work. I can only see the new fields if I create a new data connection for the same tables/views.

What should be the rigth way to reflect the changes in the database to the report?

Regards,

Alexandre

We are trying to create a single report page that can handle a number of reports as opposed to 100's of pages to accomodate 100's of reports.  We are doing this by dynamically setting the report.  We can successfully do that and any parameter values.  But we cannot successfully dynamically define the paramters.
I'm going off of this documentation page (the code below is directly from that):  https://docs.telerik.com/reporting/html5-report-viewer-howto-use-it-with-reportserver
We are able to dynamically select the report and dynamically set the parameter value.  However, we are unable to set the parameter itself dynamically.  In the example below the parameter is ReportYear 
$("#reportViewer1")
  .telerik_ReportViewer({
    reportServer: {url: "http://yourReportServerUrl:port", username: null, password: null},
      reportSource: {
        report: "Samples/Dashboard" //WE CAN MAKE THE REPORT DYNAMIC TOO
        parameters: {
          ReportYear: 2004 //WE CAN MAKE 2004 A VARIABLE BUT ReportYear has to be hard coded in
        }
      }
  });

hello.

I have a question about specifying the report source.

in razor page code : 

<ReportViewer @ref = "ReportViewer1"
	ReportSource=@@@
	...
>

Only ReportSourceOptions were available for ReportSource in the ReportViewer.

Report in ReportSourceOptions can only be fileName with String.

What I want is to use UriReportSource to deliver ConnectionString or change DataSource.

Therefore, I would like to use ReportSource instead of fileName.

The document I referred to is as follows.

1. Action NavigateToReport does not work after updating the Connection String dynamically in a Custom Report Resolver

2. Changing Datasource at runtime in Blazor

I referred to the second document and thought that using resolver could solve the problem that ReportSourceOption does not receive the ReportSource format.

But the problem still hasn't been solved.

ReportSourceOptions rso = new ReportSourceOptions();
CutsomReportSourceResolver sr = new CustomReportSourceResolver("connectionStrings");
rso = sr.Resolver("Report.trdx", new Dictionary<string, object>{ @@@}); (X)
//OperationOrigin is skip

Please let me know if I used the wrong method.

Additionally, I don't know what Operation Origin is like.

Also I would be grateful if you would give us about operationorigin.

thanks.

I can't get any columns to show in the Data Explorer when setting up a SQL Data Source with a command text that calls a SQL TVF function.

My example/test function is as follows:

CREATE OR ALTER FUNCTION dbo.Test(
	@CommaSeparatedValue varchar(max)
)
RETURNS @Items TABLE(
	ItemValue numeric(18,0)
)
AS
BEGIN
	INSERT INTO @Items
	SELECT
		Items.ItemValue
	FROM dbo.StringSplit(@CommaSeparatedValue , ',') Split
	LEFT JOIN Items ON TRY_CAST(Split.[Value] AS numeric(18,0)) = Items.ItemValue
	
	RETURN
END

And my set up for the datasource object:

Columns show as expected when querying a table or view, but TVF functions do not seem to work. In Expressions, I cannot see any available Fields.

Hi , 

My report datasource retrieve many records (may be millions) and I want to paginate them to show only 10 records for example but always it shows data as 1 page with all data and I can not find any configuration in my report designer to handle this 

Thanks

Say I have a list of object and I want a field to show one specific value from those objects.

public class Data
{
  public List<Obj> Objects { get; set;}
}

public class Obj
{
  public string Name { get; set;}
  public int Id { get; set;}
}

Data reportData = [

     {Name: abc, Id: 4 },

     {Name: def, Id: 5 }

]

I want to show the Name (in a textbox) where Id = 5. How do I do that?

I tried doing it with a user function where I pass the array but it throws an error when I try to cast object back to Obj class that (webservice.jsonObject can't be cast to Obj class). If I can't cast the object to Obj class, how am I supposed to filter it?

Hi, 

We designed reports with parameters and table. as i followed this document link for sorting in table https://docs.telerik.com/reporting/designing-reports/adding-interactivity-to-reports/actions/sorting-action/sorting-table-details.  Which worked sorting in table. but issue is when i added report parameters to report sort icon not showing up and sorting not working. so could you please help me to resolve the issue as much as possible.

I have a use case of trying to make a report that displays tax statements for one or more accounts.  It essentially repeats the whole report for each account, appended together.  I fetch the account data from SQL using a JSON string report parameter.  The report has the following requirements:

Page headers and footers that display some basic report info labels passed in from the JSON string on each page of the report.  

Directly above and below the previously mentioned footers, an extension of these sections that displays more detailed information fetched from sql.  The extended header is pretty basic and can be the same on every page of the report.  The extended footer displays some info that is account-specific and additionally, dynamically shows a payment stub label and table if this is the last page for a specific account's statement (i.e., the detail section's grouped table finished printing on this page).

The detail section displays a grouped table for the account statement that may run across pages but must not push around the header or footer.

Additionally, after the last page of the account statement, there may be one or more additional pages printed with another grouped table about that account.  The layout at this point no longer really matters and any of the aforementioned sections and requirements could be left out.  We particularly would not want the payment stub footer displayed here if possible, or at a minimum have it be blanked out.

Note again that after the account statement and the optional additional pages are printed for an account, this whole procedure may run again for another account in this report which is then appended in this same pdf.

I have attached a basic wireframe to show our use case, since I'm aware this is a lot.  I have a suspicion that this is something that could be accomplished using group headers and footers but could use some pointers on how exactly to configure them to do what we want here.  I mostly have experience writing reports that rely on grouping data sourced tables within the detail section, but this doesn't seem good enough for this report since we need data within the footer which has to have static vertical layout on each page and also match up with which account the detail is displaying.  

I can think of solutions or workarounds for most of these problems, but the footer is especially concerning.  Any help that could be provided to solve at least that issue would be greatly appreciated!