Forum Widgets
Latest Discussions
Reporting Functionality | Power BI paginated Reports| SSRS
Hello, I need to create a report on Power BI paginated report which is similar to SSRS ,where I need to show a report as given below. From the report which I have created got the result as below. Now I need to generate a new column called TestNo column which need to be included in my result shown above. But it should be based on SDIDATAITEMID value which I have shown above. It should give me the values as TestNo 8043366 - 1 8043367 - 2 8043368 - 3 8043369 - 1 8043370 - 1 8043371 - 2 ,.... Likewise.... I can provide more info if someone could help me here.
Authentication error when refreshing SSRS 2019 report
We are encountering authentication issue when refreshing the report in SSRS web portal. Report Server is configured to run usingVirtual Service Account. In the RSReportServer.config file, RSWindowsNTLM authentication type is used. The report is connecting to the data source (internal product) using custom ADO.NET Data Provider. Data source is configured with "As the user viewing the report" credentials. Test connection works. When the user opens the report for the first time, report opens successfully. In our product log, we see that the connection was made using logged on domain user account. When the user refreshes the report after some time (3 minutes), report fails to load due to authentication error. In our product log, we see that the connection was made using service account (machine account of the SSRS server) and authentication fails because the service (machine) account is not allowed to access our product. The same configuration works successfully in SSRS 2016. Not sure why the report in SSRS 2019 is connecting to data source using service account instead of logged on domain user account even though it's configured to use the user account viewing the report. I have experimented with RSWindowsNegotiate and EnableAuthPersistence in RSReportServer.config. The issue still exists. Any help/guidance would be appreciated.
Backup and Restore of Native SSRS Site Restores as Sharepoint mode
I tried posting a similar message a couple of days ago but am not seeing it on the forum. As such I am reposting. I have a customer with an SSRS site that was setup with their original Dynamics GP implementation. We are in the process of moving them to a new server and upgrading GP. As part of the switch the reporting services site must also move over. I looked at their current Reporting Services Configuration manager and it showed setup in "Native" mode. But when I restored the database and attempted to set it up on the new server I received a message saying the database was in Sharepoint mode. Is there a way to set it up in Native mode? JG
ODBC driver problem
After changing the Microsoft Access Engine odbc driver from version 14 to version 16, I cannot connect to the excel file. I have a connection as follows: Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path.xlsx;ReadOnly=1;HDR=No; error with this is: ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks When switching to the OLE DB driver I get the error: Unspecified error On the Microsoft Access Engine version everything works fine. SSRS: Version 13.0.7050.2
SSRS SERVER DOESNT CONNECT TO ORACLE DATABASE
hello guys i did migration of the whole machine (ssis ssas ssrs, databases ..) to another machine everything worked fine for me except the ssrs server wouldnt connect to oracle database. the ssrs report works fine in visual studio and retrieve data from oracle correctly but when i deploy the dashboaed in the server doesnt work. and also i figured out that the server wouldnt connect to any other provider (oracle, odbc and oledb). do you have any idea guys ?Duplicating report without field references
Hi all, I'm fairly new to SSRS and this might be pretty simple but I'd greatly appreciate the community help. I'm working with a report which has a couple of Tablix referencing a number of different dataset fields in cells, column and row groups and parameters. I have to replicate this report but with a new data source and new data sets but I wouldn't want to build it from scratch. When I start replacing the fields in the Tablix and grouping I'm always hitting errors because at some point the former datasets fields are called from the report. So the thing is, is there a way to replicate/copy the Tablix structure without any referenced field and then start over with the configuration of the report with the new datasets? Or, can I somehow remove all the field references and keep the structure as it is? Any help would be highly appreciated. Thx!
SSRS report sum on visible expression value on Table
Hi Experts, I am trying to sum of visible expression Total days diff = 136+15+13=164 Total days diff expression is=DateDiff("d",Fields!PRWFDate.Value,Fields!POWFDate.Value) Total days diff expression for last row is=SUM(IIf(DateDiff("d", Fields!PRWFDate.Value, Fields!POWFDate.Value) <= 0, DateDiff("d", Fields!POWFDate.Value, Fields!PRWFDate.Value), DateDiff("d", Fields!PRWFDate.Value, Fields!POWFDate.Value))) giving value 43596446. I am trying to sum Total days diff = 136+15+13=164 than divide number of PO Id which is 3 than Average = (164/3)=54.66 The value 17.67 = 53/3 Thanks, Faizcannot cast nvarchar to numeric error
I'm getting the following error no matter what I do. I've casted all the columns to nvarchar in the sql query and the input parameter is text in SSRS and nvarchar(500) in the stored procedure. If I run the query/stored procedure it works fine. but if I run it in SSMS I get this error no matter what I do? What I have tried: 1. Casted all the select columns to nvarchar 2. the ssrs report parameter is "text" and the stored procedure parameters are numeric but casted as nvarchar 3. Some of the data has null rows would that cause this error? SQL (obfuscated of course) ALTER PROCEDURE SSRS_GetSomething @ListOfIds as nvarchar(500) AS BEGIN SET NOCOUNT ON; ---Check the string for multiple premiseid's and parse the string to convert from premise to numeric DECLARE @result as nvarchar(500) select TRY_CAST(id as nvarchar) as 'ID1',TRY_CAST(id2 as nvarchar) as 'ID2',streetaddress as 'StreetAddress',TRY_CAST([PossibleYear] as nvarchar) as 'Year',TRY_CAST(test2 as nvarchar) as 'test2',TRY_CAST(year3 as nvarchar) as 'Year3',TRY_CAST(numeric8 as nvarchar) as 'NumericColumn',TRY_CAST(numeric9 as nvarchar) as 'numeric9',TRY_CAST(numeric10 as nvarchar) as 'Numeric10',TRY_CAST(numeric11 as nvarchar) as 'numeric11',TRY_CAST(numeric12 as nvarchar) as 'Numeric12' from table1 b order by b.numeric1 desc,b.numeric2 , b.numeric3; END GO Error: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset datasource1. (rsErrorReadingNextDataRow) Error converting data type nvarchar to numeric.
Slow in report
i have one ssrs report i shared execution log3 performance for that report. my users complain the report take time to display around 5 min The report very simple and straight forword we have Microsft crm server and ssrs server and sql server all in same network please advise please What the issue
