InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:47:05 GMT20http://www.sqlservercentral.com/Forums/Topic1464903-1063-1.aspxI have a report that shows me all the jobs that are currently running on all my database instances. I am trying to see if there is a way for me to send a command to my sql server from my report to stop a job if necessary instead of having to log into each instance if there is an issue I need to address.Any thoughts?Tue, 18 Jun 2013 16:33:21 GMTpamozerhttp://www.sqlservercentral.com/Forums/Topic1300178-1063-1.aspxI am developing a GRN label print report and have installed font 3 of 9 Barcode. I want the barcode for the product to be stretched so you stand a good chance of scanning it.How do I double or even treble the height of this field. Changing font size etc just increase the width as well as depth. I just want more depth.Tue, 15 May 2012 06:49:50 GMTKelvin Phayrehttp://www.sqlservercentral.com/Forums/Topic1459949-1063-1.aspxI am trying to create a a datasource to db2 database for creating a report in SSRS 2005I have created a datasource using IBM DB2 ODBC DRIVER thru control panel and tested with login and pwd and connection works; but when i create a datasource under shared data source in BI 2005 Project i get the below errorERROR [IM003] Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER).Can someone suggest me on this?Tue, 04 Jun 2013 14:53:13 GMTboosivahttp://www.sqlservercentral.com/Forums/Topic1459800-1063-1.aspxCan SSRS evaluate a bit field without having to specify the comparison?Example: =IIF( Fields!IsState.Value and Fields!RegionID.Value <>"12","Yes","No")In this example IsState is a bit field and is not being compared to a value like RegionID is being compared to "12". Is this statement saying if IsState and RegionID is not equal to 12 then Yes else No. Or is IsState automatically being evaluated again "True" since nothing is explicitly specified to evaluate against it?Tue, 04 Jun 2013 08:28:40 GMTdawidajmhttp://www.sqlservercentral.com/Forums/Topic1458405-1063-1.aspxI have a requirement wherein i have to use two database (oracle and db2) to display the data on the report.in oracle i have RecdateacctnumacctnameacctID In db2 i haveacctIDdocuments (this will be more than one documents for a account)my report should be showing documents for each account acctnum acctname recdate documents123 test 5/1/2013 document a document b document cI am using sql server 2005. please suggest how i can achieve itThu, 30 May 2013 13:30:14 GMTboosivahttp://www.sqlservercentral.com/Forums/Topic894636-1063-1.aspxI am trying to assign two parameters to a query containing two tables against a Progress database. However, the parameters do not seem to be applied when I preview the report.I have tried creating Report Parameters and assigning these to the dataset parameters tab but all the data is still returned.Anyone have any ideas?SteveThu, 01 Apr 2010 05:54:52 GMTSteve Hindle-535638http://www.sqlservercentral.com/Forums/Topic789504-1063-1.aspxHi,I have a SSRS chart which is plotted using 3 fields X - Month,Y - Status, Count. Now this gives Count for the given month and Status.for this dataJan--Status1--10Jan--Status2--15Feb--Status1--20Feb--Status2--25Added months as CategoryAdded Status as SeriesAdded Value as Sum(Count) so chart wil have 2 lines for Status1 and Status2now i want a third line(Series) which is sum of Status1 and Status2. ie. for Jan i will have Status1 point 10 Status2 point 15 and StatusSum point 25Please give any ideas. Hope the above description is understandableI can do it by removing the series and hardcoding each Status. but the count of Status is variableThanksThu, 17 Sep 2009 03:50:55 GMTthetodaisieshttp://www.sqlservercentral.com/Forums/Topic1456985-1063-1.aspxHii want to build query at runtime.i have some metadata tables where i can store table names and attribute names. so now how can i do CRUD operations.Mon, 27 May 2013 01:02:50 GMTsravanthi033http://www.sqlservercentral.com/Forums/Topic1455119-1063-1.aspxI have a datadriven subscription that uses a stored procedure. The code is below:declare @ReturnValue intexec @ReturnValue = s003pSRC.sp_Par_Rate_Compare_Report_Subscription_Conditionselect @ReturnValue ReturnValueI have run the sp in ssms and I know its returning a 0 int value, why is the report still being sent out?Tue, 21 May 2013 10:24:48 GMTdndaughteryhttp://www.sqlservercentral.com/Forums/Topic665427-1063-1.aspxHi All,In SQL Server 2005, I'm struggling with defining a connection between Reporting Services and an Integration Services package that writes to a Data Reader destination. Any help greatly appreciated. This is a simple "hello world" type app just to shake out the basic connectivity issues. In the dvel environment I'm working in, Reporting Services and Integrations Services are running on the same server. I've read various threads and also read the Books Online "Defining Report Datasets for Package Data from SQL Server Integration Services" article, but obviously am still in need of a few more details. The unattended execution account has been configured and the SSIS data processing extension. In RSReportDesginer.config, I un-commented out the two lines referring to SSIS as a source type. I moved the package I developed (Baseball_Test_Package.dtsx) to the root level of my local c drive, and opened up Reporting Services. I clicked on New Report and in the Wizard, at the Select the Data Source screen, specified settings with New DataSource Name: Datasource1, Type:SSIS and Connection String: -f c:\Baseball_Test_Package.dtsx. Got the below message when I clicked Next:A connection cannot be made to the database.Set and test the connection string.The package failed to validate.Is that error referring to the specification in the Connection String box on this dialogue, or does the problem lay elsewhere? Thank you in advance for any suggestions.Thu, 26 Feb 2009 18:25:32 GMTjeffsmith.orhttp://www.sqlservercentral.com/Forums/Topic1452715-1063-1.aspxI am new t SSRS n want to practice with sample reports.But what should I put as a target URL?Kindly advise.Tue, 14 May 2013 10:25:53 GMTsdhamani1020http://www.sqlservercentral.com/Forums/Topic1449338-1063-1.aspxI have a series of reports, actually we call them dashboards because they have summary data, not lists.Anyway, the dashboards display fine in IE, Chrome, and Firefox but not in Safari.Several of our customers are using Safari as their browser and I need to find a way to make these dashboards display correctly across all browsers.Does anyone have suggestions, other than don't use Safari?ThanksGaryFri, 03 May 2013 13:13:40 GMTGFhttp://www.sqlservercentral.com/Forums/Topic1450626-1063-1.aspxI'm having an issue with a SSRS 2005 project where the structure of the master RDL is Page Header Sub-RDL 1 Sub-RDL 2 Page FooterThe issue I'm having is with the header and footer. The header consists of several text-boxes contained in a rectangle. The footer is a page number indicator.The sub-RDLs both consist of several rectangles, each rectangle has a page break.When the report is exported to Excel the Page Header is OK for the first page of the report but then goes wonky. The interesting thing is when it moves onto the 2nd sub-RDL it returns to normal. This behaviour is regardless of which sub-RDL is put second, different order same result. The normal header is the first in the below image, followed by the wonky one which becomes stretched.[img]http://i.imgur.com/0PwqS9f.jpg[/img]In addition if I remove the Page Footer the header behaves normally throughout the report, so I thought it was something to do with the Interactive Size of the report but setting this to 0cm, 0cm has not yielded any breakthrough.Any help is appreciated, thanks.Wed, 08 May 2013 08:54:57 GMTfiachra.obraoinhttp://www.sqlservercentral.com/Forums/Topic1450292-1063-1.aspxHi There,I am in the process of writting in Visual Studio 10 and SQL 2008 R2 Express 10GB version backend a database programme which is designed for salespeople to use in an office. It keeps customer and supplier contact information and can process orders and stores products the users sell and can create quotations to send to customers.I want to sell this package around the world and bundle into it either SSRS or Crystal reports etc but the package I go with needs to do the following:1. Must be able to build into our package, so it looks like it is part of our package.2. Must be able to send out as part of our package so it can be part of the initial install.3. Must work all over the world and I must be allowed legally to do this ie licensing.4. We want to make a quotation template so that users can drop in a pre set table which drops our products in and pricing, sorted in the order we have pre set.5. We want the user to be able to set up mail merge ie for company name, address etc.6. We want to send out some custom reports for users to be able to view.7. We want users to be able to set up reports for themselves in some cases.Any help as i'm having a nightmare would be great.[quote][/quote]Tue, 07 May 2013 12:28:58 GMTsimon 92843http://www.sqlservercentral.com/Forums/Topic1450227-1063-1.aspxI need to create a report that will emulate what our warehouse uses as a “Pick Ticket” for pulling orders. The user wants to enter multiple ID’s that represents different orders, and have returned a page that can be printed for each order. Some orders will have multiple pages, i.e. 1 of 4 pages.In the database, we are reusing columns such as Quantity01, Quantity02, etc. For the 11th product, we are populating the Quantity01 field for the 2nd time. This is done each time we go beyond the 10th product. The problem I have been facing is, when using a table, it tries to grow automatically to accommodate the 11th product and so on. I have found a way, using the Page break option, to force the results to the next page after the 10th product. The problem with this is the change is only effective for the middle section of the report. The top section and bottom sections do not push to the next page.As far as I can tell, I cannot use headers and footers b/c of how the user wants to run the report. If you pass more than 1 order ID into the report, it will populate the middle section with the appropriate order items, however the header and footer values will continue to populate the values from the first order ID it comes across. I could have the expressions in my fields wrong as well.I need to be able to create one page that looks like the screenshot [attachment uploaded], and force it to populate the correct order values in the middle section per page, up to 10 products per page then move to the subsequent page until all pages for that one order have been completed, as well as when a new order ID is encountered, start the same process again. I have been able to trick it to do so if I am processing only 1 order ID at a time.Tue, 07 May 2013 10:02:13 GMTrodneyvbass 31734http://www.sqlservercentral.com/Forums/Topic1448860-1063-1.aspxSo I have a VERY simple report returning three columns from one table. It has four report filters:Transaction IDUser NameStart DateEnd DateThe first filter, Transaction ID, would ideally return a list of ALL Transaction IDs in the table. The problem is there are more than 700,000 rows. This drags the report performance to its knees. Right now, it only returns the most recent 1000 filters.So is there a way to return all 700,000 rows and maintain performance here given that this is SSRS 2005? I don't think cascading report filters are an option here (I think that is SSRS 2008 or newer). In other words, I don't think I can filter the results of the Transaction ID filter by the other three filters.Any suggestions?Thanks,DHThu, 02 May 2013 09:31:48 GMTdarkhelmutishttp://www.sqlservercentral.com/Forums/Topic1095471-1063-1.aspxHi all,Here is a SSRS issue. I need the solution ASAP.I am creating a report from a temp table. In the Temp table data will be getting loaded based upon the options selected in Asp.net page. I have to Load the Image based on the selected data loaded in the Temp table.I have a column image with data type varbinary (max). While using this, image is displaying for the first time when page getting loaded. When options are changed data is getting loaded into Temp table, along with the Image, but no image is displaying.I tried like altering the column to varchar (max) and storing the Image path. Now the image is not displaying for the first time too.Now I need the solution for How to display an image into ssrs report from the databse field which is having the Path of the Image. It should change dynamically when path changes in Tempt able.I hope you have understood the Problem. Please give the solution.Thanks In Advance.Ravi KumarTue, 19 Apr 2011 03:02:52 GMTravi.06khttp://www.sqlservercentral.com/Forums/Topic1445904-1063-1.aspxHi all !i have a slight problem with my drilldown report. I have a matrix table that drills down to a table. below is what the matrix table looks likedepartment |LastName | FirstName |FISCAL YEAR 2013 |fiscal quater|Total hfhgfh bloggs jon q1 q2 q3 q4 0 4 2 1 Grand Total| Dept Total the problem im having is that when i click on one of the fiscal quarter values that drillsdown to the table say for example q2 which has 4 entries then it only shows one entry when it should show all four entries within the drilldown table.Is there any advice on what i need to do to show all four entries. i heard i need to add scope to my stored procedure. is this right?Wed, 24 Apr 2013 06:31:32 GMTprb88http://www.sqlservercentral.com/Forums/Topic593245-1063-1.aspxHi,I have generated the report and looks fine. But while printing the QA Smile wants the report headers(TABLE HEADERS) need to be print on each page. I can get this by doing some format in EXCEL, but that should be done using SSRS. Is this feature present in SSRS to make the table header showup on each page when printing.Any help would be greatly appreciated.Thanks,SumanTue, 28 Oct 2008 14:06:56 GMTrayabharapusumanhttp://www.sqlservercentral.com/Forums/Topic711308-1063-1.aspxHello,I'm the new guy that was tasked with creating a new report.I've created the report and viewed it. It looks great. I'm trying to deploy the report and it is giving me this error.Error: "The item '/Data Sources' already exists."?!I created a new shared datasource for this report. Can't that go in the same folder as the other data sources?I'm a tad bit confused here. Any help is appreciated!Thanks,TonyWed, 06 May 2009 10:59:01 GMTWebTechie38http://www.sqlservercentral.com/Forums/Topic1432838-1063-1.aspxOK - I've tried everything I can think of to fix this but nothing is working. Here's the issue; I have created a report that is sums building square footage grouped by market. the client wants the excel export in whole numbers so I put in a round function, with and w/o midpointrounding.away fromzero and then tried (format N0) each returns the whole number. So far so good. However when I total the group the value is sometimes spot on and sometimes off because of the rounding. I tried rounding the group total, etc., but no combination of rounding/formattting seems to work. I thought of going into the underlying sql and create a new dataset for the totals, but not sure that wouldn't have the same issue, besides it is a pain given all the colums subtotals and totals I am dealing with. Anyone else encountered this? How did you solve it?Thanks, JohnTue, 19 Mar 2013 12:05:57 GMTjgluszakhttp://www.sqlservercentral.com/Forums/Topic1432115-1063-1.aspxHI All, Can anyone help me in skipping the special characters in the Result set. column valueFor ex.If the actual value fetched from DB is 12AV$BJ_ When it displays in Report , i want the output as 12AVBJ Is it possible. I want only textbox value to be changed. Not any other. Textbox should accept only alphanumeric values.Is there any option to set such validationThanks,Mon, 18 Mar 2013 03:18:12 GMTjeganbenitto.francishttp://www.sqlservercentral.com/Forums/Topic1407029-1063-1.aspxHi all,A burning qns. Currently my report displays 7 column from a datasource A. Is it possible to add the 8th column to the same report from another datasourceB?Got an idea to improve my report but stuck at this issue. The 8th column will help user to view report with better understandingMon, 14 Jan 2013 22:52:47 GMT10e5xhttp://www.sqlservercentral.com/Forums/Topic1424286-1063-1.aspxHi,I am adding a subreport to a report and I need to pass a uniqueidentifier or Guid to the subreport. However the subreport only allows me to specify the parameter as text/boolean/Detatime/integer/float.If I use Text, I get th esubreport stating "Data retrieval failed".What do I need to do?Tue, 26 Feb 2013 16:58:07 GMTFrank Cazabonhttp://www.sqlservercentral.com/Forums/Topic1429442-1063-1.aspxI have a Crystal Report that I am converting to Reporting Services. The report lists accounts by SIC Code, which is in the following format on the database: '#### - text description' (for example, "5812 - EATING PLACES"). The users are allowed to select multiple SIC codes to report on, and they only have to enter the first 4 characters of the code (in this example, '5812'). In Crystal, the code uses "startwith" to produce the result set (where siccode startswith {?SIC Code}). The "in" clause in Reporting Services is used for multi value parms, but it must be an exact match. How do I do the equivalent in Reporting Services?? Thanks for any help you could offer.Mon, 11 Mar 2013 12:57:17 GMTBarbara DiVecchiahttp://www.sqlservercentral.com/Forums/Topic1427710-1063-1.aspxHi Guys, We have a 3rd party developing our data warehouse, and we do the SSRS devevelopment in house via BIDS and report builder. The DW devlopers want to push a new version of the data warehouse to us in a few weeks and they have changed the naming conventions on roughly 50 columns in 30+ tables. As opposed to taking a reactive approach and waiting for the new wharehouse to go live and see which reports break, I'm wondering if it would be possible for me to execute a script against the report server to identify which reports have the columns that would be impacted by the change? In my previous role I've written scripts to convert the .xml in SSIS packackages into sting data and load it into table that I can query against , but SSRS is somewhat new to me and I'm still waiting for my permissions to be setup so I can execute queries. Also, If I can query to identify the changes, is it possible to then write a SQL script to alter the .xml in the RDL files so we can avoid having to open each report and make the changes one at a time? Lastly, are there any good tools out there that would allow us to do an impact analysis in an automated fashion as opposed to using SQL queries whenever schema changes occour?Thanks in advance!Wed, 06 Mar 2013 17:53:30 GMTCode-1029433http://www.sqlservercentral.com/Forums/Topic1430539-1063-1.aspxI could use some suggestions on how to resolve problems with SSRS. We currently have several subscriptions that run thoughout the day that have stopped running, I can run the reports manually and they produce fine, but none of the subscriptions are getting emailed to the users.1) Should I restart SSRS Service?2) should I restart SQL Server Service?Note: we have replication running on this server as it gets it's data from our production transaction system, we use this server for reporting.I could use any help or suggestions as I am the only one on our team that has any SQL knowledge (And that mine is limited.)Thanks in advance,Wed, 13 Mar 2013 11:15:42 GMTgregory.perry2 87972http://www.sqlservercentral.com/Forums/Topic1429287-1063-1.aspxHi All, I am trying to generate a offline Files of a Report using Subscription. When i try to genrate the file in HTML format , it throws me below Error Failure writing file (name) : An error occurred during rendering of the report.When checked in ExecutionLog it was mentioned as rrRendering Error. Can anyone please help me in generating the file.NOTE: The RDL was designed using matrix, so it might have atlease 50 columns.Thanks,Mon, 11 Mar 2013 08:12:40 GMTjeganbenitto.francishttp://www.sqlservercentral.com/Forums/Topic1427653-1063-1.aspxIn my dataset I have this script. Report parameter @acct is set as multi-value. When I select a single value it runs fine, however when I select multi-value I get the error....Incorrect syntax near '+'EXECUTE ('USE ' + @dbname + ' select g.cpnyid,g.JrnlType,g.Module,g.PerPost,g.Acct,g.Sub,substring(g.sub,6,5) as Cost_Ctr,left(g.sub,3) as Dept,substring(g.sub,4,2) as Legal_Entity,g.DrAmt,g.CrAmt,0 as Amt,g.TranType,g.BatNbr,g.ID,g.refnbr as VONbr_InvNbr,g.ExtRefNbr as Vendor_InvNbr,g.TranDescfrom gltran gwhere left(g.perpost,4) = ' + @year + 'and right(g.perpost,2) = ' + @month + 'and left(g.acct,1) in (' + @acct + ')and (g.dramt <> 0 or g.cramt <> 0)')Wed, 06 Mar 2013 14:59:58 GMTis250sphttp://www.sqlservercentral.com/Forums/Topic1427537-1063-1.aspxI can not seem to get the URL right for my Jump to Report.Server = server_nameFolder Path from home = "Safety Stock Review"Report = "Stock History"Report Parameters: mrparea, matData: Fields!MRP_Area_CD.Value, Fields!Material_CD.ValueThe report will come up but the report parameters are getting loaded into the drill down report.What I get in IE's path box: http://server_name/Reports/Pages/Report.aspx?ItemPath=/Safety+Stock+Review/Stock+History&rs:Command=Render&mrparea=AN01&mat68786The code:="void(window.open('http://server_name/Reports/Pages/Report.aspx?ItemPath=%2fSafety+Stock+Review%2fStock+History&rs:Command=Render&mrparea="+Fields!MRP_Area_CD.Value+"&mat"+Fields!Material_CD.Value+"','mywindow', 'resizable=yes, scrollbars=yes, toolbar=no, location=yes, directories=no, status=no, menubar=no, titlebar=no, width=900, height=800, top=50, left=900'))"Wed, 06 Mar 2013 11:06:02 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1380882-1063-1.aspxHi,1.How to display report dataset query in main report.pls any one give right information.Thanks,Vivek.Sun, 04 Nov 2012 23:25:12 GMTviveksvkolahttp://www.sqlservercentral.com/Forums/Topic1381709-1063-1.aspxHi all,Got the following situation:Server A contains information about a particular field of a table that I want to populate for a report. Server B contains other information. I want to combine these two sets of information into a single table in a report.The current solution I'm going with is to use SSIS to combine these two sets of information into a single database table, and then use SSRS to query this table for the report.I don't really like this solution though - I personally hate to use static database tables to store snapshots, since it doesn't permit changes to the source data to be reflected in the report.Does anyone have a better solution for me? And note that having a single stored proc / query using a linked server to join the two sources is not an acceptable solution for this problem.Tue, 06 Nov 2012 14:02:12 GMTkramaswamyhttp://www.sqlservercentral.com/Forums/Topic1413700-1063-1.aspxHi,I just created a matrix report with consecutive dates running along the y-axis and sales people running down the x-axis.Is there a way to show if a sales figure has an increase from the previous date as green and red if it has decreased?Any help welcome.Thanks,EamonWed, 30 Jan 2013 10:02:22 GMTEamonSQLhttp://www.sqlservercentral.com/Forums/Topic1422783-1063-1.aspxHi all,I hope someone can help. I'm about to pull my hair out. Something as simple as a filter expression in BIDS 2005 is not working. All I want to do is show results where two numbers divided together are >= .01. I'm getting a "failed to evaluate filter expression" error. The two numbers from the dataset are from a Stored Proc, where the columns are [money] datatype. -- First I tried this in the Filter Expression (on a table):Expression: =(Fields!Collected.Value/Fields!Discounted.Value)Operator: >=Value: =.01When I do it this way, I get the message "Cannot compare date of types System.Decimal and System.Double.-- So, I changed it to this, in an attempt to force the datatypes to be the same:Expression: =(CDec(Fields!Collected.Value)/CDec(Fields!Discounted.Value))Operator: >=Value: =CDec(.01)Now I get the error "Failed to evaluate FilterExpression."This is driving me insane. I'm trying to keep the number of stored procedures (SP) down to a minimum. The same SP is used for other reports which need the same data presented a bit differently in the report definition. All I want to do is filter the results shown. I don't want to create yet another SP to maintain just to get around a crazy, practically unusable filter setting in BIDS. (sorry - just so frustrated right now)Can anyone help please?? Thanks!!Thu, 21 Feb 2013 13:58:09 GMTSQLFan-933088http://www.sqlservercentral.com/Forums/Topic1265083-1063-1.aspxhi allif i have a simple bar chart in srs 2005, is it possible to design the report so that i can click on one bar and it will open a second table report with the information filtered by the selection in the chart?if anyone has any good tutorial on this, and even general subreports in ssrs 2005 can you please help me by linking them?anything i find online seems more directed towards 2008 - either that or i dont understand themcheersmalMon, 12 Mar 2012 05:39:11 GMTdopydbhttp://www.sqlservercentral.com/Forums/Topic1425357-1063-1.aspxHi All, Can anyone please help me in the below regard.I have a report. If the user fetches report now, he should not be able to view for next 10 mins.When the user clicks report in report, it has to say , Please wait for 10 mins.Thanks is advanceThu, 28 Feb 2013 22:55:39 GMTjeganbenitto.francishttp://www.sqlservercentral.com/Forums/Topic1425153-1063-1.aspxI have a line chart created in SSRS 2005 and need to use a thousand separator on the Y axis..can anyone please tell me how to do that..I have been trying to search for it..but no luck so farThu, 28 Feb 2013 09:57:29 GMTrockstar283http://www.sqlservercentral.com/Forums/Topic1424555-1063-1.aspxHi:I've come across a strange situation that is a bit difficult to explain. I've designed various reports in the past that include interactive sorting, successfully. But, this time around I'm running into problems.I've been working on a report that involves nesting a Table region inside a List data region. Interactive sorting is on the table header: a user is supposed to be able to sort interactively by a person's lastname. In very general terms, the dataset is a list of doctors and their patients; more than one doctor may be included in the dataset. So, the list data region groups by doctor, and the embedded table lists the doctor's relevant patients. When I preview the report, either in BIDS or in Report Manager, the report looks fine. When I click on the interactive sort icon to sort the patients by name for given doctor's set of patients, the interactive sorting will work, initially -- i.e., a doctor's list of patients will sort A - Z as well as Z-A. BUT, when I attempt to sort another doctor's list of patients in the same report, the interactive sorting no longer works. (?). Then it gets stranger... If I go back to the initial list of patients that did do interactive sorting successfully and attempt to do interactive sorting, it won't work anymore!? So, somehow the interactive sorting will work initially, but as soon as I navigate to a different grouping of a doctor's patients, even when there's a page break between each doctor's list, the interactive sorting will fail completely thereafter.Does anyone have experience solving a similar situation, or can recommend a link to a blog or article that deals with possible problems/solutions of nested data regions and interactive sorting?Thanks in advance,PeteWed, 27 Feb 2013 08:07:54 GMTpeterzekehttp://www.sqlservercentral.com/Forums/Topic1423777-1063-1.aspxWhen I run a report for a purchase order, the report duplicates records for product codes.For example the purchase order is: P000976, the report display the product code twice when it should only appear once. 45-5540 appears twice.P000976 09-17-2012 15,040.00 15,040.00 0.00 45-5540 "Lordotic Cervical Spacer 10mmLordotic Cervical Spacer 10mm" 20 20 0 45-5540 "Lordotic Cervical Spacer 10mmLordotic Cervical Spacer 10mm" 20 20 0 When I put the report's SQL in SQL server and run the sql by seeing where the code cause the additional product code it is this line within the SQL:join all_product_codes_VW p on q.distpartno = p.distpartnoselect q.specialrequirement, q.distpartno, q.toproduce, q.prodbegindate, q.distributor, rc.report_category_name, s.productperpo, r.ebi_released, w.ebi_in_WIP, p.distproductname, tp.typeprefixdetail, tp.cost, '1' as ReportTotalsfrom all_required_vw qleft join all_shipped_grafts_new_VW s on (q.distpartno = s.distpartno and q.specialrequirement = s.ponumber)left join all_released_Grafts_VW r on q.distpartno = r.distpartnoleft join all_in_WIP_VW w on q.distpartno = w.distpartnojoin all_product_codes_VW p on q.distpartno = p.distpartnojoin setup_tissue_prefix tp on q.typenumber = tp.typeprefixjoin setup_report_category_1 rc on q.distributor = rc.report_category_idwhere q.prodbegindate < @enddate and q.completed = '0' and rc.report_category_name like '%' + isnull(@tcustomer, '') + '%'order by q.prodbegindate, p.distproductnameThis is the SQL for the view for which the join creates the duplicate.SELECT COUNT_BIG(*) AS BIG, DistPartNo, DistProductName, Distributor, UMTBProductCodeFROM dbo.Setup_Distributor_Product_infoWHERE (Distributor <> '7') OR (Distributor IS NULL)GROUP BY DistPartNo, DistProductName, Distributor, USSAProductCodeMon, 25 Feb 2013 14:26:07 GMTLastJedihttp://www.sqlservercentral.com/Forums/Topic1392972-1063-1.aspxI have to change a prior report which included all records in which DateFinished is in the last 2 weeks to all records in the current month and am struggling to find the correct syntax. I have tried many things but I know TSQL and this does not work WHERE YEAR(DateFinished) = YEAR(GetDate()) AND MONTH(DateFinished) = MONTH(GetDate()).Wed, 05 Dec 2012 06:29:53 GMTgeorge.greiner