I show business objects in the ReportViewer as it is described in the MSDN article [1]. In the article they only use intrinsic types like int and string as properties of the business object.
My business objects contains also structs and classes (e.g. Point) as Properties. I expected the Reporting Services to call the ToString() method if it is not an intrinsic type. But it only shows the error string "#Error" in the TextBox.
How can I show a Struct property of my business object as a report value?
[1] MSDN article: "Walkthrough: Using a Business Object Data Source with the ReportViewer Windows Forms Control in Local Processing Mode"
I am trying to use VB.NET to run SSIS packages. However I don't have the various dts namespaces available. When I attempt to import them I only have Microsoft.SqlServer.Server in intellisense.
I am running on XP sp2, VS 2005 (full install) and even went so far as to install sql 2005 sp1 full install on my local machine.
What gives with only having Microsoft.SqlServer.Server available?
As you all know, in Framework 2.0 on the desktop platform you have the convenient "abstract" Db* classes that can be used to write more generic code. For instance System.Data.SqlClient.SqlConnection inherits from System.Data.Common.DbConnection, and so forth. Now the docs clearly say that this applies to the corresponding classes in the Compact Framework. And i have seen this implied by other web searchs I've done. However this does not seem to be the case -- or, I'm missing something somewhere.
The following simple code on the desktop platform compiles OK:
using System.Data; using System.Data.Common; using System.Data.SqlClient; DbConnection conn = new SqlConnection();
However it doesn't compile in a compact framework project: "Cannot implicitly convert type 'System.Data.SqlClient.SqlConnection' to 'System.Data.Common.DbConnection'".
Reflector also indicates that the Compact Framework class doesn't inherit from DbConnection.
OK, so am I missing something here, or what was the reason that Microsoft did it differently??
Anyone have a recommendation on SSIS classes (providers and instructors)? It looks like Brian Knight's classes must be at the top of the list. His classes are always full!
I have a report which has an embedded image in the heading and an image control that loads images from the database (Image control Data section configured as MIMEType=image/jpg, Source=Database, Value=Fields!Img_Data.Value).
In both cases I can see the embedded heading image and the database images in design mode (VS2005) and through the report manager web pages. When I try to render the report through the ReportViewer web control in my web application, the images do not display (standard missing image red "X" appears).
I have a button on my web form which re-runs the report and exports it to PDF, and when pressed the report is displayed correctly in PDF with all images.
What do I need to do to the ReportViewer web control for it to show embedded and database images? I am using the ReportViewer for 2005.
I'm still trying to transition from a DB-centric view to an OO view, and I could use some help from any of you OO-design wizards out there. A very common db representation is Table A, Table B, and Table A_B, which maps the two in a one-to-many relation. E.g., create table Companies ( companyId int, name varchar ); create table Products ( productId int, name varchar ); create table Companies_Products ( companyId int, productId int ); So how does this translate into object-land? I started with: public class Product public id as integer public name as string end class public clas Company public id as integer public name as string public products as generic.list(of Product) end class OK, so far, so good -- I've represented most of my data. But I've lost some important information: given a Product object, I have no easy way to find out which company sells it. SQL: scan the Companies_Products table OO: iterate through companies, nested iteration through company.products. Do I just add a function to my data access layer that does the lookup? Is that allowed? On a side note: can anyone recommend a good intro to OO design specifically for database programmers? It seems like most of my confusion comes from issues of translating tables into classes. Thanks!
I am using SQLXML to pass data back and forth, well I am trying to. Itry to follow a tutorial but it didn't work completely. Here is myproblem. After everything executes with NO errors, my class has nodata. Here were my steps.1. In Query Analyzer, I ran my Select statement....Select * From Notifications Where UserID = '4192' and ParentID ISNULL for XML AUTOIt returned...<Notifications ID="1" UserID="4192"CreatedWhen="2004-08-31T00:00:00" ModifiedWhen="2004-08-31T00:00:00"ModifiedBy="1" Class="1" Name="CONSILIUMSOFT" Enabled="1"/>2. I saved the result in Test.xml.3. Ran XSD on it. C:Test>XSD TEST.XMLThis MS utility wrote out the schema file, TEST.XSD4. Ran XSD on it to create the class. C:Test>XSD TEST.XSD /classes/language:csThis MS utility wrote out the CS class file, TEST.cs5. Added the CS file to my project, create a class around it and thecode is below.My problem is that when I put a break point where is says BR (in thecode below), pNotifications has no data in it. All the values areNULL.ANY ideas? I getting desperate....I should mention that I am doingthis in ASP.NET and SQL 2000 sp3Ralph Kraussewww.consiliumsoft.comUse the START button? Then you need CSFastRunII...A new kind of application launcher integrated in the taskbar!ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg************CODE*******************public class CNotifications{SqlXmlCommandobjXMLCommand = newSqlXmlCommand(ConfigurationSettings.AppSettings["XMLConnectionString"]);NotificationspNotifications = new Notifications();public CNotifications(int iID){try{objXMLCommand.RootTag = "Notifications";objXMLCommand.CommandText = @"Select * From Notifications WhereUserID = '" + iID + "' and ParentID IS NULL for XML AUTO";objXMLCommand.CommandType = SqlXmlCommandType.Sql;objXMLCommand.ClientSideXml = true;XmlReader pXMLReader = objXMLCommand.ExecuteXmlReader();XmlSerializer pSerializer = newXmlSerializer(pNotifications.GetType());pNotifications = (Notifications)pSerializer.Deserialize(pXMLReader) ;pXMLReader.Close();}catch (SqlXmlException objEx){objEx.ErrorStream.Position = 0;string strErr = (new StreamReader(objEx.ErrorStream).ReadToEnd());throw new Exception (strErr);}BP}}
I work on the Clinical Surgery Department Data Application. The patient gets through the Admission, Surgery, PostSurgery and Discharge stages during his staying in the department. The Doctors just insert their medical data in to the different tables. I have three main classes: User, Patient and Portfolio ( patients portfolio ) and all the business bases on these classes. The problem is with the Classes per Medical Data Tables. The Medical tables should exist cause it includes the medical data about the patient however what is not clear: Whether I should create Business and Entity classes per each medical data table ( and this is something like 50 tables ) or I should insert all the functions in the Portfolio class and then there will be a mess of functions in one class? What is the accepted way to perform it ?
All -- Please help. I need to know how to refresh Linq-To-SQL classes after schema changes without dropping and adding them. Now, when I make a schema change (such as add or delete a column to a table), I want to "refresh" the Context.dbml file. The only way that seems to work is to drop the table from the Context.dbml designer and then add it back in. Is there a better way to do this? How are others doing this? Please advise. Thank you. -- Mark Kamoski
Hopefully someone out there will be able to help me with this question. I'm trying to setup my C# program to use the Backup and Restore classes to perform backups and restores on an SQL Express 2005 database.
From the documentation I've read... it seems that when you go to restore the database, it's a good idea to backup the current transaction log. But when I do this using the Backup.SqlBackup method I get an error saying that no database backup is detected so a log backup can't occur. I'm not sure if this has something to do with the fact that I moved my backup files from the default SQL Express/Server Backup folder to a different location. Shouldn't it know I've already performed a backup though?
And does anyone know how to set a parameter to backup to a different file location than the default? I've been doing a backup then a file move. Works the same, but it would be nice to have everything together in the Backup object.
I'm creating a custom interface for reporting services but I am having a few problems. This is my environment:
Using the ReportViewer component in remote mode to show my reports of the report server. There are 2 user levels of which any user can be apart of, Admin & user. In every report, there is a parameter called MERCHANTID, when the user who logs in (via custom login interface) is of group admin, then the merchantid parameter gets prompted before the report is run, if the group of the user is "user" then the merchantid parameter is hidden, and is passed programatically to the report. The report path also
My Questions:
1. When my reportviewer component loads up the report and prompts for a parameter, when you select a parameter value or type it in, it just posts back with no results, just the parameter prompt again with no data... How can this be corrected?
2. How do I pass report parameters programatically... so that when my user id of group "user" then "merchantid" gets passed automatically, but if there is any more parameters, then that gets prompted...
i've installed the SSRS 2000 ENT Edition i trying to add reportviewer dll in my webapplication but i haven't find that dll so could any help in this issue ?
I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005. When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success. At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports. Did you have any such problems? Can you help me?
I have a Local report bound to a ReportViewer control and when I am typing in text in the find text box and I click find I get this message on the report viewer "Object reference not set to an instance of an object" anybody have any idea
I am using the reportview in vb2005 to run a report that is on our report server. It just keeps says its processing and does not come up with any results. Any thoughts why this is happening and how I can fix?
I set the URL and the ReportName and run the application which returns HTTP 401, authorization error. What else do I have to do to make this little demonstration work?
I have read entries about credentials, about delegation, about application pools, about just about everything.
Isn't this just supposed to work? This works without difficulty on a Windows form.
I am trying to develop a custom web page to display and generate our company reports. It shoud have a login page, and then a general window with 2 or 3 frames (top frame with general info, left frame with a dynamic list of all existing reports (eventually categorized by a certain word in the report title), and a center frame that has initialy the company logo and after selecting a specific report displays the parameters and afterwards the generated report).
Does anybody has some pointers or links on the web where some of this is a little bit documented. I have dev skills in vb.net and know how to work with ssrs. My web dev skills are intermediate.
I have a report in which I am trying to get a parameter to be displayed in a textbox. I have declared a parameter in my .rdlc called UserName and the expression in the textbox is as follows...
=Parameters!UserName.Value
With that said, I have code in the window containing my ReportViewer to set the parameters and run my report as shown below...
string UserName = "test";
List<ReportParameter> paramList = new List<ReportParameter>();
With these things in mind, can anyone here provide me with a reason as to why my report on comes up with a message stating "An error occurred during local processing. One or more parameters required to run the report have not been specified." ???
If I remove the parameter and text box and strip out the code pertaining to the paramter in my window, the report runs without error.
I have couple of reports designed and they are on the report server and those reports are driven using some strored procedures.
I am building a asp.net program and want to use the reportviewer control in it, and i was wondering if there is any way that i could reference the reports thats been created usiing BIDS and use them in report viewer, or do i have to build them from scratch.
Is there a way to make the data selecatable. For example, a user runs a report and wants to copy the applicationId onto their clipboard so they can use it to search in another application. Currently they have to remember or write down a 9 digit number. Not very user friendly...
I am currently using a data table as the container for the data in my rdl file. Then I use reportviewer for winforms to embed it in our user application.
I'm having problems using the ReportViewer control (which you can use in VS2005). When I go to the page that contains the control, the images (back, next, print, etc) don't show up and I get different javascript errors (one of them is the "RSClientController is undefined" error). After some investigation, I found out that the path to the Reserved.ReportViewerWebControl.axd file is incorrect (as I see it in the page source). On every place this axd file is used (for the images and the necessary javascript file), the path is "/Reserved.ReportViewerWebControl.axd?...", while it should be "/reportserver/Reserved.ReportViewerWebControl.axd?...". If I go directly to the "/reportserver/..." url, I can retrieve the images and javascript file. So, somewhere the path to the axd file is set in a wrong way.
For example: <script src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Scripts.ReportViewer.js" type="text/javascript"></script> while this should be: <script src="/ReportServer/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Scripts.ReportViewer.js" type="text/javascript"></script>
I have included the ReportViewer control in a usercontrol (ascx). This usercontrol is implemented in Sharepoint using the "Son of Smartpart" webpart. I'm using SQL Reporting Services 2005 (with the database, SQL Server 2005, hosted on another server). Using the ReportManager, everything is fine.
I really need to get this working, but I'm out of ideas (I've been searching for days to solve this, but can't seem to find the correct solution).
Regarding this post: http://forums.microsoft.com/TechNet/showpost.aspx?postid=2111183&siteid=17
This could be the follow up of that post, but I thought it would be a good idea to open a new post to discuss the ReportViewer.Reset() method.
This is the background:I was getting a "Execution '' not found" error when generating reports, VDeepak wrote something about ReportViewer.Reset() as a solution for this, so I tried with it.
At my workstation, running the project with VS2005 it worked flawlessly. Nevertheless, when I updated the files on the server I got an exception: "method ReportViewer.Reset() not found". Apparently, this was because of an outdated dll: Microsoft.ReportViewer.WebForms.dll. In other post, somebody told this could be solved installing the SQL Server 2005 SP1, I did it with no success... I found a SP2 was launched recently, so I downloaded installed it... Now another exception: a "http bad request exception". Desperate, I removed the ReportViewer.Reset() line from the code and uploaded the files to the server again. This time, everything went ok again, actually, I havn't found the freaking "execution '' not found" exception.
There are two questions here:
1 - What exactly does ReportViewer.Reset() method do? and why the same code could be failing on the server when it was working ok in the workstation (believe me, I tried everything, the only diference is this method). 2 - By chance, could the "Execution '' not found" error be fixed with the SP2??? I searched the change log and found nothing about it.
I´ve installed SQL Server Express 2005 as part of the installation of Visual Basic Express 2005. When I tried to run the Starter Kit "WebLogAnalyzer" comes the following error message: "Warning 1 The referenced component 'Microsoft.ReportViewer.Common' could not be found. "
Now I´ve seen that C:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewerReportViewer.exe does not exist. Is it not part of SQL Server Express 2005 or should I make a new installation?
Hi, apologies for what I know is a very basic question. We have a very simple ASP.NET page that includes a report viewer object. The site containing the page is on a public server, and the report server is on an internal server (actually the same physical machine, but running on a different IP) - we are referencing the report server via a 10.x.x.x address and it's not connecting from outside. The report server is not accessible from the public address, and I don't believe there's firewall issues - can someone please point me in the right direction?
thanks, Steve.
<snip> using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Web.Security;
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here //this.DropDownList1.Items.Add(new ListItem("report1,"report1"));
Hi Everyone. I see that Visual Studio 2005 SP1 is out and includes an updated ReportViewer control. Is there an update to the ReportViewer Redistributable with those same fixes? Our product installs this redistributable silently, and we render reports locally (i.e. RDLC), so installing the full Visual Studio service pack would not help us (and installing just the assemblies would not either, since the Redistributable install seems to do other things "under the hood." Thanks for your help!
The client side reportviewer control is used with a typed dataset in vs 2005. But I have noticed something that is really interesting, the turkish characters in the dataset are changed in the runtime enviroment when used with the reportviever control. such as.exec sp_executesql N'SELECT CASES._ID, CASES._OWNERID, CASES._LASTMODIFYDATE, CASES._DELETIONSTATUS, CASES._SECURITYCODE, CASES._NAME, CASES._STATE, CASES._DESCRIPTION, CASES._CATEGORY, CASES._TYPE, CASES.PRIORITY, CASES.REASON, CASES.ORIGIN, CASES.FROMDATE, CASES.TODATE, CASES.COMMENT, CASES.WHATID, CASES.WHATTYPE, VIEW_WHONAME.WHONAME, ORGANIZATION._NAME AS ORGANIZATIONNAME, PERSON.HOMETEL, PERSON.EMAILFROM CASES INNER JOIN VIEW_WHONAME ON CASES.WHOID = VIEW_WHONAME.WHOID INNER JOIN PERSON ON VIEW_WHONAME.WHOID = PERSON._ID INNER JOIN ORGANIZATION ON PERSON.WORKINGORGANIZATIONID = ORGANIZATION._IDWHERE (CASES._OWNERID = @ownerID) AND (CASES._ID = @entityID) AND (VIEW_WHONAME.WHOTYPE = ''KÄ°Åžİ'')',N'@ownerID smallint,@entityID int',@ownerID=1,@entityID=30 ------------------------------------>>> the bold area should be 'KİŞİ' which is a turkish string....What sholud I do? Do I need to configure the sql server or do I need to configure asp.net runtime?
We have a problem with our ASP.NET 2.0 app in one aspx page which contains reportviewer control.
The problem is in this: When this page is shown in IE6 the reportviewer control is working OK and the report is shown, but when this page is shown in IE7 reportviewer control starts to act strange. The report isn't shown until F5 or refresh button isn't clicked. Does anybody have problem like this one?
