1. Home
  2. Forum
  3. Report Platform
  4. Report Server Web Designer
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Report Server Web Designer

Hi Support Team,

i) How could i overcome my problem when i use parameter with date but my variable is the String , on your Syncfusion Dashboard Designer we could change it at Data Source ? My question is how could i  convert String variable into Date on Web Report Server ?

ii) Why did when execute my report thru Chrome my report is looking for my Data Source Login if i execute from Notebook i will be able to input the password but if use on my iphone chrome, On IOS it will not popup keyboard to keyin the user login, i question is how could my user execute my report without knowing datasource password ?

iii) i attach my sample Cashbook_bayaranBeta1.rdl for you to check where i might make mistakes.

iv) Why did when design the report using Client Report Designer upon updates to Report Server , i could not edit again by using Web Designer ?

Thank You Very Much,

Best Regards,

Hidzir Adam
Kuala Lumpur




Attachment: CashbookBayaranBeta1_6b64b9aa.zip

18 Replies
VS Vinoth Srinivasan Syncfusion Team January 22, 2018 02:10 PM UTC

Hi Hidzir, 

Thanks for your interest in Syncfusion components. 

Query 
Response 
How could i overcome my problem when i use parameter with date but my variable is the String , on your Syncfusion Dashboard Designer we could change it at Data Source ? My question is how could i  convert String variable into Date on Web Report Server ? 
You can use SQL convert() function in your dataset query to convert the string value into date format. Please refer the below code snippet. 
Convert(datetime, [t_t_tran]) 
hy did when execute my report thru Chrome my report is looking for my Data Source Login if i execute from Notebook i will be able to input the password but if use on my iphone chrome, On IOS it will not popup keyboard to keyin the user login 
Currently, we are having support to render the report in Notebook and we are checking the compatibility with iphone chrome. Meanwhile, could you please share the snap of the rendered output with us. 
i question is how could my user execute my report without knowing datasource password ? 
You can use shared datasource or embed the user id and password into the connection string itself to render the report without providing datasource credentials at client side. 
Why did when design the report using Client Report Designer upon updates to Report Server , i could not edit again by using Web Designer ? 
Currently, our web designer doesn’t support the Tablix, map, indicator and gauge report items, also we have documented the limitation in the below location, 

Our web designer will ignore the unsupported items and renders the remaining items in report. The shared report contains the Tablix report item and that is unsupported in Web ReportDesinger, so the Tablix not opened to edit in web control. We will provide the web designer with full compatible features to work with all the report items before end of 2018. 
 

Regards, 
Vinoth S. 


HA Hidzir Adam January 22, 2018 04:34 PM UTC

Hi Mr Vinoth Srinivasan,

hy did when execute my report thru Chrome my report is looking for my Data Source Login if i execute from Notebook i will be able to input the password but if use on my iphone chrome, On IOS it will not popup keyboard to keyin the user login 
Currently, we are having support to render the report in Notebook and we are checking the compatibility with iphone chrome. Meanwhile, could you please share the snap of the rendered output with us. 

I attach my screen shots from my Iphone when i execute my Reports.

Thank You..

Attachment: image_iphone_d5c6defc.zip

HA Hidzir Adam January 22, 2018 05:09 PM UTC

Dear Mr Vinot,

i question is how could my user execute my report without knowing datasource password ? 
You can use shared datasource or embed the user id and password into the connection string itself to render the report without providing datasource credentials at client side. 
I just try out the solution that you informed, i just embed but this next when i preview via Designer (Client) i got the results publish, but unfortunately after i save the reports  on the Report Server Directly , my parameter was correctly display either on Notebook or iphone, I could select the dates & Location but the results is empty no data was selected. Is there anything that i miss out on my reports ?

I  also attach my screen recording on two files, one files is from my Report Server Directly i'm using Report Designer(Client) and second video files is during executing on remote notebook , parameter is correctly display but no results was display.

Thank You,

Best Regards,

Hidzir Adam
Kuala Lumpur



Attachment: Video_Recording_d418dc75.zip

VS Vinoth Srinivasan Syncfusion Team January 23, 2018 12:42 PM UTC

Hi Hidzir, 

From your shared video we can see that different date format has been used in report designer and  report server. The report designer has the format DD/MM/YY as same as the data stored in your database table. But the report server has the format MM/DD/YY, due to this the data is not filtered properly in our report server. Please refer the below image. 
 

We request you to maintain the same culture in data and report server to filter the data properly in sql query execution. You can convert to specific culture using style in the convert function (CONVERT(varchar, '2017-08-25', 101) ) or you can set the culture to report viewer component so that it will render the datetime picker in required format. Please follow the below steps to render report parameter based on locale culture in your Report Server Application. 

1.Ensure to stop the Report Server application from the desktop shortcut – “Stop Syncfusion Report Server”. 

2.Download your required culture script from the below link. 

3. Paste the downloaded culture script into the below location. 
{{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ Scripts\EssentialJS\i18n 
 
4. Refer the pasted file in the “i18n” folder to “ReportViewer.cshtml” file like below from the below location. 
{{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\Views\FileRender 
 
 

5. Now set the locale property in ReportViewer control render page that is “ReportViewer.cshtml” page like below, 

  

6. Start the Report Server Application from the desktop shortcut – “Start Syncfusion Report Server”. 

Note: Here the highlighted need to be given based on the required culture. 

Regards, 
Vinoth S. 


HA Hidzir Adam January 23, 2018 02:10 PM UTC

Hi Vinoth,

I'm sorry can't download at  https://www.jsdelivr.com/projects/syncfusion-ej-global error ' 

This site can’t be reached

The webpage at https://www.jsdelivr.com/projects/syncfusion-ej-global might be temporarily down or it may have moved permanently to a new web address.

ERR_SPDY_PROTOCOL_ERROR

Thank You..


HA Hidzir Adam January 23, 2018 05:15 PM UTC

Hi Mr Vinoth,

I'm sorry this round i'm not successful after you give the instruction . "report server has the format MM/DD/YY, due to this the data is not filtered properly in our report server". After edited my Dataset which i insert the  convert function (CONVERT(varchar,[t_t_tran],101) ) within my sql but  I'm still can"t access my data . So i attach my dataset  sql command and also edit version of   “ReportViewer.cshtml”  for you to assist me in examine the file.

My appreciation for all those  assistance that have being very supportive.

Thank You very much.

Hidzir Adam
Kuala Lumpur.

Attachment: 135542_9a965414.zip

VS Vinoth Srinivasan Syncfusion Team January 24, 2018 03:04 PM UTC

Hi Hidzir, 

You are converting the string column in the database to specific date format, in SQL convert the string not converted properly so the data not filtered in report server. So, we suggest you to convert the parameter based on the date format given in your database column using the below expression. 

="SELECT  RptCaseActivities_Activities.DefendantName ,RptCaseActivities_Activities.ActivityDate  ,RptCaseActivities_Activities.ActivityTypeName,RptCaseActivities_Activities.ActionTaken FROM   RptCaseActivities_Activities where RptCaseActivities_Activities.ActivityDate=" & Chr(39)  & Format(Parameters!dateparameter.Value,"dd/MM/yyyy") & Chr(39) 
 

Regards, 
Vinoth S. 


HA Hidzir Adam January 24, 2018 07:19 PM UTC

Hi Vinoth, Good Day,

I'm sorry to disturb you once again,  what you mean i need to "convert the parameter based on the date format given in your database column using the below expression. 
="SELECT  RptCaseActivities_Activities.DefendantName ,RptCaseActivities_Activities.ActivityDate  ,RptCaseActivities_Activities.ActivityTypeName,RptCaseActivities_Activities.ActionTaken FROM   RptCaseActivities_Activities where RptCaseActivities_Activities.ActivityDate=" & Chr(39)  & Format(Parameters!dateparameter.Value,"dd/MM/yyyy") & Chr(39) 

What i do i insert it at Dataset Properties  in Query parameter  Values .. and I replace the name parameter   (Parameters!Transaksi1.Value,"dd/MM/yyyy") & Chr(39) , but it unsuccessful on both at design client & Report Server as well, or i place this expression at wrong place ?

Thank You Very Much,

Best Regards,

Hidzir Adam
Kuala Lumpur




VS Vinoth Srinivasan Syncfusion Team January 25, 2018 05:56 AM UTC

Hi Hidzir, 

Please find the below snapshot for inserting the expression in dataset properties. 

 

You have to provide the date format as per the date format used for the field [t_t_tran] in your database. If you still face any issue then if possible could you please share your dummy data values with us. It will be helpful for us to provide the solution at the earliest. 

Regards, 
Vinoth S. 


HA Hidzir Adam January 26, 2018 01:01 AM UTC

Hi Mr Vinoth,

For my outstanding issues I'm sorry my  hands up to you because after getting the feedback from you, i'm still failed on resolving it. I appreciated your offer to continue assisting my "If you still face any issue then if possible could you please share your dummy data values with us. It will be helpful for us to provide the solution at the earliest". So i already compile zip file which content my dummy data and also sql schema of my database. 

Thank You Very Much,

Best Regards,

Hidzir Adam
Kuala Lumpur

Attachment: 135542_6411d43d.zip

VS Vinoth Srinivasan Syncfusion Team January 26, 2018 11:02 AM UTC

Hi Hidzir, 

We have modified the shared report and we have used SQL convert query to format the [t_t_tran] data field into date format. The report filters the data properly based on the dates in both report designer and report server. We have prepared a video based on this and it can be downloaded from the below location. 


Also, please find the modified report from the below location. 


Regards, 
Vinoth S. 


HA Hidzir Adam January 26, 2018 07:17 PM UTC

Hi Mr Vinoth, My apologies again if i did not get your instructions correctly, my report still facing the same problem even thought i just copy the sample report file which i download. I could execute the sample report on web client correctly but on Report Server its not successful.  On my original report also i did follow the format to convert dates as you mention to me as below ;
SELECT [t_t_tran] ,[t_ref_no] ,[t_keterangan] ,[t_amaun] ,[t_nama_ruj] ,[t_nama] ,[nama_pp]  
 FROM [txnlogSelangor].[dbo].[txnlog] as T, [txnlogSelangor].[dbo].[ref_code] as R  
where Convert(datetime,[t]. [t_t_tran]) >=@Transaksi1 and[t]. [t_t_tran] <=@Transaksi2
  and T.t_kod_caw = R.kod_pp
  and t_kod_caw like @KodPP
  and t_kod like 'SB001'
  order by t_t_tran,t_kod_caw

Mr Vinoth, can you please test with your  dummy data by select the Start Date above 12th assume on Jan 13 to Jan 26. On your video show your selection date is between Jan 4 to Jan 8 only. What i notice the that t_t_tran will select correctly if the dates that we selected within the month is 1st-12th only for Jan, from my observation if i mean Dec 01 - 12/01/2017 - the report will assume Jan 12 instead.

I felt very bad by coming back to you with unsuccessful result, I hope you are fine with my feed back to you. If you think that it is troublesome and  i need to change my data format at database level, i have figure out alternative by presetting the selection of start date and end date by using your parameter specify value, by using this  format the enduser don't have the flexibility of choosing their exact range of dates.

You did mention this on your note "We have modified the shared report" what does this mean ? 

I leave it to you whether  we could continue to resolve this issue or come to the end, i consent that it could burden you or your teams. 

I have enclosed my two video one from web client and second video is accessing the from remote.

Thank You Very Much, I real appreciated your assistance to me.

Best Regards,

Hidzir Adam. 

Attachment: Hidzir_135542_747622f6.zip

VS Vinoth Srinivasan Syncfusion Team January 29, 2018 12:34 PM UTC

Hi Hidzir, 

From your shared video we can see that different date format has been used in report designer and  report server. The report designer has the format DD/MM/YY as same as your machine culture. But the report server has the format MM/DD/YY, due to this the data is not filtered properly in our report server. So, could you please provide the machine culture you have used and we will provide a localization script to resolve this issue. 

Regards, 
Vinoth S. 


HA Hidzir Adam January 29, 2018 03:03 PM UTC

Hi Mr Vinoth,

I enclose attachment which i capture from Server Regedit .. Hope this information that you required.

Thank You Very Much.

Best Regards,

Hidzir Adam
Kuala Lumpur

Attachment: culture_setting_8f6d615c.zip

VS Vinoth Srinivasan Syncfusion Team January 30, 2018 11:23 AM UTC

Hi Hidzir, 

Please follow the below steps to render report parameter based on locale culture in your Report Server Application. 

1.Ensure to stop the Report Server application from the desktop shortcut – “Stop Syncfusion Report Server”.  

2.Download your “en-MY” culture script from the below link. 


3. Paste the downloaded culture script into the below location.  
{{InstalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ Scripts\EssentialJS\i18n 

4. Refer the pasted file in the “i18n” folder to “ReportViewer.cshtml” file like below from the below location.  
{{InstalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\Views\FileRender 

 

5. Now set the locale property in ReportViewer control render page that is “ReportViewer.cshtml” page like below, for example “en-MY” 

 

6. Start the Report Server Application from the desktop shortcut – “Start Syncfusion Report Server”. 

Note: Here the highlighted need to be given based on the required culture. 

Regards,  
Vinoth S. 


HA Hidzir Adam January 30, 2018 11:29 AM UTC

Hi Mr Vinoth, Very Good Morning,

Thank you shortly i will try it out. 

Best Regards,

Hidzir Adam

HA Hidzir Adam January 30, 2018 03:08 PM UTC

Dear Mr Vinoth,

Awesome , This time i'm successfully running my report correctly either from web client or Report Server.

Thank You very much and appreciated your valuable continuous supports.


Best Regards,

Hidzir Adam     

VS Vinoth Srinivasan Syncfusion Team January 31, 2018 05:04 AM UTC

Hi Hidzir, 

Thanks for your update. Please let us know if you require any further assistance on this. 

Regards, 
Vinoth S. 


Loader.
Up arrow icon