.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Issue in Calling SSRS from ASP.Net

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server

Hi All,

Below is ny Scenario:

I have created Two RDL. First One Name is RDL1 and Second One Name is RDL2.

RDL1  Having Only One Text box. In Textbox properties--> Navigation Tab I have mentioned Jump to report to RDL2 . RDL2 having one table.

When I'm checking the Preview tab  text box is available and when i'm clicking that it's perfectly calling the Second RDL as per my property setting.

The same when I'm deploying in Report server when I'm clicking that text box it's perfectly calling the Second RDL.

But When I'm calling the same from ASP.Net It's calling my report and when I'm clicking the textbox it's refreshing the RDL1 and it's not calling RDL2 as per my property settings.

I'm using SSRS 2005

Can you please let me know where is the issue in SSRS or ASP.Net. How to fix this issue?



View Complete Post

More Related Resource Links

ssrs space issue

Can anyone please explain how to reduce the blank space between two rows in ssrs report, I tried with adjustingthe row hight but it does not help meJeeva Jacob

Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

Memory Management issue while calling COM method from .Net component

Hi all,  The Com Component Method say(GetChildresponse) requires Byte pointer as input. From .Net Component, while calling GetChildResponse  I am creating IntPtr and passing it to Component.  I am only creating the pointer in my .Net Component but allocation of bytes(CoTaskMemAlloc) happens at COM Method. After populating the pointer buffer, I am transferring to memory buffer in .Net method and Free the memorry of the pointer using "Marshal.FreeCoTaskMem" method.  Still I am not sure, whether it is deallocating the memory since the Garbarge collector wont happen immediately.  We are hitting on performance issue while doing load testing and we suspect this might be due to memory allocation that is not getting deallocated properly. Any pointers would be helpful. Thanks, Nithya Sample Code: unsafe {   // Get the physical memory address ocpHeaderBufferPointer = new IntPtr((void*)&ocpHeaderBufferPointer); temporaryResponseBufferPointer = new IntPtr((void*)&temporaryResponseBufferPointer); }   try {   try {   // Call the GetResponse of the pass through ocpChannel   new OCPChannelDSClass().GetResponse((uint)transactionId, ocpHeaderBufferPointer, out ocpHeaderBufferSize, temporaryResponseBufferPointer, out temporaryResponseBufferSize, (uint)timeout); }   catch (Exception ex) { &nbs

Viewstate issue when calling button click event from Javascript

I have a javascript that asks a confirmation on search click. If the user has made some changes to the data in grid (gridview) on click of Search, a confirmation is asked to Save or Continue Search. If Yes, Save the records by invoking Save click from javascript. If No, Search click is invoked. While Search click happens correctly, Save click results in an error which reads like this..  "Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. " I know the Viewstate is what causing the problem, where the control is not loaded but script is trying to invoke it's click event. Any help is appreciated. At the end of the day, all i need is to invoke Save click from javascript.   -- Viswanth VG  

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008 Paging Issue 0 of 0

I have several reports that are many pages long when rendered in visual studio, but when rendered on the web client it show pages 0 of 0 with the next and last buttons disabled. Only the first page is displayed but if I export to any format it renders all the pages correctly. Please help!

SSRS page break issue

Hi, I am using SSRS 2005. I have developed a SSRS report which prints multiple invoices, having invoice numbers and the parameters. The report is printing multiple invoices having page break after each invoice ends. But there is a header and body section. The body section contains the line items. The issue is after the header part the body part is moving to the next page for some invoices. When the line items are less, it is printing contineously after the header. If the line items are more the whole body is moving to the next page. When I try to fix this issue, some records are printing in the same page of the header and only last record is printing in the next page leaving a long blank in the first page of the invoice. I appreciate any one can solve this issue and it will be really helpful in solving this issue. Thanks , Mahalingam

SSRS 2008 web portal issue, urgent!!

I created a report using reporting services 2008, now I want to upload the report into the web portal so that users can start running the report from the web browser. When I opened the http://server1/ReportServer url from the browser, I just see the below, I installed full version of reporting services 2008, so I am trying to figure out what piece is missing from the installation. Please advice. Thanks. server1/ReportServer - / --------------------------------------------------------------------------------       Friday, January 02, 2009 4:15 PM        <dir> Data Sources    Tuesday, January 20, 2009 10:13 PM        <dir> HR      Friday, January 02, 2009 4:15 PM        <dir> Accounting --------------------------------------------------------------------------------Microsoft SQL Server Reporting Services Version 10.0.1600.22 sqldev

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Issue with reloading Report

Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan

SSRS IIS Permissions issue

SETUP: We have a server that runs SSRS and is also our webserver. Our reports are set up in two ways, one so that everyone can see some of the reports and a few are locked down so only admins and specific users can see and run the reports. These are set on the http://server/reports site under the security task on the report.  Issue: Some bright spark decided to change the permissions in IIS since then users can only see the "one to all reports" and not even admins could see the "locked down" reports. So not knowing much about IIS i tried to get the sites back to how they were by fiddling around with the Anonymous access and the windows authentication  on the properties on the default website, the reports site and the reports server site. I finally managed to get the users access though the reports server site but not the reports site as it has a better interface. I suddenly though of what i thought was a good idea and copped a backup to oversight the files within the sites forgetting that copy paste dosnt overwrite the permissions and now I dont have access to any site. Is there an easy way to set the permissions back to where they were and to get the sites back up.  Thanks

SSRS Report rendering issue


Hi All,

i have a chart report and deployed in server and created a subscription for sending email with webarchive type. I can see the chart in out look and it is perfect. when i see the same report in blackberry the fonts are not showing properly(blured).

I have tested via attachement as a pdf file then i can see the clear report in both outlook and blackberry but when make a mode as webarchive i getting the font problem in blackberry.

I am looking for the solution.





- Thiru

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

2008 SSRS (R2) Oracle Client issue



We have installed SSRS 2008 R2 on 64 bit windows 2003 server, and the 64 bit oracle client to connect to oracle databases.  The tnsping, and SQL plus are working from the server.  But when we trying to access the same database from report manager using new Datasource, we will get the below error.

"Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

We have installed only the 64 bit oracle client, and the Oracle folders are given with proper permissions to access it for SQL serving account which is used to run SSRS.

Any help greatly apprciated.  Thank you.

SSRS Datasource is linkedserver issue?


I have 2 SQL 2005 servers with separate SSRS installs.  Using SSRS on Server 1, I am trying to save a report that I built using Report Builder.  The report is being built from a report model on Server 2.  When I try to save the report, I get an error....Unable to bind datasource to report.


The data source may might not be accessible from the location where the report was saved.
The report was saved to "...folder/Report2".
The data source is "/Models/xxxxx".

You will no longer be able to run the report until this problem is fixed

The item '/Models/xxxxx' cannot be found. ---> The item '/Models/xxxxx' cannot be found..


Thoughts on how to get around this?



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend