Stack Overflow
Stack Overflow

Questions tagged [bids]

Business Intelligence Development Studio (BIDS) is a special version of Visual Studio that is used to develop projects for SSIS, SSAS, and SSRS.

The Business Intelligence Development Studio (BIDS) is a tool that Microsoft has released to create projects surrounding the Microsoft SQL Server tools. These tools include the Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS). Developers use the Visual Studio development platform to create these projects. Each SQL Server tool comes with an installation of Visual Studio (BIDS). You cannot get BIDS without having at least a developer copy of one of the Microsoft SQL Server tools.

For more about BIDS and its role in developing projects for SQL Server tools, go here:

http://msdn.microsoft.com/en-us/library/ms173767.aspx

736 questions
0
votes
2 answers

SQL View Columns

This is probably a strange question... Hopefully, someone enjoys the more esoteric portion of SQL. :) I have some views with many columns. The column widths are obstructive to reviewing the data. Once a column width is manually adjust and the…
Uziel
  • 349
  • 4
  • 9
0
votes
2 answers

Generating barcode for a field value in CRM 2011 reporting

I want to generate a barcode based on the value of a field in a form. I have installed the free 3 of 9 code both on my sql server and my crm server. The field which I want to be converted to barcode has the font set to code 39 in BIDS and it shows…
hkhan
  • 843
  • 2
  • 19
  • 45
0
votes
1 answer

Repeat static row on new page of tablix, included in another tablix

I have a 1:n relation from company to visit reports. I want to display details of related visit report in a tablix. So I created one tablix with grouping on company-id and put a second tablix (grouping on visit-report-id) in the second tablix…
Marvin
  • 539
  • 5
  • 17
0
votes
1 answer

Parameter x is missing a value bids 2008

I created a new report for an overview of a company. I added a report parameter, which default value is determined by query. But if I run the report and this query returns no results, I get the error "Parameter x is missing a value." I found this…
Marvin
  • 539
  • 5
  • 17
0
votes
1 answer

what's the purpose of the .database file in the ssis bids solutions?

I Cannot find a link with more details. I think it's not necessary to check in that (same as .suo). It does not seem to change changing the structure of the solution files Ex adding new ssis packages or similar so I want to know it I can avoid to…
rio
  • 685
  • 9
  • 16
0
votes
1 answer

Add days to an Oracle Date in SSRS

I'm connecting to ORACLE data for SSRS purposes, using Microsoft Business Intelligence Development Studio. I need to return data where a date is less than 15 days from today. I've tried the sql that works in ORACLE: <= to_char(sysdate,…
Neil Deeley
  • 57
  • 1
  • 9
0
votes
2 answers

SSRS Report: Use optionset labels of specific language

we have a Multilanguage MSCRM 2011 environment, with German base language. I want to create a report for all languages, but the labels of optionsets should always be shown in English language independent of the client language. I am using a Fetch…
Marvin
  • 539
  • 5
  • 17
0
votes
1 answer

How to pre filter reports in SQL for CRM 2011 on-premise

I am building a SSRS report in BIDS for my crm 2011 on-premise. Following is my query to show the record along with the image saved in annotation of the record. When I run the query it returns the result for all the records rather than the one…
hkhan
  • 843
  • 2
  • 19
  • 45
0
votes
2 answers

SSRS - Programmatically import built Reports

Are there any known good practices on how to import Reports into Reporting Services, without using it's built-in GUI? I'm in a situation where a project need to upload and update reports to a report server easily, but also be able to easily switch…
Independent
  • 2,924
  • 7
  • 29
  • 45
0
votes
0 answers

SSRS BIDS bind two tables together OR multiple datasets per table

I have a report matrix with several columns, where each column shows the same kind of data but with different filters. Specifically, I'm showing some aggregate numbers, but each column shows it for a different time period (one may be daily, another…
Egor
  • 1,622
  • 12
  • 26
0
votes
1 answer

Recurring quarterly query with Excel email attachment using Business Intelligence Dev studio

This is my the first time creating a reporting service. I have a query that i need to set to run on a quarterly subscription, when it finishes the query it needs to send an Excel file by email. I was pointed to use BIDS to create the RS report, i…
JosephK
  • 101
  • 1
  • 2
  • 13
0
votes
1 answer

SSRS Numbers Removing Decimal and keeping trailing numbers

I have a Report Using SSRS BIDS 2008 R2. I am looking for a method of converting my number by simply removing the decimal. I want to keep the numbers after the decimal just remove the '.' The Goal: Format a number (currently a currency) into a…
Bactos
  • 1,233
  • 14
  • 26
0
votes
2 answers

SSIS:Which logging mechanism is better SQl server or Text File

SSIS has different logging mechanism. I am bit confused which logging mechanism should be used. Should I use SSIS log provider for text file or should I use SSIS log provider for SQL server. Which would give better performance? Or is there any…
Sachin
  • 57
  • 1
  • 1
  • 11
0
votes
1 answer

Subreport is not refreshing in main report, though it is set to autorefresh

I have used a Guage as a clock. It is set to auto-refresh for every 3 sec. It is running properly, but whole report is refreshing, reloading. So cant get a feel of a clock. So I tried to use this (Clock) report as a sub-report in another report (say…
Aditya
  • 2,299
  • 5
  • 32
  • 54
0
votes
1 answer

SQL Server Integration Services throws "Error Starting Debugging" - Failed to start project

Several of my colleagues and I are experiencing a problem: we are trying to use the Visual Studio Business Intelligence Designer (BIDS) to create and debug SQL Server Integration Services packages. In nearly all cases, we encounter the error…
Keith Adams
  • 1
  • 1
  • 3
1 2 3
…
49 50