I've got a problem with paging and the ReportViewer. Here's how it goes:
First, I got the ReportViewer set to "print layout" and my reports having the correct size for each layout (landscape or portrait). Everything is fine with this since the number of page in the report reflects perfectly the number of page you can navigate with.
However, there seem to be a problem with displaying the correct number of page at the loading of the report. In fact, if the report contains 5 pages, the navigation header with often only shows 4 pages total. But once I click "next page", the correct number of page is then computed.
I didn't have any problem with that until I got a 2 pages report. The problem is, the navigation header is showing 1 total page and the "next page" button is disabled. So I cannot click it. I can, however, "scroll" down with the mouse wheel. But, this isn't a viable solution since some of our clients don't have mice with wheels.
Is there an option to tell the ReportViewer to complet the page count before showing any data on screen?
I am using a ReportViewer Control inside of a Windows Form and ran into an issue with the page navigation failing to update upon refresh (the report itself does refresh - the page navigation does not). If the initial report has one page and the subsequent refresh produces five pages, the page navigation window only shows one page. If you manually type in page two or three, nothing happens.
I am embedding the ReportViewer in an aspx page and the report comes up fine, but when I press the "Next Page" or "Last Page" buttons, I get the error: "Page navigation is out of range".
The application has session state turned off. The problem occurs whether or not the viewstate for ReportViewer is turned on or off.
i want to change the XXX with a value from the dataset. I tried - javascript:window.open('http:www.a.com?num= + Fields!ME.Value '); or - javascript:window.open('http:www.a.com?num= & Fields!ME.Value '); it didn't worked :(
I have created a one-page client summary report. My problem is that I can only get the report to show one client and there are many. How do I add record navigation functionality to my report?
I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions Thanks
Inder
The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
Hi all, I'm trying to design a website with my old MS Access Application as a template, because my users know that style. I use textboxes to display data from the MSSQL 2005 database, one record and 20 fields per page ....and i would like to navigate through the records with 4 buttons: first, last, next and prior, placed on the page.I tried a lot of things, and my last attemt was a Stored Procedure with a Cursor to do the trickbut.... it did not work It's very easy to do this in MS Access. Can anyone tell me a simple way to do this ?
Hi everyone I stumbled across this problem recently and have tried to figure out a good solution and have come up with nothing. Environment: ADO.NET, ASP.NET 2.0, MS SQL 2000, C# Problem: I have a set of data which I order according to two columns of data in the set. One column is a varchar or a date value (depending on what the user has chosen from GUI controls) and the other is an identity column. This dataset contains lots of data so its not feasible to pull the entire dataset to the client, also everything must be performed via ADO.net (no stored procedures). When the user selects one of the records I load another page and drill down into the record details (think of this as the record details page). This is fine and easy but on this record details page I would like to keep a Next and Previous button so users can move to the next record in the set (remember this set is sorted somehow on the previous page). My question is how can I know what next record should be? It would seem I need to attach a sequential number to the rows of data so I can easily grab the next one in the set. Solutions to this seem to make use of a temp table which I dont think is possible via ado.net. Is there a decent performing way to do this through ado.net? Thanks for all insight.
Now, it's easy enough to make the values clickable so that somebody can drill down to a report that shows detail about the people. I have also discovered how to turn off clickability on the totals. However, what I really want is for the totals to be clickable so that, for example, if I click on the 63, I see a report that shows all men. Likewise, If I click on the 48, I want to see a report that shows all Full Professors. What currently happens when the totals are clickable is that if I click on the 63, I get all men who are full professors (36 records instead of 63). If I click on the 48, I get all Full Professors who are men. (36 records instead of 48).
Is there any way to send different parameters (or even no parameters) to the secondary report if the subtotals are clicked instead of the regular results?
Can I have a report that is nothing more than a parameter and when the user selects from the list it will jump to another report based on which parameter was selected?
I can create a report with a text box that I can click to jump. I'd like to be able to eliminate the click on text box if possible and jump directly from parameter select pull down box.
I have a report with a Matrix table. When it€™s fully populated I have 5 rows. These rows are different categories in a CRM system. In these categories there are a lot of Opportunities listed. The thing here is that category 1-4 exist in one table, really a view, and category 5 exist in another different view. So to gather all the information into one single Matrix table to later have subtotals and stuff I just made a little Union of the two select queries.
Now one the column in the table is of course Topic. And from here my client wants to be linked to the right CRM card. The problem I have encountered is that how can I have to different addresses on one single cell in the table?
In the Navigation pane in the cell that corresponds to the Topic, for now I have an address like this: =string.Format("http://{0}/SFA/opps/edit.aspx?id={1}", Parameters!srv.Value, Fields!objectid.Value)
What I need to change when it€™s a category 5 Opportunity is €œopps€? to €œcat5€?and add €œ&etc=10008€? to the end of the address. Any ideas?
PS. {0} and {1} are parameters, one server parameter and one opportunity ID parameter.
When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works.
However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.
And if I put http://www.micheldegremont.com?id=Fields!ID.Value my report create a hyperlink to http://www.micheldegremont.com?id=Fields!ID.Value and no http://www.micheldegremont.com?id=1
I have a doubt regarding use of navigation controls in a report and exporting the report. For example using a drilldown functionality in a report. After the report is generated one can export the report in whatever format he wants (PDF,TIFF, XML,...).
In this case, with the drill down functionality in the report, the details of the report are visible only when the plus sign is clicked. Suppose now the plus sign is not clicked and one exports the report in a PDF or TIFF format.
In the PDF file, the navigation or the drill down functionality is now not useful right ? There is no way to view the detail fields of the report now, using the PDF file right?
Anyone know why my navigation buttons on my reports is always dimmed so that I can only see the very first page of every report? I even spent some time with a Microsoft SQL Server engineer trying to figure this one out and he wasn't able to figure out why?
I tried to attach a picture but I guess pictures aren't allowed. The first page, previous page, next page and last page buttons displayed as arrows on the top left of the reports are always dimmed on every report even though they have multiple pages.
Has this happened to anyone and how did you get it fixed?
I have a matrix report, which has one row group and one column group. The value is a Count of some field coming from the dataset. So the difficulties that I'm having is that when I click on zero(i.e. 0) values from the main report, the detail report doesn't ran and it through an error message : The 'X' parameter is missing a value. When the value is positive(other than zero) then the detail report works fine.
Hi. I am new to ADO.NET and I can't seem to figure out how to populate a row that is a layer lower than the instantiated row. I am populating and XML file called Users.xml:
and, i am using the below code to access and populate the rows based on the users registration input:
Code:
Dim NewLogin As Data.DataRow = LoginDS.Tables(0).NewRow
I am able to access all the rows that are one layer into the xml file with the following code:
Code:
NewLogin("someNode") = _someNode.Text
but, how do i populate nodes that are "further down" such as "birthDay". Do i have to reinstantiate NewLogin as ...Tables(1).NewRow? I have tried various forms of this and it doesnt work. Suggestions appreciated... thanks.
I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports
Year May April March Feb Site Manager Direct Report A 1 Direct Report B 2 Direct Report Unknown 3 Total 6 Total
Hi everyone, I know this question has been asked several times in the forum, and I've tried to use the examples given, however, I cannot make them work for myself so I'm finally posting my question. I hope someone can help me out as well
Report Name: Passive Theft - Summary Report: This is a rolling 12 months report (it is a matrix). Row Groups: site (location), manager, direct report (for each manager) Column Groups: Year, month > this is for all work orders Overview: The counts showing on the report summary shows how many passive theft audits were found, in a period of time (year and month) on a person's work orders (which where the Direct report information is derived from)
Just like prior posts, I need to be able to drill down from the summary report (which shows counts of audits) to a detail report that will show the individual work orders depending on the number clicked (non-subtotal and subtotal in the matrix). My detail report is called "Passive Theft - Detail", and this is the report I'm pointing to in the navigation option - jump to report.
What I have done so far is that if I just pass the year, month, site, and direct report as parameters to detail report and I get the correct detail (in the report, this would be clicking on 6, any of the aggregates by the manager line). However, if I click on 1, 2 or 3, I obviously just get the result for the whole manager group again, which is just 6. Can you please show me a code on how I can accomplish passing on the correct values an getting the right detail?
Second dilemma: We have a lot of contractors employee information that have been purged from the system, which could possibly still have work orders attached to them, but their name just wont show up in the report. In my SQL, I use the ISNULL function to show these purged contractors as "Unknown". So say for the Sample above on Direct Report Unknown which = 3, if I click on that, I may click on that and only get 2 details in the Detail Report because 1 other detail has been purged out of the system. But if 2 are available, I would still like for them to show for the unknown contractor.
Third dilemma: An employee may still be present in the system, but the work order information could be purged already and so if you click on Direct Report A, as an example, he woudln't have a detail for that work order even though he has a count of 1. How do I resolve this?
I know this is such a long question but I really need help I hope someone can enlighten me Thank you!
We have reports that runs fine in our developing and test inviroment. But when I deployed to the production server so comes the problem when navigating reports with multiple pages. It works fine when reports loads for the first time or click the refresh button, it show the first page of the report. Then we get "An internal error occurred on the report server. See the error log for more details. (rsInternalError) " when we try to go to next page or back to the previous page.
Is there a way to combine the Bookmark and report link functionalities in reporting services. For example, I have two reports. When I click a link in first report, I would like to be able to navigate to second report but not at the top of the report but at a particular report item way down in the second report, sort of like an anchor on an HTML page. Can I do this?
Hi Everyone,I'm drawing a blank here and I am hoping someone can point me in the right direction. I have a table with the following columns (some omitted)IDGUIDPageNameParentPageID I want to build a hierarchical navigation system (2-tier). The conceptual problem that I am running into was getting this information from the same table. Initially I was going to use a nested repeater but I am thinking a treeview would be better. Anyway, the problem is the query. How would I start with something like this? Let's use the following as an exampleRows(ID '1', GUID '888....', PageName 'Page A', ParentPageID '-1')(ID '2', GUID '111....', PageName 'Page B', ParentPageID '-1')(ID '3', GUID '222....', PageName 'Page C', ParentPageID '-1')(ID '4', GUID '375....', PageName 'Page 1', ParentPageID '1')(ID '5', GUID '562....', PageName 'Page 2', ParentPageID '1')(ID '6', GUID '874....', PageName 'Page 3', ParentPageID '2') (ID '7', GUID '388....', PageName 'Page 4', ParentPageID '3') So, I want to be able to build a query so that I can do the followingPage A Page 1 Page 2Page B Page 3Page C Page 4 Any help would be greatly appreciated. Thanks!
Hi need to create navigation that gets populated via database and is role based. below is the sql
CREATE TABLE [TopMenu] ( [MenuID] [int] IDENTITY (1, 1) NOT NULL , [Text] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ParentID] [int] NULL ,CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED ( [MenuID] ) ON [PRIMARY] ) ON [PRIMARY] GO INSERT INTO TopMENU Select 'Property','Property', NULL UNION ALL Select 'Portfolio','Portfolio', NULL UNION ALL Select 'Capital Expenditure','PortfolioCapex', 1 UNION ALL Select 'Depreciation','PortfolioDepreciation', 1 UNION ALL Select 'Condition Audit','PortfolioCondition', 1 UNION ALL Select 'Historical Expenditure','PortfolioHisEx', 1 UNION ALL Select 'Property Details','PropertyDetail', 2 UNION ALL Select 'Assets','PropertyAsset', 2 UNION ALL Select 'Depreciation','PropertyDepreciation', 2 UNION ALL Select 'Capital Expenditure','PropertyExpenditure', 2 UNION ALL Select 'Insurance','PropertyInsurance', 2 UNION ALL Select 'Documents','PropertyDocuments', 2 UNION ALL Select 'Capex','PortfolioCapex', 3 UNION ALL Select 'Graph','PortfolioCapexGraph', 3 UNION ALL Select 'Graph','PortfolioDepreciationGraph', 4 UNION ALL Select 'Current Depreciation','PortfolioDepreciation', 4 UNION ALL Select 'WDV & Depreciation','PortfolioDepreciationWDV', 4 UNION ALL Select 'Assets','PropertyAsset', 8 UNION ALL Select 'Capex','PropertyCapex', 8 UNION ALL Select 'Depreciation','PropertyDepreciation', 8 UNION ALL Select 'Condition','PropertyCondition', 8 UNION ALL Select 'Expenditure','PropertyExpenditure', 8 UNION ALL Select 'Disposed','PropertyDisposed', 8 UNION ALL Select 'Capital Ex','PropertyExpenditure', 10UNION ALL Select 'Capital Ex Graph','PropertyExpenditureGraph', 10 GO now clearly, I will have two top level navigation
property and portfolio. both property will have subsequent navigation and those subsequest navigation may or may not have another sets of navigation. I need to display in a row style not in a drop down style for eg. If I am in portfolio link the navigation structure should be as below Portfolio Capital Expenditure | Depreciation | Condition Audit | Historical Expenditure Capex | Graph by default Capex should be selected. it should also highlight Portfolio, Capital Expenditure and Capex as Capex's parent is Capital Expenditure and Portfolio I was thinking of using a 3 level datagrid. could someone please help me I am using asp.net 2.0 web application project with vb.net and sql server 2005
hi experts, i'm working in building new reports from an existing database. the report i'm working in is to save the path of the visitor through a web site(this is neede for the statistics web site), i have the siteId, commid, maintab, subtab. the site id is dtored in site table, maintab and subtab are stored in article(they are mixed in one columns called title) i have also sessionid stored in session table. i want a query that show the flow of the visitor through a web site, which tab he clicked first then second tab then third tab and in this tab he clicked subtab and the last tab he clicked on before leaving the web page. is this possible and if not, what are the other approches that can i make to get the report i want. also i want to ask if it is possible to create the report where it will show you the visitors for the first time and the returned visitors. thanks
HiI'm trying to convert some verbose SQL Server 2000 T-SQL code that useslots temp tables and the like into a SQL Server 2005 only version,possibly using CTE.What I want to achieve is a menu like that onhttp://www.cancerline.com/cancerlin...9801_6_3_3.aspxNotice how you have the top level menu items, and then child nodesexpanded down to the low level page that link sends you to.Table sql:CREATE TABLE [dbo].[NavigationNode]([NodeId] [int] primary key nonclustered,[Text] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[AlternativeText] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[Level] [int] NULL,[ParentNodeId] [int] constraint fk_parent_navnodeforeign key references [NavigationNode] ([NodeId]))Table data:1HomeNULL1NULL2SolutionsNULL113Solutions child1NULL224Solutions child2NULL225ContactNULL116solutions child1 child1NULL337solutions child1 child2NULL338solutions child1 child3NULL339solutions child1 child4NULL3310contact child1NULL25I have started to write some code with the common table expressionsyntax:declare @root int;set @root = 2;WITH Nav([NodeId],[ParentNodeId], [Text], [Level]) AS(SELECT [NodeId], [ParentNodeId], [Text], [Level]FROM [dbo].[NavigationNode]WHERE [ParentNodeId] = @rootUNION ALLSELECT n1.[NodeId], n1.[ParentNodeId], n1.[Text], n1.[Level]FROM [dbo].[NavigationNode] n1INNER JOIN Nav n2ON n1.[ParentNodeId] = n2.[NodeId])SELECT *FROM NavWhich returns:32Solutions child1242Solutions child2263solutions child1 child1373solutions child1 child2383solutions child1 child3393solutions child1 child43However I would prefer to the childnode, and then get parents of thatchild recursively. Doing that would leave me with a result set thatcould add the top level menu items to and have all the data required.Any help is greatly appreciated.-Brian
I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources.
In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the same pages are very fast if done within a certain amount of time. This implies that there must be some form of caching going on and that the cache expires after a period of time. I have seen in the RSReportserver.config file that there are parameters relating to report caching, but they all appear to reference the actual reports being generated. My issue is simply being able to build the start page and other navigation more quickly and to keep it active so it does not have to perform that build each time.
Any information related to managing this situation would be very much appreciated..
I am facing this issue  In Fire Fox browser .When I click the Page Navigation Button , The Page Refreshes , but it not  Navigating to the next or previous page .How ever It is working fine all other browsers .   <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Width="100%" Heigh="100%"  SizeToReportContent="true"  AsyncRendering="false" >         <ServerReport ReportServerUrl="" />       </rsweb:ReportViewer>
Now, I know that I can access each folder (f.e. Sales) by directly putting it into the URL. Is there a possibility to enable every user to the root folder and then denying access on specific folders? F.e.: Our Head of Sales should be able to navigate to the root folder and then dcecide whether he wants to enter the Sales or the Sales Export folder.
Is this possible? I tried a few things, but nothing works.
Hi all, Hope someone can help me on this. I have a dataset from a stored Procedure which I am displaying on a table, I am using the option from the navigation tab "jump to report" from one of the Textboxes in the table. But I want to use the same set of data but filtered with the selected option on the table. I already have parameters for the Stored Procedure passing them to the "jump to report". But I just cannot figure out how to pass the set data set but filtered for my next report. Is there a way to do this.Or do I have to create another version filtered of the stored procedure used for the original. Ideally, it would be great to use the same dataset but filtered. Hope my question make sense. Thanks in advance jard
I'm having trouble dynamically specifying the name of the report I want to drill through to.
I have the follwing expression in the Jump To Report field on the Advanced Textbox Properties Navigation tab:
=IIF( Fields!Third_Element.Value = "NONE", "Details Report.rdl", "Second Level Service Sub Report.rdl")
I get an error saying I'm missing the true part of the expression... Am I specifying the report name incorrectly? Both reports have the same parameters even though each report uses different parameters:
C:devReportsSLA Request TypeService Desk SLA Performance - First Level Service Sub Report.rdl The expression for the textbox €˜Second_Element€™ contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
Also, what does the "Omit" parameter do in the paramters set up? I tried dynamically turning parameters on/off based on the report I needed to call and it didn't react as I expected.
I must introduce myself... Kris Allain. I am a VERY new DBA. Basically I as sort of pushed into the position even though I have no previous DBA experience. I come more from a Net Admin background although I've only graduated with a degree in MIS 2.5 years ago.
With that said, I ran into a problem last week in which took down a mission critical application for 4 hours. We have an app that his highly transactional and I'm using the Full Recovery method for this DB with weekly full backups, daily differential backups, and hourly log backups. Someone (could have been me) disabled the log backup job and a couple of days later the log grew until there was no more disk space (35+ gb). Well, it took me 4 hours to back up and shrink the log and get the system up and running again.
I told my boss what had happened and now he wants to know who did it. I told him it could've possibly been me, but I highly doubt it because it appears to have been disabled between 7-8pm on my "work from home" day, which I specifically remeber packing it up and playing xbox at 4:30pm.
Could someone help me figure out what happened and if there it is possible to track these changes in the future?
Has anyone ever seen TCP/IP become a disabled protocol without manual intervention from a user?
My websites just stopped talking to my MSSQL db and when I went into sql client config utility on the web boxes, tcp/ip was disabled. Any clues? Can't find anything to support this in the event or web logs.
While in the design window of a table, I click the properties button and click the Relationships tab. Here everything is grayed out, and I can't drag and drop to create relationships in my Diagram either. Its like things are locked up right now. Can any of you give me some direction? thanks
My production database has a maintenance plan that rebuilds all indexes and it's scheduled to run every day at 5 AM.
I disabled some nonclustered indexes that were not used by any execution plan I found, and run a Profiler session to catch any negative impact in performance.
But I found that the indexes were re-enabled the next day by the Rebuild Index task from the maintenance plan.
Is there a way to keep those index disabled? I don't want to drop them as I could have to re-enable some of them by users' request.
