I'm developing an SSRS in Visual Studio BIDS. In it, I have a link that links to another report (report A). Report A has 4 parameters (dates). When I click on that link, it goes to report A fine, but the 4 parameters in report A are hidden (I would have to click on the arrows to show them and edit them). How can I make the link link to ...
When I create a new Reporting Services report or try to open an existing report (that has been working) in Visual Studio 2008. I cannot view the design. I get no error message and it only shows html code in the "Design View". I've tried reinstalling VS2008 and BIDS, but hasn't worked. This was all working when I last used it 2 weeks ago....
I'm making reports in Business Intelligence Designer Studio (VS 2005). My reports will be viewed primarily on the screen, and I'd like to change my ruler to pixels instead of inches. Is this possible? ...
Hi, all Is that possible for BIDS to build a SSIS package on remote SQL Server instance? Since I only have SQL Server Standard Edition on the production server. BTW, when I use BIDS to build a Integration Service Connection Project, it throws a exception like this: exception of type 'System.Exception' was thrown And nothing is created....
Hi there, This is my first question so bear with me, i will also attempt to answer one somewhere if i can as payment, though not sure my skills are up to it yet. I have a stored procedure in SQL 2008 that at the moment executes with a result of about 600 odd rows, it has unions within it and a user defined function used multiple times....
Symptoms A stored procedure that excecutes in a timely fashion ( from 10 to 30 seconds ) in SSMS takes up to 15min or hangs on Reporting Services or Visual Studio 2005. Tried in my case I made sure to use the same parameters and the same security context on both. cutting and pasting the stored procedure body doesn't work, due to som...
So far in this project I have two reports in VS2008/BIDS. The first one contains 1 tablix and is about 100k. The second one contains 3 tablixes (tablices?) and is about 257k. I can successfully deploy the smaller report from VS and I can upload it from the Report Manager in IE. I can view/run it from Report Manager and I can get to t...
I am getting the following error when deploying. This is in a cube which was working fine, all that has changed is a key column in one of the dimensions. Internal error: Failed to generate a hash string I have no idea what is causing this but even if I change the dimension back to how it was and try to deploy I get the same error. If...
I already have Visual Studio 2008 installed. When installing developer Sql Server 2008, do I need to check the Business Intelligence Development Studio option? I'm guessing not. I assume if I already have VS 2008, the install will just add the relevant Sql Server related project types into VS 2008. EDIT: I marked the question answer...
does BI studio come bundled with another software? i am trying to create a report server for SSRS but am not able to find BI on my computer and cannot find a place where to download. thank you! ...
Hi, I have an rdl file uses custom MDX to generate a dataset. The file is opening in Design MOde and removing the custom mdx. How do I stop it from opening in Design Mode? Many THanks, S ...
Hi. We are a team working on a bunch of SSIS packages, which we share using version control (SVN). We have three ways of saving sensitive data in these packages : not storing them at all storing them with a user key storing them with a password However, each of these options is inconvenient while testing packages saved and committed...
I am finding a lot of useful help here today, and I really appreciate it. This should be the last one for the day: I have a list of the top 10 keywords per site, sorted by visits, by date. The records need to be sorted as follows (excuse the formatting): 2010-05 2010-04 site1.com keyword1 apples wine keyword1 visits ...
Tried to open an SSIS project I had been working on today and received this lovely error: Unable to generate temporary class (result=1) error CS0009: Metadata file 'c:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0_b77a5c561934e089\System.XML.dll' could not be opened -- 'No metadata was found.' Anyone know why this happens and how to cor...
I am trying to update a SSAS 2005 cube adding a ragged hierarchy (it has a few levels that contain members that should be hidden if the member name is the same as the parent). From various sources I have read that I need to use MDX Comparability=2 within the connection string to see the HideMemberIf property. I have read so many opinion...
i went to: menu > tools >options > fonts and colors > business intelligence designers...but nothing happened when i changed the font size. i'm using visual studio 2008 what am i missing here? ...
Hi all, I've been using Microsoft SQL Server Management Studio for multiple manual SQL queries for Excel reports up until this point. I'd now like to automate my processes further with Microsoft Business Intelligence Development Studio and generate reports using this rather than Excel. Here's a rough overview of what I'm looking to do...
Hi all, I'd like to create an in-house solution to store marketing segment, list, campaign, and communication data. Right now nothing is centralized/standardized. Data is located on a variety of SQL servers, Access databases, and Excel spreadsheets. It's been a real pain when it comes to reporting/tracking. I'm in a Microsoft SQL Se...
I spent half an hour trying to figure out what I cant do in SQL 2008 Standard in terms of importing data using SSIS pacakges vs Enterprise edition and simply couldnt find the answer.. I am sure someone already knows that.. Please tell !! :) ...
I know that in order to edit SSIS packages you need the same version of BIDS or Visual Studio. With Visual Studio 2010 is there any change in the ability to open older SSIS packages or do I need to have VS2005 and VS2008 installed along side my VS2010 installation? TIA J ...