New answers tagged ssrs
Working with this setup: CREATE TABLE tbl ( tbl_id serial PRIMARY KEY , user_id text NOT NULL , start_time timestamp NOT NULL -- if values could be NULL ... , end_time timestamp NOT NULL -- ... it would be more complicated ); Total duration without redundancy Your numbers indicate you just want the total duration without counting ...
You only have to run in Administrator mode because you haven't added any users to SSRS. You need to grant permissions. For example on the root folder in SSRS add a windows user/group to the Browser role. For more details see https://technet.microsoft.com/en-us/library/ms156014%28v=sql.110%29.aspx
Is the new user allowed to send mail on the SMTP server? You can do this: Review this and make sure your setup is valid with the correct user (MSDN Link). Also check the settings in RSreportserver.config (MSDNlink).
Go to Programs and Features, find the Microsoft SQL Server 2012 (64-bit) entry, select Uninstall/Change, and then select Remove in the window that pops up. You select the instance you are working with: Then check Reporting Services you installed:
Unless you have data in your SSAS cubes that no longer exists in your source (if this is the case correct that going forward!) then you can simply install a new instance of SSAS then deploy and process your SSAS solutions from SSDT (the 2012+ replacement for BIDS). For SSRS if you have a basic install you can do the same thing - simply install the new ...
This turned out to have nothing to do with the Microsoft side at all. The data source we are using is a linked server to Proficy Historian and, by default, only pulls 5000 rows. You have to explicitly tell it either how many rows you want to pull, or tell it RowCount = 0 for unlimited rows. Sorry for the noise! enter link description here
Top 50 recent answers are included