Hi Experts,

My customer needs a report like this(Please see the attached report). How to create something like this. I have all the Data. I am using ASP.Net, VB.Net and RDLC reports. Please help.

Thanks in advance.
BGMenu.png

I am trying to render a SSRS report to csv file, but for some reason  it comes out as TAB separated instead of comma separated.

This is the code:

            byte[] result = null;                  
            string historyID = null;                
            string devInfo = null;                
            string encoding;                      
            string mimeType;                        
            string extension;                      
            Reservice.Warning[] warnings = null;    
            string[] streamIDs = null;            

            _rsExec.LoadReport(rptPath, historyID);
           _rsExec.SetExecutionParameters(parameters, "en-us");
           result = _rsExec.Render("CSV",
                    devInfo,
                    out extension,
                    out encoding,
                    out mimeType,
                    out warnings,
                    out streamIDs);

                FileStream stream = File.Create(_excellocation, result.Length);
                stream.Write(result, 0, result.Length);
                stream.Close();

When I render to Excel there is no problems.
Thank you

I am trying to render report to csv file, but for some reason  when I open the file in Notepad looks like columns are separated by TAB , not comma. When I open the file in Excel all columns  come as one:
208438-1      7/11/2017      9:30 AM      Eric Sherman      Eric Sherman      "300 E 56th St

This is the code:
            byte[] result = null;                  
            string historyID = null;                
            string devInfo = null;                
            string encoding;                      
            string mimeType;                        
            string extension;                      
            Reservice.Warning[] warnings = null;    
            string[] streamIDs = null;            

            _rsExec.LoadReport(rptPath, historyID);
           _rsExec.SetExecutionParameters(parameters, "en-us");
           result = _rsExec.Render(_invoice.ExportFileFormat,
                    devInfo,
                    out extension,
                    out encoding,
                    out mimeType,
                    out warnings,
                    out streamIDs);

                FileStream stream = File.Create(_excellocation, result.Length);
                stream.Write(result, 0, result.Length);
                stream.Close();

Thank you

Hello,
i'have question about reporting service reportservices,I'm trying to connect to the reporting  web service sql server but an exception is raised, password or user are wrong error 401 unauthorized .
But i'm sure that they are correct this is how i use it :
I have imported a wsdl and i have got reportservice2005.pas.
Why i can't Authentify knowing that i can with browser how to use the methode LogOnUser() ? or THttpRio? to authtify.
this is the procedure i'm using :
procedure TfMenu.Button1Click(Sender: TObject);
 const
   defURL  = 'http://khali-pc:80/ReportServerSQL2016/ReportService2005.asmx';
var
   Report : CreateReport;
   ReportingService :  ReportingService2005Soap;
   stream           :   TFileStream;
   tailleBuffer,I     : Integer;
   UserLog          : logonUser;
   Rio1              : THttpRio;

begin
 
 Rio1 := THttpRIo.Create(self);
   Rio1.HTTPWebNode.UserName      := 'SomeDomain\SomeUser';
   Rio1.HTTPWebNode.Password      := 'xxxxxxx';

ReportingService := GetReportingService2005Soap(false, defURL, nil) ;

/////********** Second way to authenificate*********************// PS: and the first way to athentificate is to include password and user in RIO (THttpRio) above

/// second method to authetify to SSRS
//   UserLog                  :=       LogonUser.Create;
//   UserLog.userName  := 'SomeDomain\SomeUser';  
//   UserLog.password   := 'xxxxxx';
//   UserLog.authority     :='' ;
//   …

Guys,
There is one system stored procedure in Reportserver use to update the subscription where we can update the "TO" in the report delivery option.  but in our ssrs server I have almost 400 subscriptions that I need to delete old email address  and add new email address  at "To" field.
so instead of doing this one by on in SSRS - Report delivery option page, can I do this via bulk update T-sql in Reportserver db ? I provide a screenshot so you guys know where I means by "To" in report delivery option page in SSRS.

I have a Column that calculates Cost for each Record. I need to add a Column that has the Grand Total for all records to be used in a calculation.

SELECT  CASE WHEN ( SUBSTRING(Sea.seas_name, 1, 6) = 'SPRING' ) THEN ( 1 )
             WHEN ( SUBSTRING(Sea.seas_name, 1, 6) = 'SUMMER' ) THEN ( 2 )
             WHEN ( SUBSTRING(Sea.seas_name, 1, 7) = 'FALL 20'
                    OR SUBSTRING(Sea.seas_name, 1, 8) = 'FALL I 2'
                  ) THEN ( 3 )
             WHEN ( SUBSTRING(Sea.seas_name, 1, 7) = 'FALL 2 '
                    OR SUBSTRING(Sea.seas_name, 1, 7) = 'FALL II'
                  ) THEN ( 4 )
             WHEN ( SUBSTRING(Sea.seas_name, 1, 7) = 'HOLIDAY' ) THEN ( 5 )
             ELSE ( 6 )
        END AS SeasonNumber ,
            ISNULL(( SELECT SUM(total_qty) AS qty
                 FROM   zzxinvtr AS PrvIV
                 WHERE  ( division = SC.division )
                        AND ( style = SC.style )
                        AND ( color_code = SC.color_code )
                        AND ( lbl_code = SC.lbl_code )
                        AND ( dimension = SC.dimension )
                        AND ( DATEADD(dd, DATEDIFF(dd, 0, trx_time), 0) <= DATEADD(yy,
                                                              -1, '06/30/2017') )
               ), 0) * ( SC.std_cost ) AS PrvCost ,
            ISNULL(( SELECT SUM(total_qty) AS qty
                 FROM   zzxinvtr AS PrvIV
                 WHERE  ( division = SC.division )
                  …

Hi,
Please could someone help me write this expression (below) for an SSRS report? When I run this expression in the report it gives me an error saying that the field WIP_ADD_12M_CP is not contained within the current dataset or aggregate...but I've checked the fields and the spelling and it is correct - when running a simple divide it doesn't require the dataset name in there. Not sure why it is not picking up the field..? Does the syntax of this expression look correct? I am quite stumped at this point...

The code below is trying to:
1) Find where UBWIP_VAL_CP.Value is below zero and then make that field 499 and then divide the rest of the calculation x 365
2) Find where WIPADD_12M_VAL_CP.Value is below zero and then make that field 499 and then divide the rest of the calculation x 365
3) Code.divide gets rid of the divide by zero error. Find the overall sum where it is greater than 499 and cap the total to 499
4) Code.divide gets rid of the divide by zero error. Find the overall sum where it is less than 499 and cap the total to 499

The expression I have is:
=SWITCH
(
SUM(Fields!UBWIP_VAL_CP.Value) < 0, code.Divide(499,SUM(Fields!WIPADD_12M_VAL_CP.Value)) * 365,
SUM(Fields!WIPADD_12M_VAL_CP.Value) < 0, code.Divide(SUM(Fields!UBWIP_VAL_CP.Value), 499) * 365,
code.Divide(SUM(Fields!UBWIP_VAL_CP.Value),SUM(Fields!WIPAD‌‌​‌​​D_12M_VAL_CP.Valu‌​e)‌​)‌ * 365 > 499, 499,
code.Divide(SUM(Fields!UBWIP_VAL_CP.Value),SUM(Fields!WIPAD‌‌​‌​​D_12M_VAL_CP.Valu‌​e)‌​)‌​ …

I have a report and when I run the report , data looks good. However when I export it to PDF , Excel , Word or any other format  some of the columns are that have value and are  visible when viewing the report are missing data. I checked Hide property and it is set to False.

What could the issue be?

I was wondering if you  could help me with this issue.  I am working on security in SCCM 1610 to give certain users access to report information for  their specific department needs.    
I have created a test user, created Security Scope, made a copy of the Report Viewer Only role and added user to this security role.  I am happy with most of the access they are limited to.  
The only reports that I cannot restrict their access to are the MBAM reports.  The user is able to see all the collection ID's listed rather then just the collection ID for their department.   Is this because the MBAM reports are not native SCCM reports but added when installing MBAM on SCCM so the security policies don't applied to these reports?
Can you tell me how I can restrict these reports to only show information for the collection/collection id's they need to see?  
Thank you.

MLStev

I am actually looking for integrating SSRS to AD so all the access to the reports must be allowed windows integrated credentials (system login credentials). I mean reports URL should not ask windows credentials again, once user login to the domain.

I have an SSRS Report with a Matrix and a subreport.  I have my row group header property set to
KeepWithGroup = After
RepeatOnNextPage = True
however when my subreport continues on to the next page, I do not see my main report headers.
I have experimented with all different values of KeepTogether, KeepWithGroup, and RepeatonNextPage, but I can't get it to display.

Hi Experts,

I want to display the "number" with "Unit"  for ex. 12 oz. I am using the expression "=Fields!AdjustedPan.Value & Fields!Unit.Value" on that textbox. It displays 12oz. I need and space in between. So I tried ""=Fields!AdjustedPan.Value & "  " & Fields!Unit.Value". But It does not work. What can I do to give a space between the number and the unit. Also need a "." at the end( Like 12 oz.) .

Thanks in advance.

experts,

I have many sharepoint sites (3000+) that I'm  thinking about making use of the tasks lists. Each administrator has several hundred sites. Each admin could have a number of tasks spread across each of their sites. I'd like to give them a way to see all tasks that they have assigned to them across all of their sites instead of them having to visit every site to see what's assigned to them. Has anyone done anything like this before? What's the best approach to take? I'm toying with utilizing a SSRS report,  maybe a webpart, or maybe a custom application that queries the sites. I'm not sure though.

Any guidance would be much appreciated.

Thanks in advance,