.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

Dynamic file name in File based report delivery

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

I am trying to implement a report delivery mechanism which is file based. So the report will be generated in pdf or excel and placed in file share location.  The name of the file needs to be dynamic.  For e.g. : if the report I am running is Daily sales for store 101 with a sales amount of $150 and for the date 03/22. I need to generate a pdf with file name dailysales_101_150_032210.pdf

There are some parameterized report generation scenarios as well. In that case the report name should include the parameters provided. In the above example itself if all the values above are provided as parameter, the report should be generated for the given parameter and the name should contain the parameter.

Has anyone had this requirement and implemented a solution before ? Can this be implemented in a standard subscription & data driven subscription. any custom code is required in order to implement this or can this be done by configuration in SSRS ?

thanks for your help.


View Complete Post

More Related Resource Links

Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


Code Name WinFS: Revolutionary File Storage System Lets Users Search and Manage Files Based on Conte


One of the monumental problems organizations face today is aggregating information that's stored in disparate formats. Knowledge workers have long wanted to be able to search for content independent of format. The next version of the Windows operating system, code-named "Longhorn," boasts a new storage subsystem that makes that task easier. That subsystem, code-named "WinFS," allows the user to perform searches based on the metadata of the stored item, regardless of what type of file it is or which application created it. This article covers the basic architecture of WinFS and explains how to use the WinFS managed API.

Richard Grimes

MSDN Magazine January 2004

ISAPI Extensions: Creating a DLL to Enable HTTP-based File Uploads with IIS


The MIME-compliant content type, called multipart/form-data, makes writing HTML that uploads files almost trivial. On the server side though, ASP does not have a way to access data in the multipart/form-data format. The most flexible way to access the uploaded file is through a C++ ISAPI Extension DLL. This article describes a reusable ISAPI extension DLL that allows you to upload images and files without writing C++ code. It is coupled with a few COM components that make it readily reusable for ASP development. With .NET, this whole process is much easier, and this article shows preliminary code that uploads files using ASP.NET features.

Panos Kougiouris

MSDN Magazine October 2001

Uploading to SQL Server using AJAX muiltiple file uploader and dynamic SQL Server Tables


I am getting an error on the following code when trying to pload files directly to a database.  

 Incorrect syntax near ','.

 Incorrect syntax near 'image'.


    Private Sub Uploader_FileUploaded(ByVal sender As Object, ByVal args As UploaderEventArgs)

        Dim data() As Byte = New Byte((args.FileSize) - 1) {}

        Dim stream As Stream = args.OpenStream

        stream.Read(data, 0, data.Length)

    End Sub


Private Sub ButtonTellme_Click(ByVal sender As Object, ByVal e As EventArgs)


        Dim objConn As New SqlConnection("Data Source=mrpoteat.db.2798093.hostedresource.com; Initial Catalog=mrpoteat; User ID=mrpoteat; Password=Colgate23;")


        Dim strCommandText As String = ""

        For index = 1 To Attachments1.Items.Count Step 1

            strCommandText += "pic" + index.ToString() + Space(5)

How to put text from an external text file into a text box on a report.

Hi all, We're moving from our legacy reporting app to SQL Server Reporting Services 2008 and I'm converting our reports slowly but surely.  In our organization, one of our departments sends out letters that have standard marketing messages and disclaimers that they put into .rtf files.  Currently, our reporting application has an RTF box control that can do that fairly easily.  I've not found a similar control in SSRS 2008.  My thought, then, was to use a piece of embedded code in the report to grab the necessary text from the file and reference it in the Value of a Placeholder (using a Code.<FunctionName>.ToString() statement) - using HTML tags for the necessary formatting for those files. I don't care if I have to convert the existing RTF files to HTML files to do this, that's not an issue.  The code I'd come up with is this:  Public Function GetTextFile(ByVal strFileName as String) As String Dim oFile as System.IO.File Dim oRead as System.IO.StreamReader oRead = oFile.OpenText(strFileName) GetTextFile = oRead.ReadToEnd() End Function And the Expression I was using to get the text from the file is:  =Code.GetTextFile("HTMLTest.txt").ToString() Where "HTMLTest.txt" is the file name that I'm using.  The text itself is just a line of text with some HTML tags included for formatting - bold, color,

Embed Video File in Crystal Report

Hi to All I am new to crystal reports. I need to embed Video file in crystal report. Help will be appreciated.Rajeev Singh Chibrajeev16mca2k5@gmail.com

URL routing with a dynamic .sitemap file

Hi,I've implemented URL routing now I've upgraded to .NET 4 following http://weblogs.asp.net/scottgu/archive/2009/10/13/url-routing-with-asp-net-4-web-forms-vs-2010-and-net-4-0-series.aspx.The only problem I've encountered is with the .sitemap file. If I put, for example: <siteMapNode url="~/recipes/Starters" title="Browse Starters"> it renders correctly. However, I need to do something like this: <siteMapNode url="~/recipes/{category}" title="Browse {category}"> - i.e. dynamically giving a titleOr, I'd settle for something like this: <siteMapNode url="~/recipes/*" title="Browse Recipes"> - i.e. covering all recipe pages Has anyone found a nice solution to this?

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

Dynamic or Expression-based Report Page Properties

Hello, I have a tablix(table) with column grouping making the number of columns dynamic. Although our customers have been warned that this could lead to the columns going beyond the edge of the normal landscape 8.5x11 inch page, they have asked for alternate solutions. Beyond rotating the column labels and reducing fontsizes, the issue is not so much that it goes off the page, but the fact that in print preview mode the data is broken up requiring that you go to the next page to get the remaining data. What I am investigating is whether the Page Properties of the report body, either the pagesize property and/or the interactivesize property, can be manipulated at run time? This way if a user, based on their experience with the parameters they usually select and pass into the report, knows that the results will span the length of the page onto a second page, could choose a new parameter such as pagesize/interactivesize so that it changes from 8.5/11 to perhaps the next standard page size of 8.5/14 inches? This does not mean the contents would change during the course of rendering the report, just a new input that could decide at run time what paper size to use in print preview mode.   Thanks.

Three subreports in a main report(RDLC file)

Hi All, I have one main report(rdlc file) which contains three subreports(mapped to three different rdlc files). The functionality am working in is that in a button click(with parameter passing) the main report loads. The main report contains three columns which is of type link. Each column is mapped to a subreport. Once the link in a column is clicked the main report along with the respective subreport should get displayed. Again, if the link field of another column of the main report is clicked, the main report and its respective subreport should open and the previously opened subreport for the other column should not show. The visibility of the Subreports must change according to the click of the link in the main report. I have declared SubReportProcessingEvent as a sub report processing handler shown below. AddHandler rvCompareLabels.LocalReport.SubreportProcessing, AddressOf SubReportProcessingEvent Public Sub SubReportProcessingEvent(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs) End Sub I understand that in this method i have to do the code behind for displaying the subreports. But am confused as to how can i identify which link is being clicked and how am i supposed to add the datasource  for the subreport that should open. How will i give the condition such that  for the link that is clicked only the subreport mapped to that link opens.

How to generate report from RPL file


I have Integrated my Reporting service 2008 R2 with Sharepoint foundation 2010. I have created few reports. For one of the report I have setup a subscription. Type of subscription set is RPL Renderer.

Once this subscription was executed, I can see RPL file in my Sharepoint document library. Now the question is what to do with this RPL file. How can I generate Report from this RPL file.

I checked that Neither Report viewer control nor Report builder accepts this RPL file.

I also could not find much help over RPL renderer on Internet.

Execute a SSRS Report from CRM using URL to output to PDF with a specific file name


We have a CRM installation from which I am trying to do some reports which use the CRMAF filters so the reports are sensitive to entitiy selections.

eg execute a sales report for a number of selected accounts.

The specific RDLs have been created in VS2008 and uploaded to the reporting server via the Report import tools within CRM and all work as expected however the output of the report is in HTML via the web browser.

I have changed the configuration of the report in CRM so that it uses the URL method like below so that the report is rendered into PDF which is great.



This method prompts for the user to open/save the PDF file which is acceptable however I would like to replace the default file name (which is the report name) with one of my own.

For example rather

Help with vb-based aspx file from scratch


Hey, newbie here.

I am making a website from scratch. I know nothing about asp.net, but I want to learn to use it for it's database interoperability. So far, everything I've done has been basic html.

I have SOME experience with VB. I decided to make an aspx  page alone from scratch that was vb based, and all I'd done so far was create a form  in web developer 2010 express.

My html page is cut up into frames, and i tried src'ing one of them to the aspx page. But when I run the frames.html page, the part that's supposed to show the aspx page is showin me this:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

A name was started with an invalid character. Error processing resource 'file:///C:/Users/xxxxxxx/Desktop/xxxxxx/NewCa...

<%@ Page Language="VB" %>


I don't know what this means. This was the html code given to me when I created the aspx page. So why doesn't it understand it?

Another thing I couldn't find was the vb code page for the aspx while I was working on it IN web develope

How can we insert csv file data into Sql server table based on some condition ?


Hello All experts there,


I need to insert some csv file data into sql server 2008. but there are multiple tables created in sql server and I need to check some conditions before data insertion and based on the condition value, sql script should insert the data in to specific table. in other words I need to insert data from one csv file to different tables based on some condition.

is it possible? if yes then can anyone please give me an idea on how can we do that?


Thanks in advance


Nipendra Garg

How to use .XSD file as DataSet to create SSRS report?



I am  planning to create a SSRS report and lunch it in a ASP.NET web application (not using report server). Since the dataset need to be manipulated before used to generate report (some data fields of tables need to be filled  using data got from other system using COM+ components) , I hope I can use a .XSD file as the DataSet to create SSRS report and bind data source dynamically in code. It is not a problem using Crystal Report, but I have no idea how to do it either in Report Designer or in VS 2005. Please advise





Import flat file from the report to filtered data



Is there a way to use a flat file which could be imported from the report in order to filtered the data displayed ?



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