Drill Through To Reports Located In Multiple Folders

Feb 28, 2008

Report A contains a textbox that should navigate to Report B using the Jump To option. Report A and Report B are located in separated folders on the Reporting Server.

SSRS looks for the rdl file within the same folder when using the Jump To option. Is there away to navigate to a report located in a different folder on the same server?

Thanks

View 1 Replies


ADVERTISEMENT

Removing My Reports Folders

Apr 24, 2008

I am the administrator for our Reporting Services environment. I was researching the functionality of the My Reports feature of Reporting Services 2005. I enabled the My Reports feature and SSRS created folders to accomodate this feature. I then experimented with linked reports.

Now I want to undo this feature. I turned off the My Reports feature but the folders remain. The Report Manager refuses to delete them. I found their entries in the ReportServer.Catalog table but don't want to just delete them.

Does anyone know how to remove these folders from the Report Manager?

Gordy

View 1 Replies View Related

Deploy Reports To Specific Folders

Jan 29, 2007

Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here.

I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005?

Many Thanks,

Casey

View 6 Replies View Related

Restrict Users To View Reports And Also Folders In Report Manager

May 6, 2008



Hi,

I would like to restrict users to allow to view related reports only...
like i have 2 users..with 4 reports

1 user can see only two reports
2 user can see only another two reports

how can i do this by SSRS???
Can i do by using Configure item-level role definitions in seetings link..
or is thr any another way to do this?

Pls reply back

Regards,
Maruthi..


View 4 Replies View Related

About Drill Down Reports(on 7th)

Mar 7, 2008



Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.

View 5 Replies View Related

Drill Through Reports

Feb 21, 2007

Any way to have the drill through report open in a new window on the web?

View 4 Replies View Related

Drill Down Reports

Sep 11, 2007



Hi all

is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows

Quick reply is appreciated

Regards
Rameez

View 2 Replies View Related

How To Create Drill Down Reports?

Nov 21, 2007

Hi All,
Am new to Reporting Services. I need to create some drill down reports. Am unable to find any guidance or tutorials. Anyone please help me to create drill down reports

Thanks in advance

Regards
Nataraj.C

View 3 Replies View Related

Help Me To Create Drill Down Reports

Nov 21, 2007

Hi all,
Am new to SQL Server Reporting services. I need to create some Drill down reports. Am unable to find any guidance or tutorials for that. Please help me to create variety of drill down reports.

Thanks in advance.
Regards
Nataraj.C

View 2 Replies View Related

Drill Through Reports In RS2005

Jul 23, 2007

How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).

View 1 Replies View Related

Crystal Reports - Drill Down Lost

Dec 1, 2006

I've been able to insert a graph in my reports which automatically allow drill down (into the graph). This has stopped working on new reports and I can't see why, or how to allow drill down (in graphs) again. Anyone help? I'm using Crystal Developer Ver9.2. Thanks

View 1 Replies View Related

StreamNotFoundException In Reports With Drill And Images

Feb 28, 2007

Hi,

I always have this exception:

w3wp!library!1!02/28/2007-13:50:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.

When i try to drill in a report that have images.

The weird is that i only have this error when i view this report in ReportViewer in a .aspx page. When i try to enter in this report directly by using the ReportServer ( http://server/Reports ) i dont have this error.


what is wrong ?

cya

View 9 Replies View Related

How To Make Drill Through Reports In SSRS

May 20, 2008



Hi All,

I want to know How to make Drill Through Reports in SSRS ?

Please Suggest.

Ritesh Kumar

View 5 Replies View Related

Back Button For Drill Down Reports

May 12, 2007

Hello,



In the sharepoint site from the main report when i go to my drill down report i see no back button, Is there a way to provide back button in the toolbar. I dont want to use the page back button. or is there any way by which if i click for my drill down report the report will be opened in a new window?



Thanks & Regds,

View 2 Replies View Related

Can We Drill Down Reports In A Another Different Pages With Different Layouts?

Apr 16, 2007

Hi, all experts here,

Thank you for your kind attention.

I am wondering if we can drill down reports in a different page with different layouts and columns? e.g. I have too many columns desired to see in a report, so I want to direct the users to another page with different layouts and columns, so the first view in the report wont display so many columns in a page. Is it possible to make it in SQL Server 2005 Reporting Services? And if it is possible then how? Hope my question is clear for your help.

Thanks a lot in advance and I am looking forward to hearing from you.

With best regards,

Yours sincerely,

View 5 Replies View Related

Steps To Create Drill Through Reports(on 11th)

Mar 11, 2008



Hi all.
Any body give me one example,how to create drill Through reports in Reporting Services.

Regards.

View 5 Replies View Related

Adding Interactive Sort In Drill Down Reports.

Dec 20, 2007



Hello,

I have a drill down report and would like to add interactive sort on two columns:- column 1 & column 2. These two columns should be in descending order. By adding this, when user's click on column 1 they will see the data based on the sorted order.
Does anyone help me on this issue.

Thanks,
BL

View 5 Replies View Related

Drill Down Reports In Reporing Services 2005(on 10th)

Mar 10, 2008



Any body pls tell me steps to create Drill Down reports in Sql Server 2005 Reporing Services.

If possible give me one example to create Drill down Reports.

Regards.

Naren

View 5 Replies View Related

Execution ID Is Lost After Pressing The Back Button (drill-through Reports)

Dec 12, 2006

Hi there,

I'm using the reportviewer control to display a drill-through serverreport. Here is the code in my code-behind file:

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init

Dim strReportPath As String = "/Public Reports/adfront/dealermodel/myreportname"

Dim paramUniqueID As New ReportParameter()

If Not Page.IsPostBack And Me.ReportViewer1.ServerReport.IsDrillthroughReport = False Then

Session("uniqueid") = Request.QueryString("uniqueid").ToString

'Set the report server URL and report path

Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://localhost/reportserver")

Me.ReportViewer1.ServerReport.ReportPath = strReportPath

Me.ReportViewer1.SizeToReportContent = True

Me.ReportViewer1.AsyncRendering = False

Me.ReportViewer1.ShowBackButton = True

Me.ReportViewer1.ShowFindControls = False

Me.ReportViewer1.ShowPageNavigationControls = False

Me.ReportViewer1.ShowParameterPrompts = False

Me.ReportViewer1.ShowPromptAreaButton = False

Me.ReportViewer1.ShowZoomControl = True

Me.ReportViewer1.ZoomMode = ZoomMode.FullPage

'Set the processing mode for the ReportViewer to Remote

Me.ReportViewer1.ProcessingMode = ProcessingMode.Remote

'Set the report parameters for the report

paramUniqueID.Name = "uniqueid"

paramUniqueID.Values.Add(Session("uniqueid"))

Dim parameters() As ReportParameter = {paramUniqueID}

Me.ReportViewer1.ServerReport.SetParameters(parameters)

End If

Me.ReportViewer1.ServerReport.Refresh()

End Sub



Protected Sub ReportViewer1_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough

While (Me.ReportViewer1.ServerReport.IsDrillthroughReport)

Me.ReportViewer1.PerformBack()

End While

'Me.ReportViewer1.ServerReport.ReportPath = e.ReportPath

'Me.ReportViewer1.ServerReport.GetParameters()

Me.Label1.Text = Me.ReportViewer1.ServerReport.ReportPath

End Sub

When I drill-through the report and hit the (browser) back button and try to drill-trough again I get the following error:

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

When I hit back again and try to export the report to eg. PDF, I get this error:
Execution 'mly2yj555oen0o45oowe1e55' cannot be found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +553
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +941
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension) +97
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +126
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

It looks like my executionid is lost on the reportserver. Does anybody knows how to fix this, so my users can use the browser back button?

Many thanx!

Ralph

View 1 Replies View Related

Reports Containing Drill Through Interactive Bar Charts Not Working Properly When Deployed

Feb 9, 2006

Hi all,

Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.

I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.

Any help will be much appreciated.

Thanks,

Kanwal

View 1 Replies View Related

SQL Server 2008 :: Delete Folders / Sub Folders Older Than N No Of Days

Jul 30, 2015

If I run the below command, it clean up the files inside the folders but unable to clean up the folder and sub-folders older than 30 days. xp_ cmd shell ' forfiles -p "D:abcd" -s -m *.* -d -30 -c "cmd /c del /Q @path"'

View 4 Replies View Related

Enabling Automatic ClickThrough/ Drill Into For Report Builder Reports Against A Model

Apr 4, 2007

Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.



I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.



My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).



Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?



Thanks in Advance,

Toni



Other related postings -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1

View 4 Replies View Related

Reporting Services :: Interactive Sorting With Drill Down Reports In Report Builder 3.0

Aug 20, 2015

I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.

In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.

View 3 Replies View Related

Creating Multiple Report Folders In Business Intelligence Studio

Jan 29, 2008

Hi,
Is there a possible way to create multiple folders in a report project so that different reports can be categorized and arranged in separate folders. Apparently, it seems not. Is there a workaround?

Thanks.

View 6 Replies View Related

Problem Loading Data From Foxpro Tables Under Multiple Folders

Oct 17, 2007



Hi,

I am trying load data from multiple Foxpro tables which are under a folder. I can have multiple folders with 17 foxpro tables. I was able to do it in DTS using ActiveX script. Here is the ACtiveX script.

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Option Explicit
Dim conObj,DSNGosfbill,comObj,objRs,HostServer
Dim sFolder,sFileFolder, Details,subFolderoccur,sFileFolderDBF,sFileFolderFPT,CheckFile,dFiles,Fil
Dim fso, folderObj,subFolderList,dFolderObj
Dim objPackage,oStep,objPackage_1,oStep_1,ConnObj_001,ConnObj_004,ConnObj_031,ConnObj_032,ConnObj_033
Dim ConnObj_Hclaimb, ConnObj_HProv, ConnObj_Hids, ConnObj_HCodes, ConnObj_HSpan, ConnObj_002, ConnObj_HCHGB
Set conObj = CreateObject("ADODB.Connection")
HostServer =DTSGlobalVariables("gvServer").Value

'DSNGosfbill ="DRIVER={SQL Server};SERVER=" & HostServer & ";DATABASE=GOSFBILL"
DSNGosfbill ="DRIVER={SQL Server};SERVER=" & HostServer & ";UID=syntelhum;PWD=syntel123;DATABASE=GOSFBILL"
conObj.open DSNGosfbill

sFolder =DTSGlobalVariables("gvSSIUnzipPath").Value
CheckFile =DTSGlobalVariables("gvSSIBatchPath").Value

set comObj=CreateObject ("adodb.command")
set comObj.ActiveConnection =conObj
Function Main()
Dim Dir_Name,DirFlag
Dir_Name = ""
DirFlag = "N"
Set fso = CreateObject("Scripting.FileSystemObject")

If fso.FileExists(checkFile) Then
Else
Details = "***** Success.Lst file is missing in Batch folder. BATCH job may not be successfull or there are no folders in UNZIP directory to process. Check the batch run.*****"
Call Write_Log
Main = DTSTaskExecResult_Failure
Exit Function
End If
Set folderObj = fso.GetFolder(sFolder)
Set subFolderList = folderObj.SubFolders
For Each subFolderOccur in subFolderList
DirFlag = "Y"
Dir_Name = subFolderOccur.Name
Call Process_Dir(1,subFolderOccur.Name)
Next
If DirFlag = "N" Then
Details = "***** No directories to process in SSI UNZIP folder*****"
Call Write_Log
End If
If DirFlag = "Y" Then
Call Process_Dir(2,Dir_Name)
If objRs.Eof Then
Details = "***** No directories to process in SSI UNZIP folder*****"
Call Write_Log
End If
While not objRs.EOF
set sFileFolder = fso.GetFolder(sFolder & objRs("zip_file_name"))
Details = "***** Start-Time " & sFileFolder & " " & Date & " " & Time & "*****"
Call Write_Log
Call Update_Process_Flag("L",objRs("zip_file_name"))
'*******Execute the package for each directory****************'
'********* Call the Package**************'
Set objPackage = CreateObject("DTS.Package")
Set objPackage_1 = CreateObject("DTS.Package")



'objPackage.LoadFromSQLServer HostServer, , ,256, , , , "GOSFBILL_SSI_STAGING_LOAD"


objPackage.LoadFromSQLServer HostServer,"syntelhum","syntel123", , , , , "GOSFBILL_SSI_STAGING_LOAD"


'objPackage_1.LoadFromSQLServer HostServer, , ,256, , , , "GOSFBILL_SSI_Update_FileSource"

objPackage_1.LoadFromSQLServer HostServer,"syntelhum","syntel123", , , , , "GOSFBILL_SSI_Update_FileSource"

Set ConnObj_001 = objPackage.Connections("SSIPATH001")
ConnObj_001.DataSource = sFileFolder

Set ConnObj_002 = objPackage.Connections("SSIPATH002")
ConnObj_002.DataSource = sFileFolder

Set ConnObj_004 = objPackage.Connections("SSIPATH004")
ConnObj_004.DataSource = sFileFolder
Set ConnObj_031 = objPackage.Connections("SSIPATH031")
ConnObj_031.DataSource = sFileFolder
Set ConnObj_032 = objPackage.Connections("SSIPATH032")
ConnObj_032.DataSource = sFileFolder
Set ConnObj_033 = objPackage.Connections("SSIPATH033")
ConnObj_033.DataSource = sFileFolder

Set ConnObj_Hclaimb = objPackage.Connections("SSIPATHCLAIMB")
ConnObj_Hclaimb.DataSource = sFileFolder

