Reporting Services :: SSRS Loses Ability To Delegate User Credentials To Database Time To Time?
Apr 30, 2015
we have problems with our SQL Reporting Service 2012 (SSRS) server . We have setup Kerberos delegation between SSRS and the database server (SQL Server Always-on cluster) so users are authenticated down to the database. The issue occurs from time to time that SSRS loses the ability to delegate the user credentials to the database. At this point in time the Report Server logs contain rejected database connections because of ANONYMOUS logon. After restarting SSRS the problem is gone.
View 2 Replies
ADVERTISEMENT
Aug 7, 2007
Hi all,
I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.
I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.
For example if the date is August 07, 2007 10:00 AM UTC,
then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.
Similarly for other Time Zones it should display the time accordingly.
Is this possible in SSRS 2005?
Any pointers will be usefull...
Thanks in advance
sudheer racha.
View 5 Replies
View Related
Jun 19, 2015
We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.
I've few options down...
1. Directly point to OLTP database as source and write stored procedure to show result set.
2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.
3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.
View 3 Replies
View Related
Oct 22, 2015
I am using the following function to set the time format, however I now need to to add an IF statement into this equation.This is the current expression I am using:
=Floor(Fields!ACD_Calls.Value / 3600) &":"& Format(DateAdd("s", Fields!ACD_Calls.Value, "00:00"), "mm:ss")
Now I need to use the following expression with this:
=IIF(Parameters!ReportType.Value="Average", Sum(Fields!ACD_Calls.Value)/CountRows(), Sum(Fields!ACD_Calls.Value))
How do I join the two together?
View 4 Replies
View Related
Oct 7, 2015
SSRS 2012 Login prompt during runtime?I've already did some work arounds that we're posted here but still doesn't solve the login prompt.
View 5 Replies
View Related
Aug 20, 2015
How do we convert int datatype to "time format" like hh:mm:ss
ex: 123092 ( this 12 + 30 min + 92 sec)
131137 ( 13 + 11 min + 37 sec)
111747 ( 11 + 17 min + 47 sec)
View 5 Replies
View Related
Oct 21, 2015
I defined my input parameter as date/time but it doesn't have a time picker where we can accept user input.
The calendar is great but time picker is missing.
Is there any add-in or tweaks I can use to get that feature ?
The alternative solution which uses drop down with some preset values are not feasible for me. All I need is just the time picker similar to adjust time in Windows.
View 4 Replies
View Related
Oct 6, 2015
displaying time interval on y -axis for an ssrs report.
the values are static... it should start from 00:00 - 23:59 with 00:30 interval....
interval of 30 mins...
I tried several functions that are available but didnt work.
View 6 Replies
View Related
Jun 17, 2006
After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation.
The problem on one machine does not cause a similar problem elsewhere at the same time (hence it appears to be an issue with the relationship between the application and SQL Server)
This does not appear to relate to the response to Q asked by sgcook on 9 may as we are not using user instances, but only a bare minimum connection string.
View 15 Replies
View Related
Sep 24, 2015
How to achieve by using SSRS. How we can "quick run" report within the subscription menu to ensure report was set up correctly during creation. Is there any way to generate sample subscriped report without waiting for scheduled time.
I mean whether we can verify the report parameters & data in generated the report. I have verified SSRS report manager .i cant see any button or option to test run the report in subscription feature.
View 6 Replies
View Related
Sep 14, 2015
At the moment I already added the DataSet I'm gonna be using. I have 2 date parameters Start Time and End Time.
What I would like to do for the report is to only pull results greater than 48 hours to the report
How can I accomplish this?
View 4 Replies
View Related
Jun 2, 2015
I want to create a datasource but the credentials I want to use will be based on the user running the report rater than hard coded.
I have tried using Windows Integrated Security but all i can is cant log in as NTAnonymous User?
View 8 Replies
View Related
Mar 12, 2008
Hi all,
I am using client reports and SQL server 2005. I have created reports that accepts datasets and displays in the reports. I am also displaying the client's product image in the reports.
The problem I am facing is this.
When I export the report to excel for the first time every thing is fine. The issue is when I export after the second time.
From the second time whenever i export the report to EXCEL, I see that the second excel sheet does not follow the same alignment and format the first one had.
View 7 Replies
View Related
Nov 7, 2007
Firstly sorry if this already exists but I can't find it the answer anywhere.
I'm running Visual Studio 2005 Reporting Service. I have a SQL query which is reutrning a count of second which I need to display in HHH:MMS format.
integer value = 144322 which is displaying as 16:05:22 or 02/01/1900 16::05
the end result needs to be 40:05:22
It is quite visable what SQL is doing but I am having big issues around how to reach the result.
Any help much appreciated.
SUM(Call_Length) AS Total_Talk_secs,
DATEADD(second, SUM(Call_Length), '00:00:00') AS Total_Talk_Time,
View 4 Replies
View Related
May 6, 2008
Hello,
We are using Reporting Services 2005 with large amount of data.
Our reports displays the data in various presentation (charts, tables, Images and matrixes).
Sometimes the underline queries takes a lot of time (few algorithms implemented by SQL and few by web services).
We tried to run the reports in various scenarios and we are getting a timeout n each of the scenarios:
1. Running the report with windows application (based on Report Viewer control)
2. Running the report via subscription.
We noticed than the timeout occurs after about 20 minutes.
WE changed the following parameters:
1. The system timeout in the report server database: 60000
2. Reports execution timeout (site level): Do not timeout report execution
3. Reports execution timeout (report level):
a. Do not timeout report execution
b. A very big number
View 1 Replies
View Related
Oct 22, 2015
I am trying to load previous days data at 3 am via a SSIS job.
The Date variable is initiated as DATEADD("dd",-1, GETDATE()) in the for loop.
Now, as this job runs at 3 am, and I set the variable as GETDATE() - 1, it excluded the data from 12 am to 3 am in the resultset as Date is set as YYYY-MM-DD 03:00:00:000 I need this to be set as YYYY-MM-DD 00:00:00:000
How can i do this?
View 2 Replies
View Related
May 17, 2005
Hi all!
If I have some mdx I'm using in reporting services like this:
select
{ [TimeByMinute].[All TimeByMinute].[2005].[May].[1] : [TimeByMinute].[All TimeByMinute].[2005].[May].[6] } on columns,
{A_list_of_measures } on rows
from ACD_Calls
The column names are unique to the day of month- which means when I use a table to display this in reporting services, the field names change dynamically when the date parameters change which means the table stops working.
I'll post this in reporting services too but I thought maybe I could alias the column names in mdx shielding the reporting services table from changes in dates.
What do you think? Would a matrix be more flexible in this case?
Richard
View 7 Replies
View Related
May 9, 2008
I have a very basic report, pretty much just spits out the results from a storage proceedure. When I just run the stored proceed it takes about 36 seconds to run, and returns 532K records. When i run the report it takes a little over three minutes. The SQL Reporting server is on a seperate box, but its database resides on the same system as the database in which i am reporting up against. Any thoughts on what I could do to improve speeds on the reporting side I would appreciate it. Running SQL 2005 SP2, the report just takes in a date for a parameter and spits out financial holdings for that particular day.
View 5 Replies
View Related
Jul 13, 2015
There's a new SSRS 2012 environment which was setup with My Reports folder to each user enabled. I know I'm supposed to see a Users Folder in the Report Manager root, I'm setup as a system administrator (under Site Settings) and also have content manager rights in the root directory and I still don't see the "Users Folders" ...the only way I can see that is if they give me admin rights in the server SSRS is installed. What am I missing here, is this supposed to be like that?
View 5 Replies
View Related
Jul 21, 2015
I need to know is there any way to end user customization with SSRS, we are using ASP.Net page, we need to create SSRS report with end user customization like mail merge, but we don't want end user to use Report Builder or Report Designer.
View 6 Replies
View Related
May 12, 2015
I have a problem with Date/Time parameters. When I try to preview reports locally, I get the following error message for dates past the 12th of a month:
An error occured during local report processing. The value provided for the report parameter 'Date' is not valid for its type.
My report is set to de-CH. If I enter a date into the datepicker in Swiss/German format (dd.mm.yyyy) Visual Studio changes them to mm/dd/yyyy but somehow tests them against dd.mm.yyyy and throws an error.
Windows language is German, SQL Server and Visual Studio are in English.
I installed the German language pack for Visual Studio and switched over to German to no avail. Changing the report language to en-US did not work either.
View 5 Replies
View Related
Oct 22, 2015
I am trying to do an IF statement based on the parameter (Average or Total). However I am struggling with how to put the two together.
=Floor(Sum(Fields!Avg_ACD_Time.Value)/ 3600) &":"& Format(DateAdd("s",Sum(Fields!Avg_ACD_Time.Value), "00:00"), "mm:ss")
=IIF(Parameters!ReportType.Value="Average", Sum(Fields!ACD_Calls.Value)/CountRows(), Sum(Fields!ACD_Calls.Value))
View 5 Replies
View Related
Jun 2, 2011
SSRS 2008 R2. I am writing a report that uses a DB4 database. Because of this many SQL commands that I normally use are not available and I don't know what commands I can use. Because of this I am doing much of my calculations inside of SSRS.
I need to round a time field to the nearest quarter hour inside of SSRS.
For example:
8:12 becomes 8:15
2:30 becomes 2:30
1:57 becomes 2:00
4:07 becomes 4:00
View 9 Replies
View Related
Apr 26, 2015
I have a situation
1. I have a parameter @Param1 that accepts multiple values
2. I have to display data based on selected values of @Param1
Here comes the tricky part.
3. I have to aggregate on all the available values of the @Param1
Do I need to take a hidden parameter just for aggregation? Or is there any other way?
View 3 Replies
View Related
Dec 27, 2006
I noticed that the Reporting Services is taking longer to open in the morning or after a period of time in-active. My guest is that the SSRS is set to idle/stop after certain time when it is in-active state and it will take time to start the Reporting Services when it is activated. My question is how to make SSRS active all the time ie never go to "sleep". What is the Pro and Con of this approach? Thanks.
View 1 Replies
View Related
Oct 6, 2014
I've migrated a server with SQL Server 2008R2 and Reporting services into a new box with SQL Server 2014, but forgot to change the timezone to the correct one. I've changed it later, but it seems like the reports are running by the old default timezone. The schedule says that the report should run at 6:30am, but the Last Run column shows 8:30 PM.
I need to fix it without manually updating each subscription with some date/time conversion.
View 1 Replies
View Related
Feb 19, 2008
I am trying to generate a report that is basically a class list. It lists classes for a specific semester and lists them by day of the week and then by time.
If I am pulling back a dataset of all classes, how do I filter my report so as to show each set of classes appropriately (by day and by time within the day)? I tried using the Filter function on the table level, but I guess I don't get it.
My table would need to look like this:
MONDAY:
8:30 - 9:30
9:30- 11:30
11:30-1:30
classnum/prof
classnum/prof
classnum/prof
classnum/prof
classnum/prof
classnum/prof
TUESDAY:
8:30 - 9:30
9:30- 11:30
11:30-1:30
classnum/prof
classnum/prof
classnum/prof
classnum/prof
classnum/prof
classnum/prof
View 4 Replies
View Related
May 26, 2015
How to delete a single record from 2 tables at a time.
View 3 Replies
View Related
Sep 24, 2015
ExecutionTime gives server time, How can I get local time ? I'm planning to create a report part and use it across all the reports to display report execution time.
- Reports are being opened in Citrix
-MS SQL Server 2008 R2
View 3 Replies
View Related
Jun 1, 2015
Need to display current time in below format:
06/01/2015 at 7:00 a PST
(Date at time TimeZone)
View 2 Replies
View Related
Nov 21, 2007
Hi,
I am using Sql REporting Services 2005 for viewing reports in my web application. I have to change the chart types at run time basesd on the option. User can select any chart eg. bar chart, pie chart, column chart etc. On selection screen should populate the chart type. I am not able to change chart type at runtime. Help please.
Thanks
Shraddha Tripathi
View 2 Replies
View Related
Nov 21, 2007
Hi ,
I am using sql reporting services 2005 for viewing my reports, Now i want to change chart type of my report according to diffrent selection, there will be pie chart, coulmn chart , bar chart or many more options resides in my web application and according to user selection , chart of that report should be change.
Please help me out.
Thanks and Regards
Shraddha Tripathi
View 1 Replies
View Related
May 5, 2015
In VS2008 SSRS, when creating a dataset, only the name of the stored procedure was required. When populating the dataset, VS prompted for the parameters, whether or not there were any. In VS2010, the name of the stored procedure is not enough if there are parameters.When creating a dataset in Visual Studio 2010 for databases and stored procedures in SQL 2012, I must provide (what should be) run-time parameters to obtain a field list and then to preview the report.
So the embedded dataset looks like this (wherein the only parameter is a password): exec dbo.spu_procedure1 @PW='999'.This works well and as expected during report design and development. But 999 must be provided at run-time by the requester, and not in the dataset definition. If I remove the parameter in the dataset's exec string before deploying the report, the field list is cleared and the report is unusable. So I cannot overcome what seems a contradiction: necessary to obtain a field list, but "yet-to-be-provided" when the user selects the report.
By keeping @PW='999' in the dataset specification, the user cannot override the parameter and automatically has a password to view the report.
View 3 Replies
View Related
