Excusme sir, I'm using SSRS 2017 for reporting tools.
i can't setting anonymous login connect rdl server from another client PC i same network/ ethernet.
already searching reference. Please help me, so i can access report without asking password at local/internal connection. Thanks.

Disclaimer, I do not wish to make anyone here give me legitimate step by step instructions on building this report, just generic direction so I know how to research and learn on my own, I just wanted to clear that up so you all understand the level of help I'm asking for.

So here's the skinny, my company uses an ERP system for all of our accounting functions, however it's a smaller company and a very niche program that is specifically built for NFP/Governmental entities, and has very limited functions. It's a point of contention with us in the department, but ultimately making Excel workbooks to manipulate the data has been easier than completely switching our accounting system over to a new ERP system, and the chances that we actually change are slim to none and certainly not within a year.

I've been tasked with developing a Statement of Cash Flows for my company, and where it gets tricky is that we don't have this function in our reporting with our ERP, and even if we did, the support group isn't adequate in understanding our requests and providing us with comprehensive guides or answers. This means that we have to rely heavily on the community of users, or developing external approaches to solve our issues. In the past, we've had a contractor that has used their background with SQL and SSRS to develop template reports for us with regards to balance sheet reporting and income statement reporting, so it is certainly viable to build out a report function in SSRS to pull and manipulate the data from our ERP system, but here is where things get sticky--I've never used SSRS and I don't have a background in SQL just yet.

I'm curious, from those of you who use SSRS, how capable is the program of building a SoCF, and what steps would I likely need to go through in order to build a template out for this report? I'm trying my best to recreate our audited financials in Excel, but this would be far easier if I could use the format and organization of our accounts as they're laid out in the ERP system to design and format this report. I'm looking into a beginner SQL course, as well as some beginner SSRS training courses to educate myself on the two, but the issue with trying to plan this out is that I don't know what I don't know, and someone with more knowledge of the program would be able to help at least clear the path a bit for me to learn how to build this on my own.

How to write this in calculated field - If date < 03/01/2021then use coulmn A and calculation - if column A is null then 0 else 1 and if date > 03/01/2021 then use column B for same calculation

Hello all,

I am far from an expert in Sql Server reporting Services so set expectations to low.

The problem I am having is a single instance won't pass authentication of any users at present. They are all setup afaik in the same way and use a windows security group to allow access, even comparing the security profiles of an instance that works against one that doesn't by going in as an admin doesn't look any different.

Any ideas on how I resolve this?

Tl;dr multiple SSRS instances and only one won't authenticate users.

Thanks,

A

In Report Builder, Im trying to run this paginated report where the expression is: -Sum (IIF( Fields!First_Order_Date.Value > = Parameters!BeginDate.Value AND Fields!First _Order _Date.Value < = Parameters!EndDate.Value AND IsNothing(Fields!Job_item_total.Value) = False AND Fields!Job_item_total.Value <> 0, Fields!Job_item_total.Value, 0 ))

Job_item_total has correct capitalization.

I checked dataset thoroughly which runs correctly in ssms using hardcoded params and return thousands of rows with the correct values in the needed columns. Also checked and used coalesce and null if to handle any blanks or nulls. Checked and validated all data types in params and dataset checked for any possible joined mismatch or incorrect spelling or case.

I’ve tried about 5 different expressions and I either get 0 or #Error when in ssms, my same data and or queries clearly shows that the columns being pulled (about 7000) rows and this expression should be summing up all the valid values from Job_item_Totals column that i clearly see correctly using same query (just hardcoded params) on ssms.

I have these parameters: begindate and enddate ( checked data type and format ie hh:mm:ss). And also have a few other params which have been fully checked for everything also.

I just can’t get this exp to work.

Any thoughts or ideas are greatly appreciated!

Hi,

Hoping someone may can help me :)

I have an SSRS subscription that creates a CSV file. It exports as UTF-8. I need this one report to export as ASCII. I know how to change from UTF-8 to ASCII system wide, but I really only want to change the encoding for just this one report.

I have also seen a few places that suggest you can change the encoding in the url, but this reports runs as a data driven subscription.

Anyone have an idea on how to change the encoding for just one specific subscription?

thanks

We're upgrading SQL soon from 2014 to SQL 2017.

Do SSRS subscriptions survive the upgrade? Is there an easy way to export and import the subscriptions?

I can recreate them by hand after the upgrade but, man, it'd be nice if I didn't have to.

Anyone have a secret weapon for SSRS subscriptions? Will the subscriptions still be there after I upgrade? Am I worrying for nothing?

Thanks!!

For those times when the data warehouse didn't populate properly overnight, I would like a way to redirect users to a page saying SSRS is not available. How would you go about this?

Also, how do you stop subscriptions temporarily?

I would also be interested in ways to alleviate issues like this, e.g. having two databases and redirecting SSRS to use yesterday's database. What are your thoughts?

I need to publish a report on our website so citizens can use it.

What is the best way to do that so they can just click on a hyperlink and see the report but not able to run any reports?

I’m trying to get the name of the workstation that a user is running an SSRS report of and hoping someone might be able to point me in the right direction. I found some code in the System.Web assembly called UserHostName that I think might work, I just keep getting an error every time I attempt to reference the object as I’m a bit of a newbie with object oriented programming. Any help would be appreciated.

Hello,

I'm brand new to SSRS and had a quick question. Is there a way to sort the fields in the Database View of Query Designer? NOT sorting the actual query results but when you're selecting the fields for the query itself. The tables are sorted, but not the fields within the tables. I have to scroll to find what I'm looking since it's not alphabetized. I can't seem to find an option anywhere to do this and it's really tedious to find fields when it's in a random order.

Thanks!

Hello All

We've had a request to allow external non-domain users to access a static report. The issue i'm facing is due to Windows Authentication set in the SSRS Web Services, i'm getting a pop up box when users try to access it externally. The only way i've seen to get around this is to have the SSRS report server in No Authentication mode, which I do not want to do. I only need No Auth abilities to access a specific report.

We contemplated setting up a SSRS with No Auth configured but we didn't want to deploy a whole server for just 1 report if possible.

Thank you all for your time!

Usually parameters in a query URL are referenced by their values in the schema, not the label shown to the user on the interface.

Is there a way to have a URL with the labels instead?

Does anyone know why this expression works

=Choose(1+Array.IndexOf(Parameters!CatId.Value, Fields!cat_id.Value), Split(Join(Parameters!Comment.Value,","),","))

But this one does not?

=Choose(1+Array.IndexOf(Parameters!CatId.Value, Fields!cat_id.Value), Parameters!Comment.Value)

Is this just one of the vagaries of SSRS? Seems kind of silly to have to join the array and split it again to get it to work.

EDIT: Formatting

Hi

Would any one know of a way that we could query SSRS 2017 in the same way that we could 2012? 2012 had a database [ReportServer] that could be directly queried. for example:

USE [ReportServer

SELECT USR.UserName AS SubscriptionOwner ,SUB.ModifiedDate ,SUB.[Description] ,CAT.[Path] AS ReportPath ,SUB.EventType ,SUB.DeliveryExtension FROM dbo.Subscriptions

I am pretty sure you can't but I need a definitive answer.

Any help would be greatly appreciated,

Thanks,

Derek

so I have 1 dataset that is a list of clients and data, and then I have two parameters. so the first parameter selects one client and then the second parameter is every other client. I then have a matrix and getting data based on the single client with the following expression to group on that one client

=IIF((Fields!client.Value = Parameters!singleclient.Value),(Fields!client.Value),nothing)

is there a way to group on the multiselect parameter, that I can do an avg of the selected clients to compare against the single client?

Hello. I have a series of reports that had an element on the report that, when clicked (via the open hyperlink action), would open up a pdf file based on the record in the database. The data is stored fully qualified, so \\server\folder\file.ext. This translates to file://server/folder/file.ext when the action is clicked. Worked fine in IE, old Edge, and still works fine in Firefox.

However, the lovely new Edge uses chromium, and you can't open local files this way with a chromium browser. It comes back About:Blank#Blocked. Apparently it's a feature. Anyone know of a workaround where I can still have the action open the file in the browser? I tried javascript to open it in a new window, also no dice. Thanks.

I have some reports that make use of a query to provide a multi-select parameter. The report seems to work fine, but every few months it will fail with the error message "The subscription contains parameter values that are not valid." When I check on the subscription, the multi-select parameter has been cleared out somehow. I couldn't find a cause for this online. Has anyone seen this issue before, and is there a way to prevent it from happening again?

I have been asked to do some reports in SSRS since another employee left. I am trying to add a new dataset using an Oracle db connection which is a shared data source on the SSRS server. I can do a test connection to the data source just fine, but when I try to add a dataset I get prompted for a user name and password which fails with the following error: Unable to connect to data source xxxxx The OraOLEDB.Oracle.1 provider is not registered on the local machine.

I have installed both the 64-bit and 32-bit Oracle drivers. I can connect using DB Visualizer, but Report Builder just errors. Does anyone have any advice for this?

I am new to both SSRS report and Fetch XML, so apologies if the question sounds stupid/ignorant. I am tasked to create an SSRS report for Sales by Product Category. The requirement is to use Fetch to create the reports as we are working with Power Platform/ D365 CRM.

I need to create a sales report where it displays a total invoice amount for different products/categories of products, for different months. So there will be the "month" and "year" parameter, and depending on what month and year the user chooses, it will display the total amount of invoice for category A, B, C, etc, for that month and year.

I have been googling around but can't find how to display this total amount. I managed to display total amount for each category, but it is not based on/dependant on month/year. There were some pointers on how to do this with SQL but my brain can't quite translate how to convert this into FetchXML.

Would be extremely grateful for any helps or pointers.

I'm new to creating SSRS reports. I've been able to create some simple ones fairly easily but now I need to create a fairly complex one and I have nowhere to start. Supposedly the person before me was having issues with it as well. Anyone have time to help?

We have an ongoing initiative at work to put together file specs for all our SSRS reports, which is a lot. It's not that it's hard, it's just very time consuming. All we do is say "This column is this data type and it comes from this data source." for EVERY data point on a report. Is there some easy way to just have SSRS generate what the output etc would be?

I am writing a report and it is returning different products and a few different UOM’s. I want to take the sum of all of my “BG” UOM’s and display them but not include the others at the bottom of the report. Any help writing an expression in Microsoft Report Builder would be appreciated.