November 20, 2006 at 1:42 pm
I am using Reporting Services for SQL Server 2000. Within Visual Studio where the reports are designed the help contents lists Visual Studio .Net, MSDN Library and Reporting Services Books Online.
However when you use the index or search functions how do you limit the results to Reporting Services Books Online? It is not one of the filters available. For example, I have justed posted a thread for a problem with page breaks, so first I tried searching for page breaks in the help, but it comes up with help for Visual Fox Pro reports. I find this very annoying.
Can someone please tell me how I can limit the search to Reporting Services help?
Thanks,
Mark.
November 21, 2006 at 7:11 am
This may not be much help and is more of a backend solution rather than controlled in the reporting services output. when performing the select do something like SELECT TOP X var1, var2,... from table.... where.... order by...
where X is the number of results you are requiring. Obviously a sort order would be required lets say if you wanted the last 50 results for a particular date range.
** What you see, Depends on what you Thought, Before, You looked! **
November 21, 2006 at 9:36 am
>>
However when you use the index or search functions how do you limit the results to Reporting Services Books Online? It is not one of the filters available. For example, I have justed posted a thread for a problem with page breaks, so first I tried searching for page breaks in the help, but it comes up with help for Visual Fox Pro reports. I find this very annoying.
<<
With the caveat that I have a lot of trouble getting the index and search functions to do *anything* useful, whether it is available as a filter or not...
Here is what seemed to be best:
-- I didn't filter on the content in the dropdown over the index **
-- in Search, I set to All languages (ie nothing checked), Technology: SQL Server Reporting Services, and Content Type: Documentation & Articles.
Although it wasn't perfect, this did list a Source of RS for the top 4 or 5 entries when I tried a search on "page breaks", and many more for RS than for anything else in the top 100 that I brought back. Note that I sorted by Rank, not by Source, since if you sort by Source all the ASP stuff will be first in the list. <sigh>.
**But... hmmm. In the content dropdown over the index, I *do* see SQL Server Reporting Services. So maybe we're using a different type of installation of Visual Studio?
In About Visual Studio, do you use RS listed as one of the installed products?
>L<
November 21, 2006 at 1:34 pm
Lisa, your setup sounds completely different. In Help About the installed products includes "Microsoft SQL Server Report Designer", which I assume is Reporting Services, because when you choose Help Contents one of the options is Reporting Services Books Online.
However in either Index or Search there is only one list for filtering. It is labelled "Filtered by:" and contains the following options:
(no filter)
.NET Compact Framework
.NET Framework
Enterprise Servers
Internet Development
Office Development
Platform SDK
Visual Basic
Visual C#
Visual C++
Visual FoxPro
Visual J+
Visual Studio
Visual Studio Macros
I don't have any Technology or Content Type options. Is that SQL Server 2005?
Mark.
November 21, 2006 at 2:20 pm
It is SQL Server 2005, but the filtering options (Technology and Type) are a function of Visual Studio Help, not SQL Server.
This is Visual Studio 2005. If you are using that, you should see them.
Yes, SQL Server 2000 (and RS for it) may integrate differently into Visual Studio 2005) than the 2005 version of Sql Server (and RS). This would only change the checkboxes you saw under Technology and Type, however. It would not eliminate these filter sets entirely.
So... which version (and which level) of Visual Studio are you using??
>L<
November 21, 2006 at 2:42 pm
In Help About it is listed as Microsoft Development Environment 2003, version 7.1.3088. In the start menu it is listed as Microsoft Visual Studio .Net 2003.
We have not used Visual Studio before. It was only installed because we want to use Reporting Services. So I'm not sure what you mean by "which level".
Mark.
November 21, 2006 at 2:55 pm
OK IC. It makes sense that RS 2000 extrudes a limited version of VS 2003 out as a suggested IDE during setup...
Sorry, Mark, I can't check Visual Studio 2003 at the moment to give you any advice on this... I can't remember how the help features work on it. I will try to check this later and report back.
However, you don't usually have to get at help from within Visual Studio.
Check your start menu. Under Microsoft SQL Server 2000, you will probably find a link specifically for Books OnLine (standalone invocation of the helpfile, IOW). If memory serves you will also find a folder in that location specific to RS. In that folder you will find a link to RS-specific help.
I often find it's more convenient to access help standalone, rather than within *any* VS environment, anyway. Not just right content, better performance.
HTH,
>L<
November 21, 2006 at 3:13 pm
Thanks Lisa, that does help. I would have thought that if Reporting Services was listed in the help contents you would also be able to filter for that in index and search. However the answer as you suggest is to avoid help altogether within Visual Studio. I will use the standalone help from now on.
Mark.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply