Parameter Slow And Page Refresh
Apr 8, 2008
Hi,
I have a problem with the parameters in SSRS2005.
In fact I have for example a parameter month on a MDX request (See below). When I change the value in the listbox, Reporting services post the page and I am waiting 3s before to click on "view report"
Do you have an idea why this post is called ? For me there is no reason !!!
WITH
MEMBER [Measures].[ParameterCaption] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]
} ON COLUMNS ,
ORDER(
[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].[CAL - Mois].MEMBERS,[Measures].[ParameterValue],DESC) ON ROWS
FROM ( Select ( filter([DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].[CAL - Jour].ALLMEMBERS,
CDate([DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].Properties( "CAL - Date" ))>= CDate(vba!format(vba!day(vba!now()),"00") + "/" + vba!format(vba!month(vba!now()),"00") + "/" + vba!format(vba!year(vba!now())-2,"0000"))
AND
CDate([DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].Properties( "CAL - Date" ))<= CDate(vba!format(vba!day(vba!now()),"00") + "/" + vba!format(vba!month(vba!now()),"00") + "/" + vba!format(vba!year(vba!now()),"0000"))
)) ON COLUMNS
FROM [TDB MENSUEL])
View 1 Replies
ADVERTISEMENT
Jan 3, 2007
I am trying to find a way to implement a page refresh using an SQL Server procedure for an HTML Page. The user will indicate the time for refresh and this would be genereated using the stored procedure..any ideas?????
View 2 Replies
View Related
Mar 26, 2008
Hello. Is there any way to stop the web page from refreshing when selecting a date from the calendar control in SSRS 2005? I've done some digging around, and the only 'fix' found so far is to set the default date values from a dataset; which I've done, but Im still seeing the same results. I have a Start and End date parameter, both defined as datetime parameters, neither have any dependencies on any other report parameters, no cascading between any parameters in the report....nothing; as generic as it comes. I see there is an onclick Javascript event firing everytime a date is selected from this control. Is this what is causing the page refresh? Is there no way to turn this behavior off?
Thanks
View 11 Replies
View Related
Apr 18, 2006
Hi All,
Is it possible to refresh the web page when certain table data is updated? And I cannot use the auto-refresh feature. Thank you very much.
View 1 Replies
View Related
May 5, 2004
Hello,
I have a table which gets updated roughly every 6 seconds with data. I have setup an aspx page with a datagrid to meta tag refresh every 3 seconds.
Because the data sometimes stops for a couple of minutes or even hours, I was thinking of a way to update/refresh the aspx page only when the table data gets entered ( to stop page flickering every 3 seconds).
I was thinking about a stored procedure and using an on update procedure.
Does anyone have any preffered methods or suggestions on the best way to accomplish this task.
I use VB.Net
Thanks
Goong
View 2 Replies
View Related
Mar 14, 2006
I have added a page refresh in combination with 'Command Notification' to ensure that my data is fresh,( it is updated on the sql server database approx. every 5 mins).
However, I also allow filtering on the table contents and every time I refresh the filtering is lost. Is it possible to maintain the filtering through the refresh?
<meta http-equiv="refresh" content="30"/>..<asp:SqlDataSource ID="SqlDataSource1" runat="server" ..SelectCommand="SELECT ... EnableCaching="true" CacheDuration="Infinite" CacheExpirationPolicy="Absolute" SqlCacheDependency="CommandNotification" >
View 1 Replies
View Related
May 20, 2008
Hi, I have an OLAP data source that includes a date field "DateLongName" (has format e.g. May 08, 2008) , on which I checked the box when setting up the data set to indicate it is a parameter. This of course creates the attendant MDX data set that can be used for available values so that the user can pick from the various dates to choose the date they want to filter data on. So far so good.
Also in this report I have a relational data source that populates a chart that I would like to update when the user chooses the date from the above OLAP data source.
My thoughts were to create another MDX data source (called DayConstraint) like
SELECT {} ON COLUMNS, (STRTOMEMBER(@DimDateDateLongName,CONSTRAINED)) ON ROWS FROM [DailySalesCube]
Then, for my relational source, it would just be Select * from table where date=@DayConstraint
Nice in theory, but the DayConstraint variable doesn't change when the user changes the value in the olap picklist. So, the "DateLongName" has a default of previous day, so if it was May 8th, both the "DateLongName" and "DayConstraint" show May 7th. But, when you pick a different date (from the available values when the report has ran), say May 6th, the "DateLongName" changes, but the "DayConstraint" doesn't update, so of course my relational data set doesn't update.
If I pull in the DayConstraint data into a text box to look at the value (=First(Fields!Date_Long_Name.Value, "DayConstraint")), the data set is updating correctly when one changes the values in the OLAP pick list. Wish there was some way in my relational query to do something like Select * from table where date=Fields!Date_Long_Name.Value, "DayConstraint", but can't see anyway to make this work.
I am starting to think you can't use cascading parameters like this - can anyone confirm this, and if I am trying to do the impossible, any ideas on how this could be done in another fashion? Have been beating my head against the desk for a couple days on this, so any help would be very much appreciated.
Thanks!
View 1 Replies
View Related
May 2, 2008
Hi,
I'm still quite a beginner with the Report Designer and now I have faced a problem. My goal is to make a reports refresh each time it is loaded. I know that this can be done by using rs:clearsession = true-method but in order this to work, it should be added to each link. There are a lots of links in the reports we are using and therefore it would be more practical to find another way to refresh the report on page load. Is there any way to do this with some kind of code attached to each report? I'm using Visual Studio 2003 and my Reporting services 2000.
View 4 Replies
View Related
May 13, 2007
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.
Is this possible?
Regards Andreas
View 1 Replies
View Related
Apr 20, 2015
Is it possible to set the parameter option to "Select all" after the options in the parameter have been filtered by another parameter? For example:
Parameter Area contains Europe, North America, South America.
Parameter Country contains the country's that are in Europe, North America and South America.
When the Area Parameter is set to Europe, the country parameter only contains the country's that are in Europe. When you want to see the complete dataset in the report again, you change the Area Parameter to Europe, North America and South America again, and press view report.
Then the Country Parameter only has the country's that are in Europe selected, so the dataset is still filtered to the European country's. Is it possible to automatically set the country parameter to select all after the Area parameter has been se back to all Area's again?
View 3 Replies
View Related
Apr 4, 2008
I am creating an RS with four parameters -
Parameter 1 = Date Period ex. 20081102
Parameter 2 = Start Date ex. 11/02/2008
Parameter 3 = End Date ex. 12/02/2008
Parameter 4 = Description ex. Period 20081102
For Parameter 2 and 3 it will have available values in a Date Range
ex. for Period 20081102 it will have a date range
for Parameter 2 = from 10/02/2008 - 12/02/2008
for Parameter 3 it will have from 11/02/2008 - 12/02/2008
The process flow goes like this:
1. I'll select value from parameter 1
2. Automatically parameter 2,3 and 4 should display corresponding values.
3. It works well on first try
4. if i'll try selecting another value for Parameter 1,
5. As expected it should display again the corresponding values for the 3 parameters but Parameter 2 is retaining the value for the previous Parameter.
Why is it happening?
Does it have something to do with the date range?
How does the sequencing for RS happens?
This scenario happens when date ranges for each Date Period have common values.
View 4 Replies
View Related
Nov 15, 2006
I have one aspx page that is very slow loading it is connected to SQL 2005 database. I am looking for any preformance tips out there
View 3 Replies
View Related
Jul 25, 2006
Hi all,
I have a webpage with a Datagrid that populates using a table adapter from a Stored procedure that exists in my SQL Database...If I run the Stored procedure in SQL Directly then it takes 20 Secs to return all records...If I run the webpage then it takes just over 20 Secs..
Great you say..But If I have the sorting option set in ASP.net and I click on a column to sort then off the page goes for another 20 secs to sort the data..
Is there a better way to do what I am doing here that will speed up the page load..
Ie..the data is returned once and then sorted...
Is it Better / Quicker for me to create a table using the stored procedure and link to this from the website..Updating the table every couple of minutes ?
Any advice please ?
Ray..
View 4 Replies
View Related
Dec 5, 2006
I have developed a stored procedure that filters a view that is a union of several different tables. This provides status information for items across our warehouse management system. This system seems to work very well and normally processes results very quickly (< 3 seconds). However, occasionally (every few days) we begin to see timeouts on the query after 3 minutes of processing. I can watch this process in SQL Profiler and see that the query is timing out after 180 seconds, which is the timeout we have for the query within the DAL. When I copy the line from the SQL Profiler and execute it directly in SSMS, the query executes in less than 2 seconds. I first thought that somehow this had to do with execution plans, but when I try to reload the page again, which executes the query, it still times out. I did add a OPTION(KEEPFIXED PLAN) to the sproc, and that seemed to speed things up for the time, but I am not sure if this is even the problem and what the optimal solution would be. Any thoughts spring to mind?
Thanks, Steve
View 3 Replies
View Related
Jun 18, 2007
I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.
Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.
As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.
I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break?? I've seen a lot of posts on this, but none that seem to have an answer.
View 3 Replies
View Related
Dec 28, 2006
Creating a web application. Running a simple query "SELECT username FROM vwCustomer"
vwCustomer is a view built on top of an Access DB which is set up as a linked server. Within SQL Server that view responds immediately. But when I try to access it from an ASP page it takes over 20 seconds to respond.
Used the following to create the linked server:
EXEC sp_addlinkedserver 'DBName', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:databasesdatabase.mdb'
GO
EXEC sp_addlinkedsrvlogin 'DBName', FALSE, NULL, 'Admin', ''
GO
The view is simply(this works fine in SQL Server):
SELECT * FROM DBName.db.dbo.customer
The ASP page:
SELECT * FROM vwCustomer
Can anyone give me a hint as to where the bottleneck is? Or how I can figure that out using SQL Profiler or something?
Please help!
View 3 Replies
View Related
May 28, 2015
I have a procedure that calls a SVF to convert an xmldocument. The ultimate purpose is to update the xml in a column in a multi-million row table. The xml is stored as varchar(MAX), it was supposed to carry any type of text, initially at least.
My question is: why is the xml-parsing performed inside the function much slower when i pass the xmldocument as type xml than when it is passed as varchar(MAX) and the CAST to xml is within the function? Does processing the xml input parameter in SlowFunction involve expensive crossing of some context border?
The two versions of the SVF (they return the rowcount in this simplified example):
CREATE FUNCTION [dbo].[FastFunction]
(
@inDetaljerText varchar(MAX)
)
RETURNS int
[Code] ....
The two versions of the SP
CREATE PROCEDURE [dbo].[FastProcedure]
AS
BEGIN
SET NOCOUNT ON;
select
dbo.FastFunction(al.Detaljer)
[Code] ....
View 2 Replies
View Related
Jul 23, 2005
Is it possible and how do I do use a select like query with an adocommand's parameter object?For Example:Instead of this:command.CommandText = "SELECT * FROM Table WHERE field LIKE'%searchString%'This:command.CommandText = "SELECT * FROM Table WHERE field LIKE '%?%'command.Parameters.Append(command.CreateParameter ....Thanks
View 3 Replies
View Related
May 9, 2007
The date format in the 'weekending' textbox is 5/5/2007Here's what I've got:
With cmd.Parameters.Add(New SqlParameter("@SQLweekending", SqlDbType.DateTime, weekending.Text))the error message is:"Conversion from string "4/8/2007" to type 'Integer' is not valid."
Then, I tried:.Add(New SqlParameter("@SQLweekending", SqlDbType.DateTime, CDate(weekending.Text)))but, before I even tried it, it gave me a blue squiggly line, with an error message:"Error 2 Value of type 'Date' cannot be converted to 'Integer'"
How can I get this to work?
View 3 Replies
View Related
Feb 1, 2007
i have a sqldatasource on my asp.net page -- select * from table where id = @id
i want to set the @id in the backend and set the result to textbox1.text
how do i do this?
View 1 Replies
View Related
Sep 19, 2007
My stored proceddure "My Programs" includes a parameter @meid.How do I code an aspx file to run the procedure with a user ID, e.g. EmpID?I tried the following codes, but the error message indicated it can not findthe Stored Procedure. How do I pass the EmpID as a Stored Procedure parameter?
<%meid = EmpIdcmd.CommandText = "MyPrograms meid"cmd.CommandType = CommandType.StoredProcedurecmd.Connection = sqlConnection2sqlConnection2.Open()reader3 = cmd.ExecuteReader(meid)While reader3.Read()sb.Append(reader3(i).ToString() + "......<BR> <BR /> ")End While%>
TIA,Jeffrey
View 3 Replies
View Related
Aug 14, 2007
I pass in 3 querystring parameters to my web form. The Object Data Sources pick up these parameters
and select the appropriate records.
I want to display one of the querystring parameters in my Page Header, specifically the one for Fiscal Year.
I could return the Fiscal Year in a column from the data source, but the Fiscal Year would not populate if
no records were returned...Therefore, I must get the querystring parameter that was originally passed in...
How do I populate the report control textbox with the value of querystring parameter?
Thanks!
Jim
View 14 Replies
View Related
Oct 30, 2007
Hi,
i am working on SSRS 2005. i have one problem while accessing report throgh ASP.net pages.
i have used multivalue parameters in the report. on the report server it works fine but on the .asp page when that report is accessed, drop down is not working,
can anybody guide me regarding this , what to do?
thanks and Regards,
Vishruti.
View 1 Replies
View Related
Feb 21, 2008
Hi All
i have created one report using SSRS 2005, in this report one parameter is multivalue parameter, this report preview working fine and user able to select multivalues. but the problem is i deployed this report in server and opened in client system (reports shown to user using report viewer in aspx pages), i am able to access the report but multivalue parameter dropdown is not working.
when i clicked on multivalue parameter dropdown report refreshing and remaining parameters default vaues coming up..
i am unable to find the solution
please anyone help me
thanks
View 3 Replies
View Related
May 1, 2007
Hi !
I have a problem with the unique identifier and don't know how to solve it.
I have a stored procedure, called from my ASP.NET page, which inserts a new record into a table. I need to get the Id of the row just inserted in order to use it as a parameter of another stored procedure which inserts a new row with this value and other values.
I tried with SCOPE_IDENTITY but i don't know how to ask for this value to the first stored procedure and stored it into an ASP variable.
Dim cmd As New SqlCommand
cmd.CommandText = "Insertar_Contacto"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = connect
Thanks!!
View 2 Replies
View Related
Jun 1, 2015
Is it possible to have different chart (having their dataset from same shared datasets) like six on one report, then secondly can they all respond to same parameter filter.
View 3 Replies
View Related
Mar 9, 2015
I created the report, which has 4 pages. Each page contains bunch of tables and charts, which display data in scope of dataset, created for each page and reflecting certain subject. Each page also has Header and Footer.
My users requested, the report has possibility to include or not include data on Page #4.
Other words, report should display 3 or 4 pages based on the entered parameter.
1. I created parameter named “Include #### metrics”, which contains options: Y, N
2. For each object on the page 4 I added dependency on the selected parameter in the visibility option.
Now if user select parameter Not include Page #4, report displays 3 pages as expected and page #4 is empty, but with Header and Footer.
The problem: Their preference is to not to show page 4 at all if someone chooses to not to include #### metrics.
My question is how to force the report to display just 3 selected pages.
View 5 Replies
View Related
Nov 19, 2015
I have a SSRS report with data in below format.
ID Name Date
1 A null
2 B 01/01/2012
3 C 01/02/2013
Also, I have a sort parameter @sort and values are (Name, ID, Date)
I want to apply page break whenever @sort=Name. There should be no page break when user selects @sort = ID or Date. Page break should happen only when @sort value = Name
it should be like this...
Page 1:
ID Name Date
1 A null
Page 2:
ID Name Date
2 B 01/01/2012
Page 3:
ID Name Date
3 C 01/02/2013
I need achieving the above task.
View 2 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Nov 28, 2006
Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.
When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.
I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)
I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.
Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter
View 2 Replies
View Related
Oct 16, 2006
The following objects are placed on the Report body of the Report pane of SQL Server 2005 Reporting Services :
<textbox: expression1>
<textbox: expression2>
<table:table1 with at least 30 columns and 30 expressions>
<textbox: string1> - considered as the Title in the Footer section of the report
<texbox:string2> <textbox:expression3>
<textbox:string3> <textbox:expression4>
<textbox:string4> <textbox:expression5>
<textbox:expression6>
I can't find any explanation why is it string1 and string 2 of the footer section of my report displayed separately from the expression3 which is aligned on it and the rest of the object on the second page.
The expected design is that all Footer items should be displayed together of whether it is placed on the first page or on the last page.
As a workaround of this, I converted string 1 into an expression (Added = and enclosed the string with double quote).. As a result, all of the items in the Footer section are now placed together on the last page of the report.
I also remember one of the issue I encountered before where the Footer items where placed together on the first page and still have space at the bottom of the page, but then expression 6 is forced to display (alone) on the last page of my report.
I can't find any discussion related to this, I wish somebody could give me an idea why RS behaved like this.
Thanks in advance
View 1 Replies
View Related
Feb 14, 2008
Fit an intere table in same page without page break for save the excel export.
My table has a Group for order my dates.
I need to have the intere table in the same page, i don't care about blank space at the end of the page.
I can't use the page break beacuse i need an excel export in a unique sheet..
I have tested.. every page break..you'll have a different sheet in your excel export
I need something like this
page 1
Zone
1
2
3
4
5
6
7
7
8
9
..
page 2
Zone
1
2
3
4
5
6
7
7
8
9
..
but an unique sheet in the excel export
View 4 Replies
View Related