Forum Widgets
Latest Discussions
Unable to download SSRS report builder
Is there any problem in downloading SSRS report builder ? Getting following error when trying to download. https://www.microsoft.com/en-US/download/details.aspx?id=53613 $set_redirect('https://www.microsoft.com/library/errorpages/smarterror.aspx?correlationId=$(cvToken)') Internal Server Error. The server encountered an internal error or misconfiguration and was unable to complete your request.
general design of a multi invoice report
Hi, i have a requirement to produce the report you see below in ssrs. Its basically 1 to n invoices based on a range (from and to) of invoice #'s that will be input as 2 parameters. The stuff hilighted in yellow is static info. everything you see from line 1 to line 23 should be repeated on each page for the same invoice. And a new invoice should start on a new page. Except for page number, all non heading info on lines 1 thru 20 represents header info that for a given invoice will be REPEATED on every row of the dataset. See the 2nd image for a rough draft of the dataset layout. Header info shows once on every page. Am i looking at a matrix with a report perhaps in the 1st cell? How would i ensure that each invoice starts on a new page? Is there a link to a "how to" to a similar requirement?
DataSet - How to retrieve values from grouped columns?
I have SQL which return data: SELECT dbo.TOWARY.TWR_NUMER AS INDEKS, dbo.TOWARY.TWR_NAZWA AS NAZWA, dbo.SL_JM.SLJM_KOD AS JM, SUM (dbo.WAZENIA.WZN_ILOSC * dbo.WZN_CNY.WZNCNY_NETTO) / SUM (dbo.WAZENIA.WZN_ILOSC) AS CENA, DATEPART(yyyy, dbo.ZAKUPY.ZKP_DATA_ZAKUPU) AS ROK, dbo.MAGAZYNY.MG_KOD AS MG_KOD, dbo.MAGAZYNY.MG_NAZWA AS MG_NAZWA, ROW_NUMBER () OVER ( PARTITION BY dbo.TOWARY.TWR_NUMER ORDER BY dbo.TOWARY.TWR_NUMER, DATEPART(yyyy, dbo.ZAKUPY.ZKP_DATA_ZAKUPU) DESC ) AS NUMER [ROK] - Year the number of columns is variable I grouped the columns by: year. I want to divide the years between them, e.g.: 2021/2020 2022/2021 2023/2022 (...) for rows (Example 20001): 0,61 / 0,64 0,74 / 0,64 But i don't know how take value from Column (Year)? %First / Last =(First(Fields!CENA.Value, "INDEKS")-Last(Fields!CENA.Value, "INDEKS"))/Last(Fields!CENA.Value, "INDEKS")
Issue: SSRS 2017 is opening more Oracle 19C database sessions and also not releasing them
We use SSRS to generate report in our applications. We have recently upgraded our SSRS from 2008 R2 to 2017 and Oracle from 12C to 19C. While doing this, we have noticed 2 problems: Problem 1: SSRS 2017 is creating more database sessions as compared to SSRS 2008 R2. (This can be checked using "Select * from V$SESSION" in Oracle). For e.g. for same report generation in SSRS 2008 R2, 2 database sessions were used to get opened. While in SSRS 2017, 10 database sessions are getting opened. Question: In SSRS 2017, is there any setting which defines that how many database sessions should be opened when we hit database? Problem 2: One database session is not getting released even after the report is downloaded and 1-2 hours have passed. (in SSRS 2008 R2, all database sessions used to get removed after 4-5 minute) Question: In SSRS 2017, is there any setting which allows SSRS to remove database session once report is generated?Where clause that looks up values from an outside source, using Report Builder in SSRS
First off, I apologize if this is posted in the wrong place, but I didn't see anything that was dedicated to Report Builder. Secondly, I'm in Finance and understand some level of SQL reporting so please bear with me on this question. I also realize that being within the corp walls, that my ask here might be something that I may not have permission to do, but I won’t know for sure until I attempt this. I use SQL Server Management Studio 19.3 to create my queries. Once I have my query where I want it, I launch Report Builder from SSRS. I do not see a version # for Report Builder. I copy my query into the SSRS report and then publish it (save it, etc). Example data: Table 2 has a field called “Username” I write lots of queries that ultimately end up being SSRS reports that rely on Table 2/Username. Many of these queries I hard-code in a list of Usernames. So, say I have 10 SSRS reports already created but then in the future the list of Usernames changes. It’s a pain to update all of the different queries/SSRS reports. Say my query looks something like this: Select t1.ID, t1.Field1, t1.Field2 From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID Where t2.Username in (‘Username1’,’Username2’,’Username3’) Is there a way to have the above WHERE clause look at another table where I store the values ONE time? Where I can manage that list of Usernames in ONE place? Basically ending up with something like the following? Select t1.ID, t1.Field1, t1.Field2 From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID Where t2.Username in Table3/External Source If so, I would appreciate any insight on how to accomplish this. The more detail the better as I am a novice at this. If you need more info, please let me know, but I believe this should cover what I’m after.
SSRS Measure aggregation
Hi community, It is my first post, so I'm working with report builder, I have a semantic model on power bi service so the report is live connection. In the model I have the dimensions and measures: dimension: Country, city Measures: stock, orders, avg sell this ultimate is actually: function ( orders , stock ). So in the report I summarized the measures with total. So the Sum function measures are OK, but the avg sell NOT(aggregation) the values are wrong, so which aggregate should be work? if the measure is operation between orders and stock Is it possible to use measures predefined in model? or do I have to make a custom measure in report builder (expression) ? thanks in advance.Navigate to different report from one SSRS Report
Sent by you: I have a Invoice SSRS report, for that I have format(SSRS Report) A, B and C, I want when user looking at format A then user should be able to switch to other format, here format means other report. although it is working fine in visual studio but when i added that report in CRM, it show this error: Details are not available because the subreport is missing. For help adding the subreport to Microsoft Dynamics 365, contact your Microsoft Dynamics 365 administrator.
Dynamic Connection String SSRS Report
Hello. I am creating a report where I want to have a dynamics connection string for based on a parameter for the Database Name. Error message I am getting is "Format of the initialization string does not conform to specification starting at index 25." Is the concatenation syntax wrong in the connection string? Can anyone point me in the right direction? Thanks!SSRS Report Server View Hidden Shared Data Source Folder
I would like to know if I could view the data source or connection string for those reports. Specifically, I am looking for information such as which databases and tables these reports are generated from, or the connection string itself. I can go to Report Manager and navigate to the report I want, then go to the Manage section. However, all I see is this: Is there another place where I can view or amend this data source/connection string? Could someone advise me on this, please? Thanks
