Cannot add a new folder under a Reporting Server Project

SQL Server Reporting Services

Index ‹ SQL Server
- Archive
  - SQL Server
  - VS 2008
  - Smart Device
  - Architecture
  - Visual Studio
  - SharePoint
  - ISV
  - IE
  - Visual C#
  - Windows Live
  - Dotnet
  - Windows Forms
  - VFP
  - Windows Vista
  - VB
  - Game
  - VS Express
  - VC++
  - Office

- Previous
  - 1
    - String constants must end with a double quote. when i build the report its working good... the problem arises while deploying the report Tag: Cannot add a new folder under a Reporting Server Project
  - 2
    - Last working day from last year! I need to create a new column with the last working day for each row in the datasource... as for example inside a derived column... How can I do it And I have the problem about holidays... but could be resolved if I have a table wich indicate the holidays for this case in my country Portugal... or have to apply for all the cases using a key to each country... could help me Thanks!! Tag: Cannot add a new folder under a Reporting Server Project
  - 3
    - PDF Rendering bug Hi Russell, The data in one of our tables is written out indented in some cases and our users want to see it as such on the report. I tried issueing the expression "=IIF(Fields!LineTypeCode.Value <> "H" , 15pt,2pt)" in the textbox property left padding. RS shifts each row of data 15pt and I want it to only shift the row when "Fields!LineTypeCode.Value <> "H". What am I missing in the coding of my expression Thanks in advance for assistance. Best regards Tag: Cannot add a new folder under a Reporting Server Project
  - 4
    - Relationships vs. no relationships Arnie Rowland wrote: I think that it is a mistake to assume that at all times, all airlines serving the same city pair will have the same prices and same fare dates. Of course not. I'm sorry, an explanation is needed - FareDate is actually the date on which I inserted a record to the database, not a date of flight. It's called FareDate because both Date and DateTime are reserved keywords and I'd have to use square brackets in SQL everywhere. Tag: Cannot add a new folder under a Reporting Server Project
  - 5
    - Merge replication reinitialization deleted all data I could not reproduce the problem. I tried push and pull SQL 200 subscriptions from a SQL 2005 publication/pulisher. Could you give me more details on what kind of subscription you have and the SP of SQL you are running on both the servers Also can you continue to reproduce this If so, some more details and some steps would be of help. Tag: Cannot add a new folder under a Reporting Server Project
  - 6
    - How to create a SAPConnection in .Net Code with .NET Data Provider In the SQL Server Technical Article Micro s oft .NET Data Provider for mySAP Business Suite is a Code example of how to invoke a BAPI in .Net Code. First line shows how to create a Connection to SAP, but there is no information in which lib the SAPConnection type is stored: SAPConnection con = new SAPConnection ( "ASHOST=<SAPserver >; CLIENT=<client>;SYSNR=<sysnr>;USER=<user>;PASSWD= <password>;LANG=<logon language>" ); con.Open(); Does somebody can help me Tag: Cannot add a new folder under a Reporting Server Project
  - 7
    - What advanced features can be built with code in SQL Server 2005 Reporting Services? Hi, all experts here, Thank you very much for your kind attention. As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you. With best regards, Yours sincerely, Tag: Cannot add a new folder under a Reporting Server Project
  - 8
    - Accessing a real table from inside a TV UDF Well, the error message says you don't have your function marked with the attribute properties as per the error message. Looking at the code you psoted in the other thread it certainly looks like you are using the right property attributes. Make sure that the code that you have deployed to the database do have the right attribute properties, i.e recompile and re-deploy your assembly. I just tested data access from inside a TVF and it works OK for me. Niels Tag: Cannot add a new folder under a Reporting Server Project
  - 9
    - Adding a article causes ALL articles to be refreshed Any more thoughts on this If my replication is setup and running, is there NO WAY to add "one" table to the publication without having to do the Bulk copy on ALL tables Adding a table to replication seems one of the most basic maintenance tasks. I'm still surprised that MSFT has made that basic task so difficult in 2005. Tag: Cannot add a new folder under a Reporting Server Project
  - 10
    - Making a report smaller...? Awesome. That does the job right there. Thanks for the help! Both of you Tag: Cannot add a new folder under a Reporting Server Project
  - 11
    - Connect to SQL Server from a PDA Hi Darren, Unfortunately it didn't solve my problem, here is the complete stacktrace: at System.Data.SqlClient.SqlConnection.OnError() at System.Data.SqlClient.SqlInternalConnection.OnError() at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Connect() at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor() at System.Data.SqlClient.SqlConnection.Open() at DeviceApplication3.Form1.readDatabase() at DeviceApplication3.Form1.btnOpenDB_Click() at System.Windows.Forms.Control.OnClick() at System.Windows.Forms.Button.OnClick() at System.Windows.Forms.ButtonBase.WnProc() at System.Windows.Forms.Control._InternalWnProc() at Microsoft.AGL.Forms.EVL.EnterMainLoop() at System.Windows.Forms.Application.Run() at DeviceApplication3.Program.Main() /JO Tag: Cannot add a new folder under a Reporting Server Project
  - 12
    - Installing Express toolkit I discuss some solutions for the devenv.exe problem in my blog, check out this post . Mike Tag: Cannot add a new folder under a Reporting Server Project
  - 13
    - SQL using 2003 AD Groups We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups Is there a reason for that Can I just add the group without browsing I assume DLG will work with SQL for security. Thanks Brent Tag: Cannot add a new folder under a Reporting Server Project
  - 14
    - How to find out PublicKeyBlob Ahh, thank you! // Andreas Tag: Cannot add a new folder under a Reporting Server Project
  - 15
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser How did you solve the double-hop issue Your statement that DTEXEC connects to SQL Server as Anonymous contradict the statement that it has been solved. SSIS does not do any impersonation or token manipulation internally, thus it will use the process token to connect to SQL Server. Since it connects as Anonymous, something is wrong with this token (that you've created) - double-hop is most common problem. Tag: Cannot add a new folder under a Reporting Server Project
  - 16
    - deAttach database Yep here is some sample code from Microsoft to get you started. Hope this helps. http://msdn2.microsoft.com/en-us/library/ms162139.aspx Tag: Cannot add a new folder under a Reporting Server Project
- Next
  - 1
    - Generic calculated measure Hi I have to create a calculated measure which is applicable for 16 measures. How can i specify it in a generic manner for eg: create member currentcube.ytd as sum(ytd(),[measures].[sales units]; here my scenario requires the calculation of YTD for many other measures also other than sales units so can i have something instead of [measures].[units], so that it will be generic. Thanks in advance. Tag: Cannot add a new folder under a Reporting Server Project
  - 2
    - SSIS Randomly Empties Out Column Data While Using Flat File Source I'm having a problem using the Flat File Source while using the underlying .Net classes to execute SSIS Packages. The issue is that for some reason when I load a flat file it Empty's out columns randomly. Its happening in the Flat File Source Task. By random I mean that most of the times all the data gets loaded but sometimes it doesnt and it empty's out column data. Interestingly enough this is random and even the emptying out of columns isnt a complete empty, its more like a 90% emtpying. Now you'll ask that is the file different everytime and the answer is NO. Its the same file everytime. If I run the same file everytime for 10 times it would empty out various columns maybe 1 of those times. This doesnt seem to be a problem while working with dtexec or the Package Executor utility. Need Help!! Tag: Cannot add a new folder under a Reporting Server Project
  - 3
    - Validating the parameter text box Hi, I have one date parameter in my report. The user will be able to manually enter or use the calendar control. In the case of entering manually, is there any way to validate the input string How can we prevent users from entering alphabets Also, is there any way to reduce the length of the parameter textbox. Can you please help Thanks, Sonu. Tag: Cannot add a new folder under a Reporting Server Project
  - 4
    - aggregation question Check out the link below for a solution that uses the built-in aggregates to compute product: http://www.umachandar.com/technical/SQL6x70Scripts/Main21.htm You can also write a SQLCLR aggregate in SQL Server 2005 to do the same. Tag: Cannot add a new folder under a Reporting Server Project
  - 5
    - date output format Hi, I have the following problem. I have made a parametered report where i ask a begin date (@datefrom) and an end date (@dateto). when i enter my dates via the little calendar is see the format dd/mm/yyyy When i do a preview of report i have a textbox with the following expression : = "Total work time from " & Parameters!DateFrom.Value & " to " & Parameters!DateTo.Value but the output of the date format is mm/dd/yyyy. What can i do to have the output format dd/mm/yyyy Vincent Tag: Cannot add a new folder under a Reporting Server Project
  - 6
    - how to change the actual data filename i'm hoping someone can help me out with this problem. i have a database called Tracking.mdf and its associated logfile Tracking_log.ldf i need to build another database based on the above with more tables and keep the data separate hence the requirement to make a copy of the tracking data file i've tried changing its name but it will not attach. i can change its database name to whatever i want but somehow can't find out how i can say change its actual filename to Tracker.mdf and Tracker_log.ldf would someone be able to help me out. thanks. Tag: Cannot add a new folder under a Reporting Server Project
  - 7
    - MSResultSetGenerator does not work any more Thanks, but I'm already running VS as admin. Tag: Cannot add a new folder under a Reporting Server Project
  - 8
    - Best Practice for Counts/Distinct Count Measures for Filtered Data Let's say the Count/Distinct Count measure is based on filtered data. When the situation allows, is it better to do a CASE statement with 1s and 0s from the table in the DSV and then do a SUM on this field Or is it better to create a new Named Query in the DSV filtering out the data through the WHERE clause based off of the original table and then do a DISTINCT COUNT measure on the newly created Named Query If there's no clear cut answer as to what is the "better" approach, please offer up the advantages and disadvantages for both. My preference is best performance. An Example : Measure: Active SKU Count Products dimension has product_key, SKU and Status In the DSV for the Products dimension, should I add a CASE statement: CASE WHEN [Status] = 'Active' THEN 1 ELSE 0 END AS [Active Status] Then create a new SUM measure based on the Active Status column. OR Create a new Named Query in the DSV: SELECT * from Products WHERE Status = 'Active' Then create a new DISTINCT COUNT measure based on the SKU column from the new Named Query Tag: Cannot add a new folder under a Reporting Server Project
  - 9
    - another dynamic assembly loading problem (XmlSerializer) Steve - the assembly is not getting generated with the "Generate Serializaton Assembly" set to On. What I have been doing is like what NTDeveloper said (manually using SGEN). I then manually deploy that serializer assembly into SQL. The error message i'm getting is the typical one that everyone sees System.InvalidOperationException: Cannot load dynamically generated serialization assembly. In some hosting environments assembly load functionality is restricted, consider using pre-generated serializer. Please see inner exception for more information. ---> System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) NTDeveloper - I can do it the way you mentioend in your post, but I don't need the XmlSerializationAssembly attributes, I just need to deploy it to GAC. I don't like this approach however... Tag: Cannot add a new folder under a Reporting Server Project
  - 10
    - How do you add multiple data sources to a report? Thanks !! Tag: Cannot add a new folder under a Reporting Server Project
  - 11
    - How to capture error upon connect error? I would like to continue processing when a connect error occurs. Set oServer = CreateObject("SQLDmo.SqlServer") oServer.LoginSecure = True oServer.Connect oName Would like to continue if the connect fails rather than have the script fail. How do I do that Thanks! Tag: Cannot add a new folder under a Reporting Server Project
  - 12
    - Server Upgrade We currently have a stand alone production server SQL 2005 STD + SP2 and plan to upgrade to clustered SQL 2005 Ent + SP2. What's the proper way to upgrade I want the existing server instance use Ent engine. Tag: Cannot add a new folder under a Reporting Server Project
  - 13
    - How to reflect base table changes in cursor You can't achive it on the cursor. When you use the GROUP BY, all the result will be stored in the temp table and the temp table will be served for your cursor. The only communication with your table is on the DECLARE & OPEN cursor. After that it will be acted independetly.... The Following query proves this, Code Snippet Create table TESTCUR ( Num Int , Chr Char ) Insert Into TESTCUR VALUES ( 1 , 'A' ) Insert Into TESTCUR VALUES ( 1 , 'A' ) Insert Into TESTCUR VALUES ( 1 , 'A' ) Insert Into TESTCUR VALUES ( 1 , 'B' ) Insert Into TESTCUR VALUES ( 1 , 'B' ) Insert Into TESTCUR VALUES ( 1 , 'B' ) Insert Into TESTCUR VALUES ( 1 , 'C' ) Insert Into TESTCUR VALUES ( 1 , 'C' ) Insert Into TESTCUR VALUES ( 1 , 'D' ) Go Declare TESTCURFUN Cursor DYNAMIC For Select Count ( NUM ) C , Chr From TESTCUR Group BY Chr ; Declare @I as int , @N Char ; Open TESTCURFUN Fetch TESTCURFUN INTO @I , @N --Drop the Table Drop Table TESTCUR While @@FETCH_STATUS = 0 Begin Select @I , @N Fetch TESTCURFUN INTO @I , @N End Close TESTCURFUN DEALLOCATE TESTCURFUN --Try the same logic without group by you might get error. Tag: Cannot add a new folder under a Reporting Server Project
  - 14
    - Memory allocation error while processing cubes The error you getting means Analysis Server estimated amount of memory it would need to perform processing operation and there is not enought memory. What you can do about this: 1. Force Analysis Server to disregard the estimate and proceed with processing operation. You might get a memory allocation later down the road during processing. For that change MemoryLimitErrorEnabled server property. For description of server properties see http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx 2. Take a look at processing operation, see if you can process fewer things at the time. For that you can change CoordinatorExecutionMode. Take a look at the processing architechture whitepaper http://msdn2.microsoft.com/en-us/library/ms345142.aspx Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Cannot add a new folder under a Reporting Server Project
  - 15
    - Performing insert / update queries using Pocket PC / SQL CE And you have checked you device /storage card for multiple copies of the sdf file Tag: Cannot add a new folder under a Reporting Server Project
  - 16
    - Page Break stops working after adding condition in Hide property Do Microsoft agreee with this that "This is the Bug" I Even can't set Pagebreak in groups as I want page header at the end of table only and not after certain amount of rows.. -Digs Tag: Cannot add a new folder under a Reporting Server Project

maui577827

Hello,

I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a new folder

Thanks,
maui

Top

Re: Cannot add a new folder under a Reporting Server Project

Jens K. Suessmeyer

You will have to create another project for that and set the different settings in the deployment properties to make it work. I asked sometime ago for this feature, but it wasn��t implemented yet. if you are also interested in that, place a feature request in connect.microsoft.com and I will vote on it.

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Top