.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

How can i generate dynamic TOC or TOC as link while making .rdl in SSRS.

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server

hello ,

well  how can i generate a Table of content dynamically or TOC as a link so that while clicking in the TOC section it goes to the same page in pdf report output.


so can any one help me how to make TOC in .rdl design in SSRS ...plz help me out soon.



View Complete Post

More Related Resource Links

Trying to generate dynamic link to a document within approval workflow email message


In the out of the box approval workflow, the fields below are used to dynamically create a link within the email for a user to access the item/document to be reviewed:


Review [%TaskProcess:Item Title%].[%Variable: InternetLink%]

If I create an approval workflow and modify the text around what comes out of the box, the link works.  If I add those exact fields (period and space included) via the "Add or Change Lookup" box (field selector), it doesn't work. It displays the title as a link but without a document extension of XML (for Infopath form for instance).


I don't want to have to delete my workflow and recreate it just to get that link to work.

Any ideas on why the "[%TaskProcess:Item Title%].[%Variable: InternetLink%]" only works when it is created out of the box versus building the string manually ?

generate dynamic fields crystal report

  I want to add a Dynamic column in Crystal report at run time. Because I dont know about the columns in design time. The columns will come based on the user selection. So i want to Add a column to Crustal report at run time. I am using Crystal report. If it is not support to add column in Crystal report at runtime. Please kindly give the other solution or other third party tool like. Which version will support to add dynamic column in Crystal report? i already used the crosstab report but thats not work for my scenario.becoz i want to add another colums at right side ( after total of each row ) , which is crosstab report not supported 

SSRS Query Designer (in BIDS) does not generate ANSI SQL

Hello, I have a problem when using SQL Server 2005 BIDS (Business Intelligence Development Studio) when connected to an Oracle data source.  The Query Designer generates the old Oracle SQL syntax instead of ANSI SQL.  This is with the Oracle 10g client installed. So, I would really appreciate it if anybody knows how to get the Query Designer to generate the ANSI SQL.   Thanks, Stuart

Dynamic change home link in reporting services

I have a site setup to use forms authentication, when a user logs in I want it to go to a specific folder for that user. I am able to do this by changing where the site gets redirected to by using appending ?ItemPath=/FolderName at the end of the path. There is a link that says home in the upper part of the page, I would like this to also reflect the default folder for this user. Is it possible to change this? I do not want to hide it in the CSS as it makes navigation a little more difficult as the user will have the ability to create separate folders inside of the folder. I am using SQL 2008 r2.

Can POS2009 and dynamic RMS link to the same database?

I have 2 softwares, microsoft dynamic POS 2009 and microsoft dynamic RMS.  I would like to know can I link both programs to only 1 database in my computer?  thanks.

how to run dynamic sql in ssrs


I wrote a dynamic SQL. How to run it in the SSRS?




Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription



I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

Using dynamic controls (making arrays of controls)


Hi guys I m new to forum

I m stuck up in following code what i want to do is every time user clicks the button it should display 1 more panel (in project button is for showing for experience input fields so if some person have more than one experience than by simply click this button it should show one more set of controls  )

please check code below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AddExprience : System.Web.UI.Page
    Label[] Company_label_arr=new Label[50];
    TextBox[] Company_textbox_arr = new TextBox[50];

    Label[] Position_label_arr = new Label[50];
    TextBox[] Position_textbox_arr = new TextBox[50];

    Label[] Responsiblity_label_arr = new Label[50];
    TextBox[] Responsiblity_textbox_arr = new TextBox[50];

    Label[] ResonForLeaving_label_arr = new Label[50];
    TextBox[] ResonForLeaving_textbox_arr = new TextBox[50];

    Panel[] panel_arr=new Panel[50];
    Int32 count=0;
    Label lsd = new Label();
    Control[] control11=new Control[50]; 
    protected void Page_Load(object sender, EventArgs e)

    protected void AddExpButton_Click(object sender, EventArgs e)
        count = System.Convert.ToInt32(Session["count1"

SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

Generate a dynamic number of custom report item instances in a report


Are there any solid examples/tutorials/demos of how to dynamically generate custom report item instances in a report based on the amount of rows in a data set?

Additionally I would like to insert these custom report items in a particular order based on a field in the data set.

Any help/pointers/articles would be appreciated!

Embed FLV video with dynamic link in gridview


Hi guys, i need your help.

Currently i'm designing a gridview which could present an flv video file which was located on the database using sql. I use jw player to present the video (http://www.longtailvideo.com/players/jw-flv-player/

Therefore, on the <itemtemplate> i use this code to embed the video:

<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' width='400' height='300' id='single3' name='single3'>
                                    <param name='movie' value='../data/flashPlayer/player.swf'>
                                    <param name='allowfullscreen' value='true'>
                                    <param name='allowscriptaccess' value='always'>
                                    <param name='wmode' value='transparent'>
                                    <param name='flashvars' value="file=<%# "../data/uploadedData/video/flv" + Eval("videoUrl") %>">

SSRS and List/Link List databinding?


Hi People,

I know people usually bind reports to a dataset and alot of things using a dataset. I've managed to bind report to a dataset myself. But I have a third-party software that gathers data and I placed them in a LinkList<>(this linklist holds a collection of list<>) within a loop. Now I have a problem of binding reports to this collection.

I am using VS 2010 and assuming it use SSRS 2008.


Based on the rowsize entered on the text box, how to generate a dynamic grid view of that many row?


Hi, I have a text box.It is having 2 validation on it(Range validator and req field validator). Now,if I enter an integer within 0-8,just after gettting out of focus of the text box,I need to generate a grid which should contain exactly that many number of rows. Now,My question is: 1.How to capture that number entered in the text box and without any button click event,how to to generate the grid?I suppose,I need to write the code in one of the TextBox event.But,which one and how? Please help me as I am in urgent need.

Making a link work in a JS function



I'm new to jQuery, but learning fast, and loving the new functionality!
I'm using a Flash upload component that all works fine, and once it's complete (file uploaded) it calls the following function:
function EAFlashUpload_onResizedImagesUploadEnd() {

How to generate Index for which group starts from which page in SSRS ?


I am generating a report which displays all transactions of all accounts but transactions are displayed group by accounts.

Now i want to prepare index which displays which account starts from which page number. So is there any way to generate this index automatically in SSRS ?

Issue with SSRS Chart Dynamic width



I am using SSRS 2008. I am trying to use the Dynamic width and Dynamic height property of SSRS 2008. My SSRS chart has to display around 100 items on the x-axis. I am using the following formula depending on a report parameter =(Parameters!ReportParameter1.Value) & " in" to derive the width of the chart. The chart width is not  modified but I can see the the expression returning an valid value (ex: 10 in) and also the scroll bar size also changes but the chart's width(x-axis) is not increasing. Its still the old width.

Any help is highly appreciated.



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