Set ConnObj_HProv = objPackage.Connections("SSIPATHPROV")
ConnObj_HProv.DataSource = sFileFolder
Set ConnObj_Hids = objPackage.Connections("SSIPATHHIDS")
ConnObj_Hids.DataSource = sFileFolder
Set ConnObj_HCodes = objPackage.Connections("SSIPATHCODES")
ConnObj_HCodes.DataSource = sFileFolder
Set ConnObj_HSpan = objPackage.Connections("SSIPATHSPAN")
ConnObj_HSpan.DataSource = sFileFolder

Set ConnObj_HCHGB = objPackage.Connections("SSIPATHCHGB")
ConnObj_HCHGB.DataSource = sFileFolder

objPackage.Execute
For Each oStep In objPackage.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
Details = "***** GOSFBILL_SSI_Staging_Load failed. " & Date & " " & Time & "*****"
Call Write_Log
Main = DTSTaskExecResult_Failure
Exit Function
End If
Next

Call Update_Process_Flag("X",objRs("zip_file_name"))

objPackage_1.GlobalVariables("gFileSource").Value = objRs("zip_file_name")


objPackage_1.Execute

For Each oStep_1 In objPackage_1.Steps
If oStep_1.ExecutionResult = DTSStepExecResult_Failure Then

Details = "***** GOSFBILL_SSI_Update_FileSource failed. " & Date & " " & Time & "*****"
Call Write_Log
Main = DTSTaskExecResult_Failure
Exit Function
End If
Next

'********************************************'
Details = "***** End-Time " & sFileFolder & " " & Date & " " & Time & "*****"
Call Write_Log
objPackage.Uninitialize
objPackage_1.Uninitialize
Set objPackage = Nothing
Set objPackage_1 = Nothing
sFileFolder = ""
sFileFolderDBF = ""
sFileFolderFPT = ""
objRs.MoveNext
Wend
objRs.Close
End If
Call Close_Conn
Main = DTSTaskExecResult_Success
End Function
Sub Process_Dir (Para_cntl,Dir_Name)
comObj.CommandText ="dbo.Usp_Process_Dir"
comObj.commandtype = 4
comobj.parameters.Refresh
comobj.parameters("@Para_Cntl")= para_cntl
comobj.parameters("@Dir_Nm")= Dir_Name
comobj.parameters("@File_Type")= "SSI"
If (Para_Cntl = 1)Then
comObj.Execute()
Else If Para_Cntl = 2 Then
Set objRs = comObj.Execute()
End If
End If

End Sub
Sub Update_Process_Flag(P_Flag,Dir_Name)
comObj.CommandText ="dbo.Usp_Process_Flag"
comObj.commandtype = 4
comObj.parameters.Refresh
comObj.parameters("@Process_Flag")= P_Flag
comobj.parameters("@Dir_Nm")= Dir_Name
comObj.Execute()
End Sub
Sub Write_Log
comObj.CommandText ="dbo.usp_etl_write_log"
comObj.commandtype = 4
comobj.parameters.Refresh
comobj.parameters("@Text")= Details
Comobj.parameters("@NDC_SSI_IND")= "SSI"
Comobj.parameters("@Process_Stage")= "Staging"
comObj.Execute()
End Sub

Sub Close_Conn
Set comObj = Nothing
Set objRs = Nothing
conObj.Close
Set conObj = Nothing
Set fso = Nothing
Set folderObj = Nothing
Set subFolderList = Nothing
End Sub

When I migrated this code to SSIS, its not working. How can I achive this functionality in SSIS. Any one pls help me.

Thanks in advance
Gijo

View 1 Replies View Related

T-SQL (SS2K8) :: Function To Create Folders (and Sub Folders)

Jun 5, 2014

I'm using sp_OACreate in a scalar function to create a folder if it doesn't exist, and it works fine if you're asking it to create a single folder. For instance: C:Newfolder

It creates "Newfolder"

However, if I try to ask it to create C:NewfolderNewsubfolder

It doesn't work

Here's the code:

DECLARE @Exists int, @ObjFile int, @ObjFileSystem int, @Folder nvarchar(500) = 'C:',
@Action tinyint = 1 --(0 to check if folder exists, 1 to actually create it)

EXEC dbo.sp_OACreate 'Scripting.FileSystemObject', @ObjFileSystem OUT
EXEC dbo.sp_OAMethod @ObjFileSystem, 'FolderExists', @Exists OUT, @Folder

[Code] .....

View 1 Replies View Related

Multiple Drill Through In A SSRS Chart

Sep 10, 2007

Hi,

we have a requirement that, when we click on the multiple series bars in a SSRS chart, it should drill through that chart and the detail report should filter based on these x axis and y axis of the bars selected.


As far as my knowledge, we can drill through the chart by selecting single series bar at a time in SSRS. Is there any way to acheive this multiple drill through of a chart.



Thanks
Raghava

View 1 Replies View Related

Retrieving Multiple Values From One Field In SQL Server For Use In Multiple Columsn In Reports

Mar 30, 2007

I am trying to create a report using Reporting Services.

My problem right now is that the way the table is constructed, I am trying to pull 3 seperate values i.e. One is the number of Hours, One is the type of work, and the 3rd is the Grade, out of one column and place them in 3 seperate columns in the report.

I can currently get one value but how to get the information I need to be able to use in my reports.

So far what I've been working with SQL Reporting Services 2005 I love it and have made several reports, but this one has got me stumped.

Any help would be appreciated.



Thanks.



I might not have made my problem quite clear enough. My table has one column labeled value. The value in that table is linked through an ID field to another table where the ID's are broken down to one ID =Number of Hours, One ID = Grade and One ID= type of work.

What I'm trying to do is when using these ID's and seperate the value related to those ID's into 3 seperate columns in a query for using in Reporting Services to create the report

As you can see, I'm attempting to change the name of the same column 3 times to reflect the correct information and then link them all to the person, where one person might have several entries in the other fields.

As you can see I can change the names individually in queries and pull the information seperately, it's when roll them altogether is where I'm running into my problem

Thanks for the suggestions that were made, I apoligize for not making the problem clearer.

Here is a copy of what I'm attempting to accomplish. I didn't have it with me last night when posting.



--Pulls the Service Opportunity

SELECT cs.value AS "Service Opportunity"

FROM Cstudent cs

INNER JOIN cattribute ca ON ca.attributeid = cs.attributeid

WHERE ca.name = 'Service Opportunity'



--Pulls the Number of Hours

SELECT cs.value AS 'Number of Hours'

FROM Cstudent cs

INNER JOIN cattribute ca ON ca.attributeid =cs.attributeid

WHERE ca.name ='Num of Hours'



--Pulls the Person Grade Level

SELECT cs.value AS 'Grade'

FROM Cstudent cs

INNER JOIN cattribute ca ON ca.attributeid =cs.attributeid

WHERE ca.name ='Grade'



--Pulls the Person Number, First and Last Name and Grade Level

SELECT s.personnumber, s.lastname, s.firstname, cs.value as "Grade"

FROM student s

INNER JOIN cperson cs ON cs.personid = s.personid

INNER JOIN cattribute ca ON ca.attributeid = cs.attributeid

WHERE cs.value =(SELECT cs.value AS 'Grade'

WHERE ca.attributeid = cs.attributeid AND ca.name='Grade')

View 11 Replies View Related

Multiple Reports

Dec 20, 2007

Hi Friends,

How do I display a bar graph in my main report? I dont want it to be displayed on separate page. When I click on some entities on my main report, a graph should be popped up in the same report in some corner? how do I do that ? Please let me know.

Thanks & Regards
Naveen J V

View 3 Replies View Related

Multiple Reports

Apr 23, 2007

Hi all,

I have created a report that everyone is happy with.
My dataset (simplified) looks like this:
SELECT *
FROM FamilyMember
WHERE QuestionnaireID = @QuestionnaireID

Now, instead of running individual reports the users want to run several reports on a list of QuestionnaireID's.
I thought something like this would work:
SELECT *
FROM FamilyMember
WHERE QuestionnaireID IN (@QuestionnaireID)
but RS complains about converting '152,153' to an INT.

Is there a way to accomplish this?
I am guessing I need to convert the nvarchar @QuestionnaireID to a real list of INTs but am unsure how to do this...

View 9 Replies View Related

Ad Hoc Reports Multiple Tables

Aug 21, 2007

HI,
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.

i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associate table C between A and B. so in .dsv file i have C related to A as one-to-many and C related to B as one to many.

Now here how do i get data from both table A and table B?

View 1 Replies View Related

Generating Multiple Reports

Sep 25, 2007



I have a report that I pass parameters of a clientID. I run the report and export it to a .pdf file. I would like to be able to do this for multiple clients without manually having to enter the ID each time and exporting it.

I have thought about creating a report that calls this report so that I can pass in the clientID one at a time. The problem is trying to export each one.

Does anyone have any ideas? Thanks in advance!

View 2 Replies View Related

Sharing Multiple Reports

Oct 30, 2007

Hi,


Can we share and schedule whole report folder(not just one report) by using management studio?

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved