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.