By far, the most popular posting on this site is Visual Studio 2008 & Business Intelligence Development Studio (Troubleshooting). The post currently has over 60 comments. It seems that here’s a lot of confusion about ways in which developers and report designers can get the tools they need to create and manage SQL Server Reporting Services (SSRS) reports. If you’re trying to work with the Business Intelligence Development Studio (BIDS) with SQL Server 2005 or SQL Server 2008, or you’re planning to use Report Builder 2.0, that post should point you in the right direction.
So now that SQL Server 2008 R2 has been released, what’s the story for report development? Fortunately, it’s not quite as confusing. The primary tool you’ll use for developing reports is Microsoft SQL Server 2008 R2 Report Builder 3.0. You can download it manually using the link to the Microsoft Download site, or you can install it using ClickOnce by loading your Reporting Services web site (e.g., http://localhost/Reports). The download is also available as part of the Microsoft SQL Server 2008 R2 Feature Pack (along with a wide variety of other tools and utilities). Report Builder 3.0 supports the creation of reports for both SQL Server 2008 and the R2 version.
If you’re moving to (or testing) the RTM version of SQL Server 2008 R2, Report Builder 3.0 is likely the best way to get acquainted with the new features of this release. And, thankfully, the migration process should be much simpler than it was for previous versions of SSRS. A great resource for more information is the MSDN SQL Server 2008 R2 Reporting Services Forum. Or, if you have any questions, feel free to post them here.
#1 by Aruna on July 13, 2010 - 6:48 pm
Quote
Hi Anil,
I recently installed MS SQL Server 2008 R2 on my computer. I’m taking the SQL Server 2008 courses and wanted to practice at home. I am not able to find Business Intelligence Development Studio. I see Visual Studio on my computer but no BIDS. what am I doing wrong here? Let me know, thank you.
Aruna
#2 by Anil Desai on July 14, 2010 - 8:39 am
Quote
Aruna: I believe the first link in the post above describes your problem and the solution. You should just be able to re-run SQL Server 2008 R2’s setup process and make sure that the Workstation Components option (also called “Client Tools”) is installed. I hope this helps!
– Anil
#3 by Aruna on July 14, 2010 - 11:26 pm
Quote
Thank you Anil. I did see this link before but I had only read a few of the notes. I had to reinstall and choose BIDS 🙂
Thank you.
#4 by Pavan on July 31, 2010 - 11:29 pm
Quote
Hello Anil,
I am new to Reporting Services (SSRS) and I am trying to develop an application wherein I need to display the .rdl files in the ReportViewer Control but I get an Error Message as below: “RDL version may not be compatible with ReportViewer version. To view 2008 RDLs you need Visual Studio 2010.”
I am using VS 2008 & SQL Server-2008.
Any help on this would really be appreciated. Thanks in advance.
Regards,
PavanKumar Sriramula
#5 by Anil Desai on August 1, 2010 - 7:27 am
Quote
Hi, Pavan. Though I have used the ReportViewer control in both ASP.NET and Windows Forms applications in the past, I haven’t run into this issue before. I know that there might be some issues between SQL Server 2008 and SQL Server 2008 R2’s report formats and features, but your configuration looks pretty common. I suggest you post your question to the Microsoft Reporting Services forum at http://social.technet.microsoft.com/Forums/en/sqlreportingservices/threads. Hopefully, someone there will have some better information. I hope that helps!
– Anil
#6 by Herries E on April 11, 2011 - 1:46 am
Quote
I think you need to install the ReportViewer to your server E.g. IIS
#7 by Pavan on August 2, 2010 - 2:14 am
Quote
Thanks for the information Anil. . .
#8 by Poonam on August 18, 2010 - 9:34 am
Quote
HI Anil
I have just started using ReportBuilder 3 for the first time, are there any books out there for ‘beginners’. I am interested in learning how to create subqueries and subreports etc
#9 by Anil Desai on August 18, 2010 - 9:41 am
Quote
Poonam: I would recommend starting with some the built-in help that’s included with Report Builder 3.0. It’s designed more as a reference than as something you’d read cover-to-cover, but it does include a lot of helpful information that goes beyond the basics of report design. If you’re completely new to reporting in general, though, there are several books on SQL Server Reporting Services which should provide a good background. I can’t recommend any specific titles, though. I hope this helps!
#10 by Myles on September 30, 2010 - 9:58 pm
Quote
Hi Anil,
we are just moving to SSRS 2008 R2. It looks like the query designer in Report Builder 3.0 will not be drop and drag like report Builder 1.0, which is a shame as its easier in 1.0 for users to build queries. Do you have any suggestions on making 3.0 easier to build queries?
Cheers
Myles
#11 by Anil Desai on October 1, 2010 - 9:01 am
Quote
Myles: I hadn’t noticed this before, but it does look like you’re right – the query designer has changed. I don’t usually use this feature. Instead, I usually write my SQL queries manually in SQL Server Management Studio and then copy them into Report Builder. However, I realize that I’m not the typical end-user. 🙂 Unfortunately, I don’t have any further information on this feature (or lack thereof). I suggest you post about this to the Microsoft Technical Forum at http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/. Perhaps someone there will have some more familiarity with the reason(s) for the change and any alternatives for users that prefer the previous method of query design. I hope this helps! – Anil
#12 by Dean on October 4, 2010 - 2:35 pm
Quote
Hi Anil,
I am very new with SSRS, but our group is looking to use some of the functionality that ReportBuilder 3.0 offers. Our current version of BIDS is 9.0. Will ReportBuilder 3.0 be compatible with our web portal so that we can still publish up reports without upgrading? Hopefully this still makes sense.
Thanks,
Dean
#13 by Anil Desai on October 4, 2010 - 3:44 pm
Quote
Dean: I think I understand your question, but you didn’t state which version of SQL Server you’re using. Report Builder 3.0 supports report development for SQL Server 2008 and SQL Server 2008 R2. If you’re using SQL Server 2008, you won’t be able to use the new reporting features that are available in SQL Server 2008 R2, but you should be able to develop reports with it. I hope this helps! -Anil
#14 by Laura on November 18, 2010 - 6:27 am
Quote
Hi Anil,
I have some doubts, which program is better to do reports, report bulider 3.0 or visual studio 2008? what it’s the difference between report bulider 3.0 or visual studio 2008? I am using Visual Studio 2005 now, but I want to change….
Thanks in advance!!
#15 by Anil Desai on November 18, 2010 - 9:22 am
Quote
Laura: I’m not sure I can say that one is better as it depends on the audience. Visual Studio 2008 is on par with Report Builder 2.0 from a report authoring and design standpoint (both support SQL Server 2008). Visual Studio provides some added benefits like source control support (TFS, VSS, SVN, etc.) but comes with the added overhead of having a full IDE installed. For users that will be creating and editing a fairly small number of reports, Report Builder would be simpler. Report Builder 3.0 provides support for both SQL Server 2008 and SQL Server 2008 R2 (you can choose the type of server target you’re using). It’s an upgrade from Report Builder 2.0, but some of the benefits won’t be available unless you’re using the SQL Server 2008 R2. In any case, I’d say it’s worth it to upgrade from Visual Studio 2005. I hope this helps!
#16 by Enrico on November 30, 2010 - 5:29 am
Quote
Hi Anil,
hope you can help me with this problem!
I’ve created a report with RB3.0, but I’ve to upload it on SSRS 2008 (not R2)… how can I specify the type of server target on RB3.0? I didn’t find this setting on report properties…
Thank you very much!!!
Enrico
#17 by Anil Desai on November 30, 2010 - 9:30 am
Quote
Enrico: Unfortunately, Report Builder 3.0 is designed to support SSRS 2008 R2 only (there isn’t a deployment target server version option like there is in BIDS). So, you’ll either need to use Report Builder 2.0 (which is largely the same, with the exception of new charting and reporting features) or BIDS. I found some more information here: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/8c394a4e-efc8-439e-9596-cb29e2cef483. I hope this helps!
#18 by Cecil on January 18, 2011 - 3:31 am
Quote
i want to update my report builder from version 2.0 to 3.0, my question is, will it not affect my sql server 2005 after upgrading from 2.0 to 3.0 ?
#19 by Anil Desai on January 18, 2011 - 9:27 am
Quote
Cecil: No – Report Builder (regardless of version) is a stand-alone program that won’t upgrade or make changes to your SQL Server installation. I think that’s one of the main reasons it’s designed as a separate download and install. However, be sure to check for compatibility with various versions of SQL Server Reporting Services targets; I believe Report Builder 3.0 only supports SQL Server 2008 and SQL Server 2008 R2 targets. I hope this helps! – Anil
#20 by Carla on January 30, 2011 - 9:47 am
Quote
Anil,
I was recently part of a SQL Server 2008 R2 migration & all went well with the exception of our ad-hoc reports built in Report Builder 2.0 and how they now display & work in Report Builder 3.0. I’ve worked through most of the issues, but still cannot determine what’s happened with the report textbox that displayed the report filters applied to the report. The textbox for each report carried over in the migration, but as plain text & no longer shows the actual filter selection. This is causing my users much distress.
Do you know how I can re-activate these?
#21 by Anil Desai on January 31, 2011 - 11:50 am
Quote
Carla: I have upgraded a couple of instances from SQL Server 2008 to R2, and I don’t recall running into those issues. I would recommend posting your issue to the appropriate forum or group on the Microsoft Technical Communities site. Hopefully, others can provide you with some assistance. – Anil
#22 by bita on February 15, 2011 - 8:38 am
Quote
hi anil,
i’m new in RB3.0 n i’ve installed VS2008 , dont know how can i have a report in VS. i’ve created a report in RB3.0.
can u help me please?
regards,
bita
#23 by Anil Desai on February 15, 2011 - 8:47 am
Quote
Bita: VS 2008 supports projects that use Report Builder 2.0 (which can develop reports for SQL Server 2008). You can get started by creating a new Reporting Services project (it should be available in a Business Development folder of project types, if I remember correctly). That project type should create some basic solution files and will automatically launch the Report Creation Wizard. For more information from MSDN, see http://msdn.microsoft.com/en-us/library/ms173767.aspx. I hope this helps! – Anil
#24 by Herries E on April 11, 2011 - 2:02 am
Quote
Possible SSRS 2008 & R2 installed at the same server !? Is there BIDS for SSRS 2008 R2 !? Thanks
#25 by Eric on April 27, 2011 - 5:40 am
Quote
I am using the report viewer control 2010. Have they fixed this control so that reports in report builder 3.0 can now run these reports under LOCAL mode? There were some significant errors in the previous release.
#26 by Anil Desai on April 27, 2011 - 7:16 am
Quote
Eric: I haven’t had the opportunity to use that version of the control in any applications myself, but perhaps someone else who sees this post can comment on whether the bugs you’ve seen have been fixed. A quick web search showed some issues with authentication and some formatting/rendering problems. You might want to post your specific question on the Microsoft Technical Communities SQL Server site: http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/. – Anil
#27 by Rob on June 17, 2011 - 6:46 am
Quote
Hi, i’ve installed SQL 2008 with BIDS. When i start it i get the Visual Studio IDE. I can make a report without any problem but when i click the preview button i get a lot of errors. They are all from type [rsinvalidsize] and are for all textboxes, pageheight width etc. Just 2 lines:
[rsInvalidSize] The value of the FontSize property for the textrun ‘textbox2.Paragraphs[0].TextRuns[0]’ is “11pt”, which is not a valid size. Valid sizes may not exceed 455 inches.
[rsInvalidSize] The value of the PaddingLeft property for the text box ‘textbox2’ is “2pt”, which is not a valid size. Valid sizes may not exceed 455 inches.
When i make the same report in Report Builder 2 i have the same errors. When i make the same report in Report Builder 3 then it’s working.
Do you have any idea?
thnx Rob
#28 by Anil Desai on June 17, 2011 - 9:01 am
Quote
Rob: That does sound like a strange problem. I have upgraded reports (and even manually “downgraded”) them before, but I haven’t run into this issue. I sometimes get warnings related to exceeding page margins, but that doesn’t sound like your issue here. You might want to try looking at the base XML in the .rdl file to see if there’s anything obviously wrong (though I wouldn’t recommend modifying anything directly, as small changes could break the entire report). I wish I could recommend some other troubleshooting, but I can’t think of any other ways to troubleshoot this error.
#29 by Rob on June 17, 2011 - 10:43 am
Quote
Hi Anil,
Thnks for your fast reply. This is what is in the first 2 lines of the report.
Is that what you mean. But those lines are generated by the report designer.
Is this looking strange to you?
thanks,
Rob
#30 by Rob on June 17, 2011 - 11:16 am
Quote
Sorry, I forget to copy the lines.
Rob
#31 by Rob on June 17, 2011 - 11:18 am
Quote
I don’t forget them but they are taken out. Try it once more.
“”
“”
Rob
#32 by Anil Desai on June 17, 2011 - 12:53 pm
Quote
Rob: I’m not sure I’d be able to troubleshoot the specific RDL data itself. I suggest you post your specific problem (with code snippets and any related details) on the Microsoft SSRS Forum at http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads. There’s a chance someone else has run into a similar issue and might be able to help. Good luck! – Anil
#33 by Rob on June 17, 2011 - 1:49 pm
Quote
ok, thanks for your suggestions.
Rob
#34 by Ashish on June 30, 2011 - 1:12 am
Quote
HI,
I have certain requirement to build report using RB 3.0 with SharePoint server. Can you please let me know what no of things are achievable or not.
1) I would like to security trimmed entities based on different user. Like when they load ReportBuilder report from the ReportModel based on the user it should show no of tables. ?
2) Can we provide such security with SharePoint so that user can only view certain reports and create new report based on that with out modifying existing report?
Thanks,
Ashish
#35 by Anil Desai on June 30, 2011 - 8:53 am
Quote
Ashish: These are good questions, but I can’t get into too much detail here. In short, yes, you should be able to meet these security requirements in a variety of ways. If you just want to filter at the table level, you can use database permissions or create multiple models for that purpose. You can also implement more granular security permissions by using stored procedures (the calling user’s name can be based as a variable) or table permissions. When you install SSRS in SharePoint integrated mode, you can use teh built-in security permissions for securing report folders or for applying specific permissions on reports individually. If you have further questions, please see the Microsoft SSRS Forums at http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads. I hope this helps! – Anil
#36 by Ashish on July 7, 2011 - 6:37 am
Quote
Thanks for the reply Anil.
I know there’s option to handle security part when you configure your Reporting service in native mode. But if I configure it for SharePoint integrated mode than It shows me error like “This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) Get Online Help”.
Can you please let me know how can I assign security for all the reports that are published on the SharePoint document library?
Thanks
Ashish
#37 by Anil Desai on July 7, 2011 - 8:56 am
Quote
Ashish: I believe the basic approach you’re looking for is to use Sharepoint permissions for folders that store reports. The following MSDN / TechNet links should provide you with some more details on how to configure authentication and permissions:
http://msdn.microsoft.com/en-us/library/bb283150.aspx
http://technet.microsoft.com/en-us/library/bb283324%28SQL.90%29.aspx
I hope this helps! – Anil
#38 by RAJESH on July 23, 2011 - 5:53 pm
Quote
HI ANIL,
WHAT IS THE MEANING OF “R2” IN SQL SERVER 2008 R2
#39 by Anil Desai on July 25, 2011 - 6:58 am
Quote
Rajesh: “R2” stands for “Release 2”, a relatively new marketing name Microsoft is giving for signfiicant updates to its products. It is really confusing, as SQL Server 2008 R2 could have been called SQL Server 2010 or something that signifies that it’s a major update. Internally to SQL Server, version 2008 is known as 10.0, and version 2008 R2 is known as 10.5. I’m not sure of the reasons for using a new type of product numbering/naming scheme, but it does seem to be the standard for now. I hope this helps!
#40 by Edgardo Alessandro Sanchez-Lund on August 17, 2011 - 8:45 am
Quote
I have visual studio 2010 installed, and Microsoft SQL Servers 2008 R2 as well as Report Builder 2.0 Now as i understand it i need VS 2008 installed to gain access to the BIDS enviroment. Is the BIDS a free add one supplied by CodePlex ?
#41 by Anil Desai on August 17, 2011 - 8:52 am
Quote
Edgardo: BIDS uses the Visual Studio shell, but it doesn’t require a full installation of the Visual Studio development environment in order to run. BIDS is installed as part of the SQL Server setup process (I believe it’s included in “Workstation Components”, if I remember correctly). Just re-run SQL Server setup, and you should have the option to install it. I hope this helps!
#42 by Uju Onwuachu on September 1, 2011 - 10:20 am
Quote
Hi Anil,
I am a Web Developer but Microsoft’s Reporting Service is new to me.
I have raw data in an MS SQL Database and intend to create a really comprehensive report consisting of multiple pages / sub-reports; sub-reports which could invariably be exported / published individually as pdfs and in various other ways, such as html, later. Some research led me to Microsoft SQL Server 2008 R2 Report Builder 3.0, which I have downloaded and started reviewing.
I intend to create a set template and import data from my datasource/database for each sub-report, which will have its own unique identifier.
Is Microsoft SQL Server 2008 R2 Report Builder 3.0 able to achieve this? Does it support batch procesing or is it designed for small reports? Would you suggest I do this via Visual Studio 2008?
#43 by Anil Desai on September 1, 2011 - 10:57 am
Quote
Uju: These are good questions, and I think I understand what you’re trying to do from a conceptual standpoint. Sub-reports in SQL Server Reporting Services (SSRS) are basically just reports themselves. Usually, you can run them indepdently of the main report, or included as parts of other reports. Of course, you can also pass parameters between reports and sub-reports to make them more dynamic.
I’m not completely clear on what you’re trying to do from a report generation standpoint. SSRS reports can pull data from a wide variety of different data sources and can combine them. However, you’ll need to define the format of a report, even if it’s just a single table. Users can easily export to HTML, Office, PDF, and other formats. You just need to make sure that the design of your report keeps in mind the intended output format (page-based vs. HTML, for example).
As far as “batch processing”, I think this is more of a report deployment and configuration issue. Report Builder doesn’t “run” reports (except for development purposes). That’s the job of SSRS. The SSRS server site allows you to configure report execution times, caching, history retention, etc.
In short, I think SSRS can do what you plan to do. I hope this helps! – Anil
#44 by Uju Onwuachu on September 2, 2011 - 5:00 am
Quote
Thanks for your prompt reply Anil.
Thanks for the insight on batch processing. I’ll look into SSRS.
About what I’m trying to achieve, I’ll explain better…I have over 500 records in a database, each with a unique identifier. I wish to create a few templates (maybe 6), and then assign each record to an applicable template. Thus, one template could be used by over a hundred records.
How do I achieve this with icrosoft SQL Server 2008 R2 Report Builder 3.0? Is this possible?
#45 by Anil Desai on September 2, 2011 - 8:27 am
Quote
Uju: You’re welcome. Yes, I think what you want to do should be fairly easy. Basically, you can create a report that returns all the data you need and then use page breaks as groupings. This isn’t the best forum for help with report design, so if you have more detailed questions, I’d recommend posting them to the appropriate Microsoft Technical Communities group. Good luck! – Anil
#46 by Kat on December 15, 2011 - 4:36 pm
Quote
Hi Anil. I’m trying to create a Report Model to be used by our end users so that when they need something they can select the information they want themselves instead of asking us to create a new report for them. Here’s where I run into a problem. I created the RModel and deployed it to our report server which used Report builder. When I open the RModel in Report builder the dsource is there, but the dset is not. I have to add a new dset, create a query, and pull over all the columns. This process seems to make creating the model moot. Our end users shouldn’t have to be creating queries. In 2.0 when you open your model, poof all your attrubutes are there ready to be selected to a report. It’s different in 3.0 and i am having a tough time figuring this out. I am new to report modeling so if you can parse thru my horrible description and know what I’m doing wrong I would greately appreciate the help.
~Kat
#47 by Anil Desai on December 15, 2011 - 5:36 pm
Quote
Kat: I think I undersatand your question – thanks for all the details. You’re definitely trying to use Report Models in the way that they’re intended. Basically, they’re supposed to be a layer of abstraction between your underlying data table structure and what users are familiar with. Shared datasets are a new feature in SQL Server 2008 R2’s Reporting Services, but I’m actually not sure about how they interact with Report Models. I’d suggest posting your question to the SQL Server 2008 R2 Reporting Services Forum, as I’m sure someone there would have had some experience in setting this up. Let me know if I can help in some other way. – Anil
#48 by Kat on December 16, 2011 - 8:50 am
Quote
Thanks. I’ll see what they say.
~Kat
#49 by Lubna on January 11, 2012 - 10:58 pm
Quote
Hi
I have a problem with my report when I try to run it it takes a long time. it was working fine before but I have this problem recently, so can you hlep me to find the problem please.
Many Thanks
#50 by Anil Desai on January 12, 2012 - 10:31 am
Quote
Lubna: Unfortunately, there are many different potential causes of slow reports, including caching issues, Report Server database configuration, issues with the reports themselves, and issues with the data source. If you can provide more details, I’d recommend posting your question to the Microsoft Technical Communities SSRS site.
#51 by Tung Yen Lin on January 30, 2012 - 10:58 am
Quote
I deployed my rdl from vidual studio for SQL server 2008 R2. It looks like every thing works fine without any error. But after the deployment, I am not seeing any of my rdl files.
What is my configuration setting problem here?
#52 by Anil Desai on January 30, 2012 - 11:59 am
Quote
Tung: From your description of the problem, I’m not sure about the cause. If you can’t get to the report site (http://MachineName/reports), then you might need to run the Reporting Services Configuration utility. Check the site bindings (URL and port). However, if deployment worked properly, it sounds like the configuration is correct. If you still have problems, I recommend posting more details to the appropriate Microsoft Technical Communities site. – Anil
#53 by Lynette on January 30, 2012 - 1:44 pm
Quote
Hi Anil,
Does Report Builder 3.0 support Microsoft Access 2010 databases??
Also – recently we installed Access Services on our Sharepoint 2010 server (Native)- we had Report services running. When we installed in Integrated mode – it broke the reporting – is there any way to revert back to native mode?? And will access service work in native mode??
Thank you
#54 by Anil Desai on January 30, 2012 - 4:41 pm
Quote
Lynette: Report Builder 3.0 should allow you to connect to and retrieve data from an Access 2010 Database. SQL Server Reporting Services (the server-side services) require SQL Server, but you can pull data from any supported data source. I believe the process for changing the SSRS mode is to remove the service and reinstall it with the correct integration mode (you can do this by re-running SQL Server setup). Unfortunately, I’m not familiar with Access Services. You might want to post your question to Microsoft’s SQL Server Reporting Services Forum. – Anil
#55 by jack on March 1, 2012 - 9:35 pm
Quote
I’VE INSTALLED MS VISUAL SUDIO (ORIGINAL VERSION)…THE INSTALLATION WAS SUCCESSFUL..BUT WHEN I
RUN A (CONSOLE APP.)C# PROGRAM …THE COMMAND PROMPT JUST FLASHES AND DISSAPEARRS….IAM NEW TO PROGRAMMING…I’LL BE GREATFUL IF U CAN HELP ME…
JAGAN , CHENNAI…INDIA
#56 by Anil Desai on March 2, 2012 - 9:11 am
Quote
Jack: I haven’t run into this issue before, so I’m not sure what the cause/solution might be. You could look in the Build settings in the properties of your project to see if there are any pre- or post-compile options that are set. – Anil
#57 by Dinesh Aruru on June 13, 2012 - 5:06 am
Quote
i am developing a wpf desktop application using microsoft visual studio 2010. For all the data i am using microsoft sql server 2008 r2 which includes all the tables required for my application. Now i wanted to create reports based on the data in the tables. So i just wanted to know how to get started as i am totally new into this. Thanks in advanve
#58 by Anil Desai on June 13, 2012 - 9:30 am
Quote
Dinesh: There are dozens of excellent resources for getting started with SSRS. You can find most by doing a web search for specific topics you’re interested in. Specifically, search for “How Do I?” videos from Microsoft that can help get you started quickly. Also, MSDN and Codeplex have dozens of sample databases and reports to get started with. If you’re looking to integrate reports in your own application, be sure to look for information about using the ReportViewer control in .NET and ASP.NET applications. I hope this helps! – Anil
#59 by Dinesh Aruru on June 16, 2012 - 3:30 am
Quote
Hey Anil,
I created a sample report using Microsoft Business Intelligence Studio.
Now I want to display this report at the click of a button in wpf application in Microsoft Visual Studio 2010.
Can you please help me with this.
#60 by Anil Desai on June 16, 2012 - 2:38 pm
Quote
Dinesh: I haven’t embedded any SSRS reports in a WPF application myself, but doing a basic search for “ssrs wpf” turned up a lot of results that might be helpful. If you’re unable to find what you need, I suggest posting on the Microsoft SQL Server Reporting Services Forum (http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/threads) . – Anil
#61 by Barbara on August 8, 2012 - 2:03 pm
Quote
I have installed SQL Server 2008 R2 on my computer. I went thru the configuration manager to set up a deployment. The problem is, I’ve used some features on my report that are only available in the r2, such as lookupset, and I’m getting this error on deployment: Error 1 The report server at ‘http://localhost/ReportServer’ is an earlier version than the one specified in the TargetServerVersion property. The RDL files generated by the build process are incompatible with the report server. Change TargetServerVersion to ‘SQL Server 2008’. AZ Reports 0 0 In other words, localhost/reportserver is still on SQL Server version 2008, not SQL Server 2008 r2. Interestingly, I have no problems building the solution in BIDS using SQL Server 2008 R2 syntax, I just can’t deploy reports with the R2 features to localhost. I’m not sure what is going on, if you can help it would be appreciated.
#62 by Anil Desai on August 9, 2012 - 8:53 am
Quote
Barbara: I think I understand the issue, and I can take a couple of guesses about the cause. First, are you sure that the local SQL Server instance you’re using has been upgraded to SQL Server 2008 R2? If updated only the report development tools (or you’re using Report Builder), it’s possible that the local server instance itself is running an an older version. That seems most likely. The other potential issue is that the deployment settings for your project are set to SQL Server 2008 as the target version. You can change this my accessing the Project properties and attempting to redeploy. I hope this is somewhat helpful in resolving the problem. If not, please consider posting on the Microsoft SQL Server Reporting Services Forum (http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/threads)
Pingback: Visual Studio 2008 « Madkin Station
#63 by soheila on August 21, 2013 - 7:49 am
Quote
Hi Anil,
I have SQL Server 2008 R2.when I create report with ReportBuilder 3.0 it gives me .rdl file with 2010 version. Ican’t open it in Dashboard which I work with it and it gives me this error:Your RDL file has wrong file format. Please use SQL Server (2005 or 2000) Business Intelligence Development Studio to create the RDL file.
what can I do in order to open this report in my Dashboard?
#64 by Anil Desai on August 21, 2013 - 8:54 am
Quote
Soheila: It sounds like your reporting server is running an earlier version of SQL Server. If you want to edit reports in an earlier version of the .rdl file format, you can use earlier versions of Report Builder. In your case, I believe the first Report Builder version (1.0) will work. Alternatively, you can install the Business Intelligence Development Studio by running the appropriate version of SQL Server setup (e.g., SQL Server 2005) and choosing the Workstation Components. I hope this helps! – Anil
#65 by soheila on August 25, 2013 - 5:39 am
Quote
Hi Anil,
as you said I use Report Builder version (1.0) and create report but when I open it in Dashboard I give this error:The Value expression for the textbox ‘BranchName_Value’ contains an error: [BC30451] Name ‘CreateDrillthroughContext’ is not declared.for each source of data that I use , I give this error.can you help me please?
#66 by Anil Desai on August 25, 2013 - 6:06 am
Quote
Soheila: It sounds like you’re making some progress. Unfortunately, I haven’t run into this issue before, so I’m not sure what the problem is. I recommend that you post your issue to Microsoft’s SQL Server Reporting Services forum: http://social.technet.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices&filter=alltypes&sort=lastpostdesc. Hopefully, someone there will be able to help. – Anil
#67 by Ellen on March 3, 2014 - 3:05 pm
Quote
I am looking high and low for material on a bit more advance techniques using Report Writer SSRS and SSIS.
I want to do some more advance IF(AND statements but cannot find proper syntax.
For example:
IF(AND(Condition1=100,Condition2=Blue),True,False)OR(IF(Condition1#100),True,False)
Where can I find training to help me with this and other statements that are beyond basic training.
#68 by Anil Desai on March 3, 2014 - 4:35 pm
Quote
Ellen: SSRS uses a VB-like syntax for conditional statements, and it looks like you’re on the right track. A good starting point for learning about the expression syntax is available on TechNet: http://technet.microsoft.com/en-us/library/ee240847.aspx. MSDN also has some resources for looking into VB conditional epxressions. In your case, it looks like you’ll want to use nested IIF statements; some examples are provided in that link. I hope this helps! – Anil