I am trying to create a ad-hoc reporting system and plan to create the report rdl programatically using a wizard where user selects the attributes of the report.
point me to any documentation, sample application that I can refer to on how to create the rdl file programatically?
How to combine two table in a database to create a single report. For example I am having two tables in a database linked each other by means of primary and foreign key I cant able to combine these two tables while designing in aspx window. I can able to combine in .rdl file that is normal ssrs, when coming here (.rdlc) I cant able to combine the two tables. I am using VS2008 and SQL2008.
How do I create wsdl and disco files for a web service using visual studio 2008? I can create the service and run it through VS but when I try to create the files nothing happens. I also need this service to run in sharepoint 2007 as well as outside sharepoint.
I am truying to work in my PC with reporting services 2008, but I got this message:
The report server can not decrypt the symmetric key used to access sensitive or encrypted data in a database server reports. You must restore a key from a backup or delete the encrypted content.(RsReportServerDisabled) .
am using c# with asp.net for wspproject. I am using spgridview to show the folders and files. When i clicked on folder, the spgridview bind with folder content(files/folders).Now i need to navigate folders based on the folder names like navigation bar in sharepoint.How to create the navigation bar for sharepoint folders?
In our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
I want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
I'm currently building an intranet engine for a project I've got on the go at the moment, and I'd like to save myself a little time by generating header images from code where possible, however, I'd like it to match our concept image.What I'd like to achieve is below:My issue is I've not the faintest how to create that from code. I can do the absolute basics but that's about it.
I start to fall down when it comes to the gradient background and the drop shadow on the text. I can get away with positioning the text on the larger header image, so if it's not possible to generate the exact gradient I have there, then I have a work around for that, but what I really want to achieve is the text with the font and drop shadow.I'd say it's safe to assume that to use a "non-standard" font, I'd merely need to install it on the web server?
I'm creating a page that users can upload a file to the webserver. After upload the page will then have a link to the file that has just been uploaded, along with any other files that have already been uploaded.As I am programatcially creating links to the files which have been uploaded, I have to do this in page_init or else the link button won't fire off it's event when clicked. MY web page does all this - it creates the link buttons and when I click on them, it calls the event method required i.e. a sub to download the file.
OK, the problem I've come accross is: when I click upload (to upload the file) - the page_init sub is called, displaying all the previously uploaded files as link buttons. Then my btnUpload_click sub is called, which uploads my current file. The only prob is the current file hasn't been displayed? I can only display links in the page_init, but because btnUpload is called after the page_init, the current file isn't uploaded until after page_init and therefore not dislayed?
I have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
I have this so far but kind of stuck on how to do it programtically if I'm using header and content templates I have a xmldatasource..In a nutshell at what point in my code do I need to create a new accordion? does it need to be in the item_databound handler?
I am not sure this is the forums but I dont know where to write this and this is an EMERGENCY ::I had windows 2003 server. on C: and I have installed windows 2008 server.I had SQL server installed and all of the database files stored inside c:program filessql server....PROBLEM is that after I installed 2008 server I can see 2 folders of program files one for x86 and the other for 64 bits.
I need to create temp file on the clint side So, i read that files can be created on the folder of internet temp file. how I can do that?how I can get the path of the temp folder?I need VB code
i need to generate multiple pdf files based on input parameters using ssrs. Suppose there are 1000 branches then it should generate 1000 pdf files one for each branch data. how can i achieve this using Sql Server 2005 and .net framework 1.1 or 3.5.
I have just been told to get looking into using SQL server reporting. Does anyone have any good links they would recommend? can this be used for reporting on ASP.NET sites?
I have created a reports project through SQL Business intelligence studio, There is shared data source in it. The name of the sharedata source is MyReport.rds.I have added two new items to the project (reports folder) with names Survey.rdl and myProjectReport.rdl.
Before deploying it, I have specified three properties ( Throgh the project properties)
1) TargetDataSourceFolder=DataSources
2)TargetReportFolder= reports
3)TargetServerURL=http://localhost/reportserver and deployed it.
When I view it in the browser through
http://localhost/Reports/Pages/Folder.aspx
I get my folder called reports, and when I click on it I can see two reports, it works till this stage.
I want to use the same report in Visual studio 2008 so I have done the following in VS 2008
Visual Studio 2008
1) Added a page
2) Added Reportviewer Control to the page
3) Click Properties of Reportviewer and Choose <server Rreport>
4) Set Report Server URL: http://localhost/reportserver
5) set Report Path= /reports/
It comes up with the following error:
The path of the item '/reports/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
How to access report services from localhost on my mahcine? Is there any web interface provided for SQL Server Reporting Services 2008? If so how can i do that and what is the URL?
I am creating report in winfrom. I am having three radio button and one button , when user click on any of those radio button and click on the button the report has to sort according to that. I am not asking about interactive sorting.
in my project i would like to save pdf files in database, how to save pdf files in database ? along with that i would like to create create a search page to search for pdf files with PDF file names , how to accoplish these things
i having trouble merging cells in reporting service with visual studio 2008 i want to merge a cell that has data of a group and detail i can't is there any way Here is an image of what i'm trying to do