How to add the textbox values of columns? these textboxes are not the part of the dataset. I have tried several options but something seems to be missing.

tried #1
=sum(ReportItems!Textbox22.Value)
Error: aggregate functions can only be used on report items contained in page headers and footers

tried #2
=RunningValue(ReportItems!Textbox22.Value,Sum,"Dataset1")
same error as above:   aggregate functions can only be used on report items contained in page headers and footers

tried #3
I wrote a vb function like this given in this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/002c459a-2260-437a-a53c-a380bc2299d0/sum-column-gives-error-aggregate-functions-can-be-used-only-on-report-items-contained-in-page?forum=sqlreportingservices

Public Total_lookup_Sum As Integer = 0
Public Function Lookup_Sum(ByVal value As Integer) As Integer
    Total_lookup_Sum = Total_lookup_Sum + value    
    Return Total_lookup_Sum
End Function

and then wrote this expression:
=Code.Lookup_Sum(Reportitems!textbox22.value)

the output shows me the last value of the textbox instead of aggregating all the textbox values.

if I write the expression
=Code.Lookup_Sum(Reportitems!textbox22.value)
=Code.Total_lookup_Sum

the output shows true a boolean value.

I tried cint also but no success.

I can't use =sum(Fields!......Value) because textbox is not the part of the dataset.
I can't hardcode like textbox1.value+textbox2.value.

I have googled a lot of …

SQL command text property value is invalid multipart name select . It occurs when I have the stored procedure and running the query to obtain data. I cannot view the data so I can see whether my paginated report in SSRS report builder is capturing the data I would like

I am needing to deliver some js files to a desktop application that runs in a browser shell.  The reason I am doing it this way is I don't have a web server.  This has been running successfully for months until recently the cdn references to libraries like jquery no longer consistently download each time the app opens.  The app is running on windows 7 and uses IE 11 for the shell.  In replacement of a web server I thought about using SSRS since we have a db server.  I can't get the dba to turn on iis on that server as well but thought about placing the files on ssrs and then pointing the script tag src to http://ssrs-server/ReportServer?/Apps/Libraries/jquery.min.js.  When I test this I see the reference to the file in the temporary internet files folder so it appears to download but the initialization in code of jquery fails as if it were not available.  So maybe I don't fully understand what is being listed in the temporary internet files folder and how the app uses the js file from this location.  Does anyone have any suggestions as to what may be wrong or it there some type of conflict with ssrs in the opening of the file.  I can click directly on the file listed in ssrs in the folder view and it opens like a hyperlink showing the js file content.  Thanks for your input.

I have manually edited an rdlc report script to add 3 new columns to the rdlc report. I did this by making sure the data retrieval query contains the columns and by
manually adding a <fields></fields> entry for each new column in the rdlc script. The new columns do not display on the report but rather a blank space shows on the report where the new columns should be. I searched Google and determined that I may need to rebind the data source. However, all the information on rebinding that I found uses a report design tool. How can I rebind the new fields without using a report design tool?

How do I custom sort the legend of a PIE chart in a SSRS report? I want the elements in the legend to appear in a very specific order that defines business process. Any help is appreciated.

Please setup a filter with the following criteria and save it. Name the filter:  Tony’s tasks this month

Assigned to:   Me (Tony)
Updated date:  This month

Grouped by: State
Sorted by Parent, then by custodian

Bonus points for sharing the filter with my manager, Jonny Lee

How can we improve SSRS performance?

My NAHost is 2016 vm, 4 CPUs, 16GB, 60GB free.  I started w/SQL 2016 Express SP2, then upgraded to SQL Developer SP2.

When I click on a report it takes 10 seconds to start doing something, 15 seconds before the SSRS header comes up, and another 15 seconds before it renders data.

Upgrading to SQL Developer allows for more memory to be consume by SQL server, but no real improvement on SSRS performance.
I don't have a lot of demo data, so it should be faster.

Any thoughts on increasing SSRS performance?

I have .rdl files which I have added into the reports in the solution explorer and then I have datasets in the report data. On the basis of datasets when I preview I get some options to select and then I am able to get the data fetched from the database (ssrs). I need to generate a table when I select options while previewing. I am getting data from 2 tables. I know there can be various ways to approach this. I might need to write expressions in the reports or some other way. Can anyone help me getting started with how to build dynamic tables in reports?

I'm running Power Bi Reporting Service 2018 Version 1.2.6648.38132

The problem I am running into is when running scheduled subscriptions, only 1 subscription can be run at a time.

When starting the subscription manually through the SQL Agent (while the other one is running), the status of the subscription goes directly to: The report server has encountered a configuration error.

I notice that the SQL Agent is starting the job, but it does not seem to trigger the Reporting Service to run the subscription. (Image attached)

Do you have any suggestions?



See the error message in the attached file.
ssrs---schedules.jpg
SQL-Agent-vs-SSRS-Job.jpg

Parameter configuration in ssrs.    The dataset is configured with a normal query joining two tables.  At the end of the dataset is where i have a question.  it includes a where and "and" statement

Currently it is configured like this

Where a.rescode = ''
and a.adddttm > @conversion      -  This is a date field

How to i configure the variable to be one of the two choices instead of always Greater than  (user supplied date)


Where a.rescode = ''
and A.adddttm > @conversion

or

Where a.rescode = ''
and a.adddttm < @conversion

ASP.NET C#
I'm trying to view ssrs report in reportviewer in webpage
got an error
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
 pointing to this row:

 <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

Select all Open in new window

my aspx code:

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WEB_ONE1.WebForm1" %>


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Height="484px" Width="737px">
        </rsweb:ReportViewer>
    <div>
    
    </div>
    </form>
</body>
</html>

Select all Open in new window

my cs code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using 

Select all Open in new window

…