Putting Reports in Folders

Using Visual Studio I am trying to arrange my reports.
Here is what I have found:
1. I cannot create folders in Visual Studio.
2. I can deploy individual reports after changing the project property
(destination folder) to have reports arranged in folders.
3. I can deploy multiple projects - each landing in different folders
to have reports arranged in folders.
4. I can deploy a project the vanilla way then in Report Manager move
reports to other folders.
My disappointment is with number 1.
Number 2 is a pain in the neck.
If I do number 3, I have to have so many Data Sources defined it's a
mess.
Number 4 is so much work, I hate it.
HERE'S THE QUESTION
What's the best way to do it?
Thanks in advance.
JerryI am doing #3 & have a folder on Report Manager to share the Data sources.
Data sources still are moved along with the reports to their corresponding
folders. I moved those ones to the shared Data Sources folder, and it works
pretty good for me.
- David
"Jerry Nixon" wrote:
> Using Visual Studio I am trying to arrange my reports.
> Here is what I have found:
> 1. I cannot create folders in Visual Studio.
> 2. I can deploy individual reports after changing the project property
> (destination folder) to have reports arranged in folders.
> 3. I can deploy multiple projects - each landing in different folders
> to have reports arranged in folders.
> 4. I can deploy a project the vanilla way then in Report Manager move
> reports to other folders.
> My disappointment is with number 1.
> Number 2 is a pain in the neck.
> If I do number 3, I have to have so many Data Sources defined it's a
> mess.
> Number 4 is so much work, I hate it.
> HERE'S THE QUESTION
> What's the best way to do it?
> Thanks in advance.
> Jerry
>sql

Putting Multiple Field data in a report table cell

I'm using report designer and Visual Studio .net 2003. I have a table in the report and would like to put multiple field values in a single cell. Something along the lines of this in the cell: =Fields!Phone.Value, Fields!.Fax.Value.

I don't know how to seperate the values to get them to work in the same table cell. I've tried commas, semi colons, spaces, parens.

How would I do this?=Fields!Phone.Value & " " & Fields!Fax.Value should work.
|||Great that works!

One other question, if I put a symbol (comma, semicolon) in the between the ampersands, how do I get it to leave the cell blank if there is nothing stored in the fields?

For example, say I have =Fields!Phone.Value & ", " & Fields!Fax.Value in the cell but when there is no values for those fields the cell is ", ".|||=Fields!Phone.Value & ISNULL(Fields!Fax.Value,"",",") & Fields!Fax.Value should work?
Otherwise you can try using IIF.
|||I couldn't use IsNull because it says it is not decleared. I can use IIF, so the correct code is =Fields!Phone.Value & IIF(Fields!Fax.Value=nothing,"",",") & Fields!Fax.Value

Thanks for your help.

sql

Publishing Web Application

Hello to everybody.

I got a problem like this:

I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.

Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.

I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.

I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.

Can anybody solve my problem?

Thank You

Can you post your connection string please|||

This first is the original connection string in web.config defined in the developpement area:

<add name="ASPNETDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

This one is the connection to the server (SQL STD):

<add name="ASPNETDBConnectionString1" connectionString="Data Source=SERVER\SQLSERVER;Initial Catalog=ASPNETDB;Persist Security Info=True;User ID=user;Password=password" providerName="System.Data.SqlClient"/>

Thank You.

Mauro

Publishing reports to different versions

I have Visual Studio 2005 and Reporting Services 2005 on my client development machine.

I want to publish the reports to an SQL Server 2000 with Reporting Services 2000 server, is this possible?

I get the following error message:

The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) Get Online Help

Thanks.

Bruce

Unfortunately, you will not be able to use the 2005 report designer to publish directly to a 2000 report server. This is due to the fact that the RDL's (Report Definitions) created are different between Report Server versions. You can however use the 2000 report designer to publish to a 2005 server, as it support auto-upgrade of the reports.

Thanks, Jon

Published Report Not Showing Correctly in Report Manager webpage

have a report that in the designer in Visual Studio it displays correctly on
the preview tab.
The report has 5 subreports and one of the subreports is a matrix.
On the report I have a parameter for the user to choose rather to see the
matrix subreport or not.
When I view the report in the report manager web page and the user select to
yes to view the matrix sub report, the main report is missing fields and
formatted incorrectly, if you select no on the parameter for viewing the
matrix sub report, the fields return on the main report but are still not
alligned correctly. None of the missing fields have any expressions to
control the visible property , only the matrix sub report. The matrix
subreport is several inches away from any of the fields that end up missing.
The fields that are missing are unbound textboxes used as labels.
I tried to delete the report from the report server and re-deploy but still
the same effect.
Why is the report manager different than the Visual Studio preview and
causing this bug?What version are you on? In RS 2000 the report designer had its own
renderer. In RS 2005 it uses the same rendering engine as the server does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RBS" <RBS@.discussions.microsoft.com> wrote in message
news:831D8D9D-B3C2-485D-8B16-089A6DC76563@.microsoft.com...
> have a report that in the designer in Visual Studio it displays correctly
> on
> the preview tab.
> The report has 5 subreports and one of the subreports is a matrix.
> On the report I have a parameter for the user to choose rather to see the
> matrix subreport or not.
>
> When I view the report in the report manager web page and the user select
> to
> yes to view the matrix sub report, the main report is missing fields and
> formatted incorrectly, if you select no on the parameter for viewing the
> matrix sub report, the fields return on the main report but are still not
> alligned correctly. None of the missing fields have any expressions to
> control the visible property , only the matrix sub report. The matrix
> subreport is several inches away from any of the fields that end up
> missing.
> The fields that are missing are unbound textboxes used as labels.
>
> I tried to delete the report from the report server and re-deploy but
> still
> the same effect.
>
> Why is the report manager different than the Visual Studio preview and
> causing this bug?
>