Problem Description:
Attempting to save changes to an existing dataset results in the changes not persisting.
Reproduction:
1) In the syncfusion report server, select the Dataset option from the Create menu.
2) Select some datasource and give a valid name and click Create
3) Drag some table into the center window and click save
4) Close this browser window
5) Select the dataset just created and click on the Edit option
6) In the sql code view, add a valid where clause for some column with a parameter for the expected value (ex: WHERE column1 = @column1)
7) Click Save
8) Close this browser window
9) Select the dataset just edited and click on the Edit option
10) Verify that the where clause added previously was not persisted
Looking forward to see your response.
Query |
Response |
Can you please explain the purpose of " default value for @<parameter>" while saving the query?
Also I wanted to know the difference between the default value of a parameter that is provided in the parameter window and the default value that is provided when we choose filter option to add parameter.
Looking forward to see your response.
|
Parameter window is invoked for code view to get the default value of a parameter since if your query has similar below statements then it will throw error while saving with null value hence we will get default value before saving the query.
“SELECT *
FROM [dbo].[L_TRANSACTIONS] WHERE (([dbo].[L_TRANSACTIONS].[TRANSDATE] >= dateadd(year, -1, concat(@YEAR, '-07-01'))) AND ([dbo].[L_TRANSACTIONS].[TRANSDATE] <= concat(@YEAR, '-06-30')))” Where as the filter option to add parameter is for design view and it is not applicable for code view.
|
I have few other concerns related to report server loading after I have replaced the files as part of the resolutions to the reported issues. Can you please schedule a call tomm. so that I can explain better and know what is the cause ?
I am available 8.30 am CST to EOD tomm.
|
Sorry for late reply.
We are unable to schedule the meeting for today immediately considering other meetings and engineer availability. We will schedule the meeting for tomorrow (March 13, 2019) at your requested time.
Please confirm your availability so that we will create a new incident under your account related to this forum to share the meeting link. |
Has the call been scheduled? We are not able to load report designer to create the reports. Please have this call scheduled to let us know what is causing the report designer loading issue. |
I really want a good reasoning on default parameter value when it is part of filter window and when it is part of parameter window on save. Please let me know why is this default parameter value required and where it goes once i provide that value as part of filter window and parameter window. |
We have shared the details for this query in incident #230501.
In addition to that for filter window and parameter window values are used to preview and retrieve the data field from SQL Table for query parameters. Internally we did not hold any place this value, but it requires to pass the parameter values into SQL input parameters like as below code snippet to retrieve the table fields while save the dataset.
So that, we are asking/showing input parameter dialog to get default value while processing the save action based on query parameter, if query contains any input parameter. |