Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2008 R2 BI auto complete

Posted on 2013-02-06
4
Medium Priority
?
604 Views
Last Modified: 2013-02-07
I"m creating a  SQL 2008 R2 reports with  Business Intelligence Studio. When I type Value in Expression, it doesn't suggest properties like Visual Studio, auto complete. Is it something I have to manually enable or simply not available?
0
Comment
Question by:crcsupport
  • 2
4 Comments
 
LVL 9

Assisted Solution

by:selva_kongu
selva_kongu earned 800 total points
ID: 38862804
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 38862973
selva_kongu: the links you've posted don't have any relevance to the question.  The question is about intellisense in BIDS (Business Intelligence Development Studio), not SSMS.

crcsupport: the Expression builder does have some intellisense implemented, but you have to type valid statements.  What would you expect to happen when you type "Value"?

To start, your expression should start with =.  Try typing the following in a textbox of a table that's connected with a dataset:

=Fields!

Once you've entered the exclamation mark, you should get a list of fields available in your dataset.  Select one of them and type a dot.  Now you get a list of properties available for the selected field.  A commonly-used one is Value.

Here's another example, can be typed in any textbox:

=Format(

Once you've entered the ( you should get a tooltip that describes the function usage.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 1200 total points
ID: 38862978
One more example (I really like this one):

=DatePart(DateInterval.

From the function tooltip you see that the first parameter is of type DateInterval, which happens to be an enumeration. Once you've entered the . following the type, you get a list of possibilities.
0
 
LVL 1

Author Comment

by:crcsupport
ID: 38864537
I am new to SSRS was following MS tutorial, the one that I saw seems like having syntax error which doesn't exist anymore. I found the reference in MS Library and it works, now shows suggested next word.

Thanks all.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question