Permission issue but i can't figure it out

when we upgrade the report to our new server the xml export stopped working.

I've been trying t troubleshoot but since i'm not to familiar with xslt transformations i'm having a hard time finding the problem.

I think the problem is with name spaces.
if i use this code i got from here i can get the entire xml to export
</xsl:template>
    <xsl:template match="node()">
        <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:apply-templates select="node()"/>
        </xsl:copy>
    </xsl:template>

but when i try to match a specific node it fails.

my original xml without the transformation comes out like this:
<?xml version="1.0" encoding="UTF-8"?>
<Report xmlns="Logos_x0020_Export_x0020_Report" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="Logos_x0020_Export_x0020_Report http://reportserver?%2FLogos%20Export%20Report&rs%3AFormat=XML&rc%3ASchema=True" Name="Logos Export Report">
   <Tablix1>
      <Textbox15>
         <Textbox19 />
      </Textbox15>
      <Group2_Collection>
         <Group2>
            <Group1_Collection>
               <Group1 Group1="PB2017-1886&amp;#xD;&amp;#xA;">
                  <NamePaidby1 NamePaidby1="INTERIOR ENVIRONMENTS&amp;#xD;&amp;#xA;48700 ADDRESS City ST 111111" PaymentType="Check Number: " CheckNumber="30000" TotalAmount="167.00">
                     <Details_Collection>
                        <Details Description="Initial Plan Review Fee" …

For example as per attachment, i would like a  function that looks at a single occurrence of females first on the management level field and Gender field and gives an additional column a label for example VP Black women, and at the same time look at the occurrence of both male and female and the management level and gender field and give a label/column field of for example VP Black. I would like to use this label or column in SSRS to show a field grouped by females only and a combination of males and females. Your assistance will be highly appreciated.

for example, the query i had in mind would go like this. Excuse i am a complete novice

select [Management level],[gender],[Corporate grade]
case when patindex(%Black%,[Management level]) AND patindex(%Female%,[Gender key]) the 'VP Black women' else 'VP Black'

Hello,

How can I force language report server 2016 culture fr-fr. Report Server has been installed on server 2012 US, regional settings are french. But some reports display date in format En-US.
I try the following without result :
UPDATE dbo.Catalogue
SET Property = N'<Properties> <Language>fr-FRLanguage> </Properties>'
WHERE CAST(Property AS NVARCHAR(MAX)) = N'<Properties> <Language>En-US</Language> </Properties>'

How can I resolve?

Thanks

regards

Hello,

We have a system displaying some reports from SSRS, however since most of the users are using Chrome they cannot see the datepickers in the report viewer so they type the dates by hand, leading to format errors.

The MSSQL is version 2012 Web Edition SP3 x64.

Is there a way to fix the issue?

P.S. Upgrading the server is not an option due to licensing issues.

I have a TFS   2010 and SP 2010, sql2008r2 report server in SharePoint integrated mode  Whenever I try to create a new project it fails and get the message :

TF218027 This operation is not supported on a report server that is configured to run in SharePoint integrated mode

See screenshot

I don't believe this is a permissions issue, As I have created many projects in the past using the same credentials.

I am aware that you can use Report Services Configuration Manager to change the DB to native mode, but I have many projects set up with the current DB in integrated mode and I dont want to cause issues with them.

We a planning to migrate to the latest versions of sharepoint and TFS but we cant right now.

I am just trying to create a new project the must be a way to do this.


Thanks

Hello,

I was greeted this morning with reports of many SSRS subscriptions not running. When I checked, it's because the username of the owner has been changed (due to marriage). I have changed owners before but I can't get SSRS to even recognize the new username (when I look in the ReportServer.dbo.Users table for either name, only the old one comes back.

How do I get the owner to change to the new username so the subscriptions can be run again? I can't find anything definitive on Google about it. I did change a registry setting (LsaLookupCacheMaxSize) but I don't see where that's had any effect.

I could change to generic account but this user actively manages these subscriptions, so I need to assign it to her new username.

Thanks!

The first query needs an additional column that shows the blocking text...but I eliminate that from the where clause...so am thinking I need a union...or some other outer query.. please help.  I have put a 2nd query below that will return the blocking test.
I need to unify this logic into one output.

select sp.spid,sp.blocked, sp.last_batch,sp.waittime,sp.waitresource,sp.lastwaittype,sp.cmd, DB_NAME(sp.dbid),
st.[text],sp.loginame,sp.hostname,sp.cpu
from sys.sysprocesses sp
cross apply sys.dm_exec_sql_text(sp.sql_handle) st
where sp.spid>50 and sp.spid<>sp.blocked and sp.blocked<>0 and datediff(mi,last_batch,GETDATE())>2
---final touch for sending mail notification when blocking duration goes above 2 Minutes

Select all Open in new window

2nd query that does get the blocking text I am after...but  I need it an aditonal column in the above query.

select qt.text as [blocking text]

FROM master.dbo.sysprocesses sp
LEFT JOIN sys.dm_exec_requests er
    ON er.session_id = sp.spid
OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) AS qt
WHERE spid IN (SELECT blocked FROM master.dbo.sysprocesses)
AND blocked = 0

Select all Open in new window

I have an SSRS 2012 report that has multiple columns, and has a group by employee name and week
One column is a calculated column on the aggregate by week. So I have this expression in the "week "group row.
=IIF(sum(Fields!Regular.Value)<=40,0,IIF(sum(Fields!Regular.Value)>40,(sum(Fields!Regular.Value)-40),0))

I do need to sum that column at the employee name group level. I've tried different things and don't get the expected results. In excel is very simple as I can simply sum that column....Ideally, I get this calculation in the SSRS report.
I've search for a couple of days and nothing works.
I've attached my report output.
Thank you for any help you can provide.

Hi , When i'm downloading the excel file,i'm getting following attached error.How avoid this error

XML file output


<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error042240_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\abc.com\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\PGARRIST\Report_Isys.xlsx'</summary>


-<additionalInfo>

<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>

</additionalInfo>


-<removedParts summary="Following is a list of removed parts:">

<removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 1, column 267478.</removedPart>

</removedParts>

</recoveryLog>
1.png

I have a SSRS List report that is only displaying the first record of each Group (24). My SQL query shows 501 records.
I am using a Subreport to grab the data of the Group. Any Suggestions? This is a super rush..
subMOR.rdl
MOR_Test.rdl