Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS - Deployment - dbo.Catalog Expand / Collapse
Author
Message
Posted Tuesday, February 3, 2009 11:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 20, 2009 9:41 PM
Points: 12, Visits: 16
I have a report file named "Employee Detail.rdl" in the below location,

C:\Report_Types\Employee Info Report\Employee Info Report

I deployed this report using Build -> Deploy of the solution.

According to my understanding, once I deploy after the deployment I should see only one row added to dbo.Catalog table but dbo.Catalog table has 2 entries as below:

Row1:

Path = /Employee Info Report
Name = Employee Info Report
Type =1

Row2:

Path = /Employee Info Report/Employee Detail
Name = Employee Detail
Type =2

Item ID and Parent ID are unique for these 2 rows.

Can someone explain why there are 2 rows for this single report?

Thanks,
JJ
Post #649547
Posted Tuesday, February 3, 2009 11:57 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 6:56 AM
Points: 1,330, Visits: 1,434
Hello,

The first record will be for the report folder named “Employee Info Report” (where your report is deployed), and the second record is for the actual report.

“Type” is a useful column in the Catalog table:-

1 = Folder
2 = Report

Regards,

John Marsh


www.sql.lu
SQL Server Luxembourg User Group
Post #649554
Posted Wednesday, February 4, 2009 12:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 5, 2009 9:50 PM
Points: 4, Visits: 3
thanks John!
Post #649562
Posted Thursday, June 18, 2009 2:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 13, 2010 9:24 AM
Points: 2, Visits: 17
TYPES:
1 = Folder
2 = Report (.rdl)
3 = .XML
4 = Link Report
5 = Data Source (.rds)
6 = model
Post #737934
Posted Thursday, April 28, 2011 10:26 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 7:22 AM
Points: 10, Visits: 313
Update -additional types for 2008 R2
8 = Shared Dataset
9 = Report Part
Post #1100388
Posted Monday, November 12, 2012 4:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:20 AM
Points: 174, Visits: 1,793
Minor correction on type 3, this is any other file type (xml, image etc.)

Assumption is the mother of all F***ups
Post #1383604
Posted Monday, November 12, 2012 5:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:20 AM
Points: 174, Visits: 1,793
On a related subject (I'm digging around in the catalog table at the moment) does anybody know what "Dynamic Prompt" relates to in the parameter field?
it is entrenched in the xml for the parameters and as far as I have been able to tell is always false.

<I'm looking at the 2008R2 version here>


<Prompt>Report Date</Prompt>
<DynamicPrompt>False</DynamicPrompt>
<PromptUser>True</PromptUser>
<DynamicDefaultValue>True</DynamicDefaultValue>
</Parameter>


Assumption is the mother of all F***ups
Post #1383615
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse