Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Make Drill Through Reports In SSRS


 

Hi All,
 
I want to know How to make Drill Through Reports in SSRS ?
 
Please Suggest.
 
Ritesh Kumar


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Drill Down Reports
 

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 Replies !   View Related
Drill Through Reports
Any way to have the drill through report open in a new window on the web?

View Replies !   View Related
About Drill Down Reports(on 7th)
 

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 Replies !   View Related
Exporting Drill Down Reports
Hello,

I have a table that is setup so the user can drill down into their data with the + and - boxes. I want the user to be able to export their data with snap shot of what they see on the screen. As it is now if they export the export goes through and expands all the fields to show all the data. How do i solve this?

View Replies !   View Related
Drill Through Reports In RS2005
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 Replies !   View Related
How To Create Drill Down Reports?
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 Replies !   View Related
Navigation In Drill-through Reports
Hi,
I have a summary report which displays the number of employees in that department. This report can be drill downed to view the list of employees in each of the department. Now this report has drill-through designed to view the employee details in another report (when the user clicks on the employee name, he will be taken to view the employee details).
 
While designing the report, when viewed the whole sequence in preview mode, i was able to view the navigation icon to traverse back to the main report from the employee details report.
 
I am accessing the reports through url method and when i access so, i am not able to view the navigation bar to traverse back from the employee details report back to employee summary report.
 
Any one have any suggestions/solution for this.
 
Regards,
Sudhakara.T.P.

View Replies !   View Related
Help Me To Create Drill Down Reports
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 Replies !   View Related
Multiple Drill Through In A SSRS Chart
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 Replies !   View Related
Drill Down Access Control In SSRS
HI,
 
i would like to know whether you can control access to a drill down  in a report in ssrs.
thanks for your help in advance.
 
thank you
Kanthi
 

View Replies !   View Related
Drill Down Report For SSRS 2000
Does anyone have a link to a good tutorial on how to create a drill down report in SSRS 2000. I found one for SSRS 2005
http://www.c-sharpcorner.com/UploadFile/MohanKumar.R/DrillDownReport02212008083910AM/DrillDownReport.aspx
If I had the AdventureWorks Db I may be able to figure it out.
 
I know how to create a hyperlink but I need the toggle (+/-) for my latest endeavor.
 
My book "Hitchhikers Guide..." didn't help me out.
 
Thanks.

View Replies !   View Related
Crystal Reports - Drill Down Lost
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 Replies !   View Related
StreamNotFoundException In Reports With Drill And Images
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 Replies !   View Related
Drill Through Reports And Cascading Parameters
Hi, all

I created [ReportA] to present details about [ObjectA] based on a date range and object name. I show only the [ObjectA] which are available based on the dates selected, making the report employ cascading parameters.

Then I created [ReportB] to drill through to [ReportA]. It shows aggregated data about all the [ObjectA] available in charts and a matrix, including the names of [ObjectA].

I set the date range based on the date range selected for [ReportB] and the name of the object is set as the path/name of [ObjectA] (passed in the result set).

(Sorry, I meant to say that) the Report Server is telling me that

The '[ObjectA]' parameter is missing a value

Does anyone know if there is an issue with "drill-through-ee" reports which employ cascading parameters to be populated by a "drill-through-er" report?

TIA

P.S. Is this confusing enough?

P.P.S. Do I have to delete the reports and re-upload them to make this work?

View Replies !   View Related
Back Button For Drill Down Reports
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 Replies !   View Related
Can We Drill Down Reports In A Another Different Pages With Different Layouts?
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 Replies !   View Related
Reports Usage Frequency For All The Existing Reports On SSRS 2000
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View Replies !   View Related
Reports Usage Frequency For All The Existing Reports On SSRS 2000
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View Replies !   View Related
Steps To Create Drill Through Reports(on 11th)
 

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

View Replies !   View Related
Drill Through To Reports Located In Multiple Folders
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 Replies !   View Related
Adding Interactive Sort In Drill Down Reports.
 

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 Replies !   View Related
SSRS 2000: Export Excel Drill Problem
hy all,
 
when i export to excel reports having a drill-down, in the excel file i don't have the possibility to drill down data.
i have memory that once it was possible.
does anyone know how to help me?
is it possible that a service pack or any updating could have change configurations?
 
thanks
by
 
nicola
 

View Replies !   View Related
Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
 
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
 
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too.  So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC.  Next I run the SQL 2008 "Reporting Services Configuration" tool.  When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
 
The developer PC is Windows Vista Business.
 
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
 
Thanks!
-ErikR

View Replies !   View Related
Issues With Browser Back Button In Drill Down Reports
 

Hi Team,

 

I have two levels of drilldown reports in my application. Suppose from the 2nd level drilldown if we come back to the 1st level drilldown using browser back button and clicks on the link for 2nd level drilldown again, it gives 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) "

 

Could you please help to overcome this issue?

 

Also refreshing the first level report gives the following error.

"Execution '4i0pg255j0tcki45lb1q4uuo' cannot be found ".  Is there any workaround?

 

Thanks,
   Sonu.

View Replies !   View Related
Drill Down Reports In Reporing Services 2005(on 10th)
 

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 Replies !   View Related
Execution ID Is Lost After Pressing The Back Button (drill-through Reports)
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 Replies !   View Related
Reports Containing Drill Through Interactive Bar Charts Not Working Properly When Deployed
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 Replies !   View Related
Converting Crystal Reports To SSRS Reports
 
My issue is with converting multi-value parameters:
 
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
 
As an example:
 
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
 
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
 
This will only return results within those ranges.
 

Does anyone know if SSRS provides this kind of functionality?
 
Thanks,
 
Patrick Conway

View Replies !   View Related
Enabling Automatic ClickThrough/ Drill Into For Report Builder Reports Against A Model
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 Replies !   View Related
How To Make You Reports Load Faster ?
Any ideas how to make reports faster when returning lots fo rows?
I know you would need to work on your sql query etc..
Or maybe cache it.
But i'm thinking of having a kind of middle tier thing that sits between your sql database and the reports itself.
Any ideas would be appreciated

View Replies !   View Related
Make Reports In Report Manager Stop Paginating?
 

IS there a way to do this?
 
I want everything on one page, no matter how long it is.

View Replies !   View Related
Excel 2007 Issue (KB 929766) For Cube Reports; Doesn't Make Any Sense
In short, we have started deploying Office 2007 to our users and Excel is currently the only client we use to interact with our AS2005 cubes. 

A few users have reported issues (which I've verified), but the explanation in the KB article doesn't make any sense to me.  These reports were originally developed in Excel 2003 and when opening them up in Excel 2007, we'll see a message saying that Excel found unreadable content in the .xls file and after clicking 'Yes' to recover contents of the workbook, we then receive a message that a PivotTable report was discarded due to integrity problems.  If I opened up this report in Excel 2003, I don't receive these errors or messages. 

Per the KB's explanation (http://support.microsoft.com/default.aspx/kb/929766):

This issue occurs if the following conditions are true: €¢The workbook contains a PivotTable that uses key performance indicators (KPIs).€¢The KPIs are created in the Analysis Services Business Intelligence Development Studio.€¢One or more of the KPIs have an expression in the Current Time Member property.
Now, we are running 2005 Standard Edition with no SP, but will be deploying SP2 in a few days.  Our cubes do not have any KPIs defined.  Can I even define KPIs if we are only running Standard Edition?

Any thoughts?

View Replies !   View Related
ToolTip In SSRS Reports
hi
i created a report which has a chart in SSRS 2005. I want to use tool tip option on this chart. Like if i move the cursor on the tips of the lines in the chart it has show me some XXX value. For that i used tooltip option. But if i move cursor on the charts its showing the first value(everywhere on the chart). So is there any other way that i can use this tooltip in my charts.

There is also another property called tooltiplocid. What is that? when and how should i use it?

can anyone help me....

thanks
honey

View Replies !   View Related
SSRS Vs. Crystal Reports
Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.

View Replies !   View Related
How To Fax Reports From SSRS 2005
 

 How do I fax out reports from SQL Server Reporting Services (SSRS) 2005?  I tried RightFax 6.0 but it didn't work.

View Replies !   View Related
Access Reports To SSRS
Hi All,
          I have a project that is already in MS Access that has many reports and I must develop the same project in .NET with SSRS for the reports. By seeing the same scenario in these forums I imported by right clicking on the project name, all the reports from Access have been imported..
My question is, that will the imported reports from MS ACCESS will be the same as that of the reports we will generate in SSRS? and can I use them as final reports. And call these reports in my .Net code..Is there any article regarding this please provide so that I can read and learn how to use that.. And for each .rdl files the data set si coming as dataset1...can we change the dataset name?..Please repond..ASAP.
 
Thanks
dotnetdev1

View Replies !   View Related
SSRS Or Crystal Reports
Hello all ...
 
I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.
 
Regards,

View Replies !   View Related
Is It Possible To License Your Own Reports In SSRS?
I work for a company that would like to implement a licensing strategy for custom reports for our customers.  We would like to be able to offer a set of core SSRS reports and then a set of additional but optionally licensed reports.  Is there a way to build in the concept of report licensing into SSRS?  we want to be able to deploy the full report set, but use a license key to turn on the additional reports once they have paid for their license key, and most like turn it off when the key expires.
 
 
thanks
 
 

View Replies !   View Related
SSRS Reports With Oracle DB--some One Plz Help Me.
 

Hi Guys,
I am creating SSRS report using Oracle DB. When i run this query in TOAD, it's giving output but when i run this in SSRS to create new dataset then it is giving me ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle).
 
This is the query iam running.
 
SELECT   ts.transaction_status_desc, COUNT (ut.transaction_id) AS transcount
FROM dsc_transaction_status_vl ts,
           dsc_user_transaction ut,
            billing_markets bm,
           retail_location rl,
            cash_register cr
WHERE ts.transaction_status = ut.transaction_status
              AND ut.cr_number = cr.cr_number
             AND cr.rl_number = rl.rl_number
             AND ut.RL_NUMBER = rl.RL_NUMBER
             AND rl.bm_code = bm.bm_code
             AND (ut.creation_date BETWEEN tartDate AND :EndDate)
             AND bm.bm_name IN
             (CASE (:Market)
             WHEN 'OKC'  THEN ('OKLAHOMA CITY' || 'TULSA')
              WHEN 'NFL'  THEN (   'DAYTONA'|| 'JACKSONVILL' || 'MELBOURNE'|| 'NORTH FLORIDA'|| 'ORLANDO' || 'WEST FLORIDA' )
             WHEN 'LA' THEN ('PAC Los Angeles')
              WHEN 'CAR'  THEN ('Carolinas')
             END
            )
 
I am passing 3 parameters: StartDate, EndDate and Market.
we have 3 markets and  each market includes some cities. Cities are in BM_NAME column.
My Question is that
1) How to pass parameters for Oracle using SSRS
2) How to resolve this error: ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle)
3)How can i write Stored Procedure for this query & How to execute SP in SSRS.
 
Please reply me. Thanks in advance.
 
Thanks
Santosh
 

View Replies !   View Related
SSRS 2005 Link Reports
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B.
Can you show me guidance on where to start please?

View Replies !   View Related
Migrate SSRS 2005 Reports
Hi,

I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.

Thanks
Alex

View Replies !   View Related
SSRS 2005 Link Reports
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B.
Can you show me guidance on where to start please?

View Replies !   View Related
SSRS Reports On Blackberry Device...
Hi all,

 

I m new the the SQL Server Reporting Service and Blackberry Device...I want to view my SSRS ReportServer on Blackberry Device...

 

Is anyone know how is it possible???

 

Thanking you in advance...

 

Regards,

 

Balwant Patel.

View Replies !   View Related
Converting Crystal Reports To SSRS
I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?

View Replies !   View Related
E-mail In SSRS Reports With Attachment
Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

 

View Replies !   View Related
Deploying SSRS 2005 Reports.
Hello,
        I am using SSRS 2005 and  VS.NET 2005. I have to give the reports to the client like a setup (*.exe or *.msi file). I have also worked on the security extension of SSRS. So I want tutorials, links or steps to create the setup etc. I have changed many config files manually while working on Security Extension. So, I would like to ask that whether I have to write my own function to update the config files? or any other alternative is there ? Waiting for the favourable response.

Regards,

Syed Furqan Ali.

View Replies !   View Related
Deploying Reports From SSRS Project
 

I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.
 
i can deploy that onto any Report Server. For that I will have to change the datasource connection string.
 
Is there a way to achieve this. Please let me know if it is there.
 
 
Regards...
Girija Shankar

View Replies !   View Related
Comparision Of SSRS With Crystal Reports
 
1)      Crystal Reports provides extensive parameter support. The types of parameters supported are: single value, multi-value, and range value (e.g. Start date to End date), or a combination of all three.
2)      SSRS parameters only support entry of a single value. It doesn't support multi-value parameters or range parameters. For example, the user can't be presented with a list of Employees and select more than one for reporting on. Doing so requires writing custom code and writing more complex SQL queries

View Replies !   View Related
Reports Deployment And Ssrs Installation
i'm a new developer and working with ssrs , any one can provide me by the steps of Reports Deployment and ssrs installation . i'm using sql server 2005 with asp.net ,vb.net ....
 
thanks

View Replies !   View Related
How To Create Dashboard Reports Using SSRS?
Hi Folks,
 
  I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?
 
   Is there anyother resources avilable to develop this dashboard reports? thanks in advance..
 
 
Thanks,
Senthil

View Replies !   View Related
How To Stop SSRS Reports Subscriptions
 

We have 7 SSRS reports subscription which execute every night at various time intervals.

 

Some times, due to database unavailability subscriptions can not access the source database, so these subscriptions continuously try to connect the database. (Even after setting connection time out.)

 

When the database is up again, all these subscriptions create bottleneck for the database and the whole system crashes.

 

So we want to stop subscriptions after some time interval (lets say 2 hours after it starts),

After that time interval what ever may be the status of the subscription (processing, done or fail) it should stop.

 

Please let me know the solution, Thanks in advance.

 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved