I have a Crystal Report that I access from a VB program and I send an SQL statement to the main report, but I also want to send the subreport a different SQL statement to execute.Do I need to pass it a parameter? Or how would I code it in VB to execute inside the subreport?Please help! Thanks!
i looking for a design report like crystal report or active reports but for php the objective is creat a report using mysql data and save the template and load that report in a pdf file for print or save any one know something like that? i already use classes like class.ezpdf.php but i spend many hours creating complex reports, all is created using a text editor..
When I call my reports from the .net program, i am getting following error Microsoft.Reporting.WebForms.ReportServerException: The path of the item 'D:/WebSites/DevelopmentWebsite/AP_reports/AP_reports/vent_Full_Div' 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) at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) at Reportviewr.Page_Load(Object sender, EventArgs e) in d:WebSitesDevelopmentWebsiteReportviewr.aspx.cs:line 416 The path of the item 'D:/WebSites/DevelopmentWebsite/AP_reports/AP_reports/Event_Full_Div' 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
We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly. But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing. The reports db and the application db through which we display the reports are different. how do we address this issue.
I tired to create a parameterized report in Report Builder 2.0 with parameters having multiple values fetched from the database. I really liked that feature, which allows me to select the desired records from the dropdown. I uploaded the report in SSRS 2008 and I could view the reports with parameters from the Report Manager of Report server. But when the report is called through the Report Viewer, I didn't get any of the parameters displayed inside the report viewer. The only way I could found is to manually give the dropdowns in the web page and sent that values to report by setting its parameter. But at here I cannot multi-select the values. So I would like to get the exact functionality given through the report manager in the report viewer. get the report parameters in the Report Viewer of ASP.NET?
I am in VS2008 Report rdlc Design tab and my report has drill down function. One item being drilled down on is Country. However, when user drilled down, the cell become 2 rows like this:- United States Of American I do not want it to be 2 rows but want to expand its length to make it one line on expand. In Gridview etc there is a property Wrap but when I click the cell I do not find this property in this cell property in the report designer. What can I do ?
I now have a ReportViewer control on asp.net page with datasource select Country, Product, Value from Table1. This reportviewer is associated with Report1.rdlc and currently Report1.rdlc has this matrix layout Country as row field, Product as column field and value as Calculate field (Sum) I want on button1click on asp.net, the report change to this layout: Product as row field, Country as column field, value remains as Calculate field. How should I proceed with this ? I know pointing to Report2.rdlc would be an option but I have more than 20 scenario and I want to keep doing it in same Report1.rdlc. Is there way to programmatically change the layout of Report1.rdlc when buttonclick is fired ?
I am trying to integrate an existing SSRS report in asp.net. 1. created the report and deployed it. 2. In the web page, have a reportviewer and trying to attach the same report. The report's url is :http://ReportServername/Reports/Pages/Report.aspx?ItemPath=%Clinical+ReportQ: What is my ReportPath and reportServerUrl? Is there something else I need to do? Should I copy over the rdl file to the report server?
My web form reportviewer control can't seem to find my sub report. When I debug, it gives an error message in the report that states the report can't be found at file path for the sub report. If I copy and paste the path out of the error into the address bar of windows explorer, the report opens right up. I am using VS 2010, the 4.0 framework, and windows 7.
I have a SSRS report that is uploaded on WSS3.0 site. This report has a "Jump to report" link to another report and there is also a parameter that is being passed. The report used to work fine but after we added SSL to the site it shows the following error message: An error occurred during rendering of the report. An error occurred during rendering of the report. An internal error occurred on the report server. See the error log for more details. Now when I remove the "Jump to report" link from the report it shows up fine with the SSL. the log file has this: [code]....
I am trying to create mobile device friendly versions of our reports, and am having a hard time with different phones rendering the report incorrectly. My phone (a Palm Treo) renders the report correctly (the same as viewing the report with a standard IE web browser). However, the rendering is apparently screwed up on my manager's phone (a Motorola). She sent me a picture and the table is condensed into very narrow columns, which causes the text to wrap after a few letters. Since our current reports are all .rdlc report files, I would like to continue using the same format for the mobile reports. However, the generated markup of the .rdlc reports is quite bloated, and I'm frankly not surprised that some phones choke when trying render them. Are there any fixes for this, or should I just abandon .rdlc for mobile reports and manually create the markup myself? I am not too keen on the latter, because I have already invested a sizeable amount of time on the existing reporting framework. Also, if anyone knows of a good way to simulate the rendering of various mobile device web browsers, that would be nice. Otherwise, I have no way of telling which phones will render our site properly!
Version 9 of ReportViewer in Remote Processing mode, IE 7 or 8 my report loads correctly. The toolbar appears correctly and parameters can be changed however the View Report button does not refresh the page to reload the report with the adjusted parameters - ie clicking performs no action. I am sure this is something simple I have missed?
Im having some difficulties in running my crystal report.Here's the scenario:i have a simple program with a command button. all i want is that whe i click the command button, the crystal report that i made will come out.hope you can help me with this...thanks!
hi,i'm using crystal report 8.0 . I'm displayig reports in VB using the Crystal Report Viewer. The "Close" button in the crystal report viewer is disabled even though I have set the "EnableCloseButton" property to true.How can I enable the "Close" button??Thanks
hi,i'm using crystal report 8.0 . I'm displayig reports in VB using the Crystal Report Viewer. The "Close" button in the crystal report viewer is disabled even though I have set the "EnableCloseButton" property to true.How can I enable the "Close" button??Thnaks
I'm working in SSRS, and lets say I have a matrix, and the matrix is grouped by "Customers", and "Customers" have values: "Bob", "Bill", "Ted". Each Customer has a field "Amount". If I sum the "Amount" in the group footer, it will give me the sum for "Bob", "Bill", and "Ted". If I sum in the report footer it will give me the sum for all of "Bob", "Bill", and "Ted". But lets say I only wanted the sum for "Bob" and "Ted, and not for "Bill". How can I filter the sum to include only specific values of the group?
if i am using a seagate crystal report 7,and i use stored procedure as datasource.and i set string as a parameter to import date formate as yyyymmddhe user haven't input date, then set date to today in stored procedure.but the field doesn't display current date.how can i disply 20100604 when the paramter is empty
i need to set logo of company according to the title of it..so along with company title want to send image path and set the image accordingly. My motot is to set image dynamically..but not from database. Read the ideas.nd coverted image in byte..but i am not able to send it along with parameter...and wat parameter shall i take on report for displaying it?
I need to create a complex report and export it to Excel. In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. I am new to SSRS and tried out many ways but didn't get it.
crystal report has two parameters field, however, i used three method searched, all failed. Error is missing parameter values. sure parameter is passing by query string URL] checked by Label However, do not know why Error is missing parameter values. Method 1 // First parameter ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = Request.QueryString["ID"]; crParameterFieldDefinitions = objRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Cheque_IssueRecord_Secretary_Review_TT_ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); // Second parameter ParameterFieldDefinitions crParameterFieldDefinitions2; ParameterFieldDefinition crParameterFieldDefinition2; ParameterValues crParameterValues2 = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue(); crParameterDiscreteValue2.Value = Request.QueryString["tCOMDB"]; crParameterFieldDefinitions2 = objRpt.DataDefinition.ParameterFields; crParameterFieldDefinition2 = crParameterFieldDefinitions2["tCOMDB"]; crParameterValues2 = crParameterFieldDefinition2.CurrentValues; crParameterValues2.Clear(); crParameterValues2.Add(crParameterDiscreteValue2); crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2); Method 2 //objRpt.SetParameterValue("Cheque_IssueRecord_Secretary_Review_TT_ID", Request.QueryString["ID"]); //objRpt.SetParameterValue("tCOMDB", Request.QueryString["tCOMDB"]); Method 3 var value = new ParameterDiscreteValue(); value.Value = Request.QueryString["ID"]; objRpt.ParameterFields["Cheque_IssueRecord_Secretary_Review_TT_ID"].CurrentValues.Add(value); var value2 = new ParameterDiscreteValue(); value2.Value = Request.QueryString["tCOMDB"]; objRpt.ParameterFields["tCOMDB"].CurrentValues.Add(value2); This crystal report database use stored procedure, parameter field is automatically added, after added i removed @ character do not know why parameter missing
i am on a report in which i need to show the Total of Current Page in page footer then i want to carry forward this total to Next page's Page Header. How can i do it?
http://www.dotnethell.it/users/files/1303_crys.zip this is an image of structure of my crystal report and the result of it as you can see, there are no space between the label "auditor" and the beginning of section2, but then i run it, crystal insert some blank rows in it how can i do to delete this space?
I am in VS2008 and in ReporViewer's Design page. I have "Fruits" as column fields and Months as row fields and Sales as data field. I have these columns:- Apple, Orange, Pear. However, I want it be displayed as Orange, Pear, apple. Any work around ? Also I need a 4th column adding the Apple, Orange and Peer numbers total. How to do it in design view in VS2008 ?
I am new to using the COM with PHP so hope you can help me here. Basically I need to send data from database to a Crystal Report using PHP/COM. $cr=new com("CrystalRuntime.Application.11") or die("cannot load cr com"); $rn="F: otes5 est.rpt"; $rap=$cr->OpenReport($rn); Any ideas how I write data to the report and then have that report display?
Our company intranet is strictly PHP-based. However, one of my new projects is to publish on-demand reports generated in Crystal Reports 9. Has anyone done this using PHP? Like many non-open source software packages, there is a lot of documentation on how to do this using ASP or Java, but nothing with PHP. I even attended a Crystal Reports seminar in hopes of getting some answers. The response I got was: PHP? What's that? Never heard of it! If anyone has done anything like this, I'm not looking for specifics at this point, just wondering whether or not it can be done before investing a lot of time and effort into this project.
I am just wondering if there's a way to inser a formula column just like the formula column in Developer 2000 into a crystal report ? In some cases I need to make certain calculation or retrieving data that is not included in the main query of the report , How can I make this function in crystal reports ?
I have a Crystal Reports 2008 report that has one of the fields using a MICR truetype font. If I export to PDF within Crystal Reports the field shows properly. If I export the report to PDF using the COM interface my PHP application uses the field does not show using the MICR font.I've been using Crystal Reports 2008 w/ PHP for a while now with great success. Using the info from the php COM manual pages I can create Crystal Reports objects and call their functions from within PHP. (Source code below)If I go to the PDF properties with adobe reader:-The one generated using crystal reports application has the MICR font listed in the 'fonts used by the document' list-The one generated using the COM interface does not show that font.If I try other fonts: If the server has the font it shows up properly. If the server doesnt have the font then i experience the same issue as with the MICR font. The confusing thing is that I know the server and the client have the same MICR true type font (I installed them both). The font also can be verified to be operational on the server from within the Crystal Reports Application.
I'm currently running Crystal Reports 8.5 from PHP using COM..(yes I know that is an older version of Crystal)...I am also running PHP on localhost. The following code: <?php $crapp = new COM ("CrystalRuntime.Application") or die ("Error on load"); $creport = $crapp->OpenReport("c:/test.rpt", 1); $creport->ExportOptions->DiskFileName="c:/test.rtf"; $creport->ExportOptions->DestinationType=1; // Export to File $creport->ExportOptions->FormatType=4; // Type: RTF $creport->DiscardSavedData(); $creport->Export(false); $creport = null; $crapp = null; print "...done"; ?> works fine until I run it more than 5 times, at which point I get the error: "Warning: Invoke() failed: Exception occurred. Source: Crystal Reports ActiveX Designer Description: There are not enough Concurrent Access Licenses to log you on. This system has 5 Concurrent Access Licenses."..etc..etc.. Now I know why this is happening. I assume it is because I am not closing the COM instances of 'Crystal Reports ActiveX Designer'. I am setting the '$crapp' object to null but I guess this still leaves the actual App instantiated. However, I can't find out how to programmatically close the App. I have tried: $crapp->Close(); $crapp->Quit(); Does anyone know either the command(s) I require to cleanup my 'Crystal Reports ActiveX Designer' session, or if not, can you suggest a good reference for the Crystal 8.5 COM commands because I can't find one.
hi,I have this simple question. I have a report in the designer section of my ide with fields that match fields in my db. How can I instead of showing the actual values in the db for certain fileds, modify them before display by passing these values in a function then display the results?Any help anyone? Thanks very much.
I have one asp.net application using Sql server as back end.. in sql server database i have one table which consist two fields.. ItemName and RateI have one notepad file which consist around 700 ItemName with Rate.. So how to get this ItemName and Rate in my Table...
I need to display report in winform based on winform parameters. I'm ve in SSRS report via URL, I deployed in Reportviewer in winform . Now I need to display that report based on my win form parameters i.e., I'm ve in textbox and button. I ve to enter related item in textbox and when I press the button the report should be viewed based on this values. Remember I'm calling report via URL.
We have a problem that in IE8 some of table rows (made by Reporting Services) are cut if compatibility mode of a browser is set to on (exactly a page is cut on bottom and left side and it is not visible). So we have to explain at every customer to disable compatibility mode. Does exist any way to display report page correctly even if a compatibility mode is on? Is this a bug?
I have a detail section in report. I am perfectly able to retrieve all the data from the Sharepoint List into datatable and bind it, to generate reports inside the details section.All the columns and related row data are getting displayed as reports in to the detail section.But, my issue is, I want to change the row data for a particular column before rendering on to the report.for instace, if column named Product has some values, I would like to display these values with different string name based on a switch condition. How do I achieve this?
am doing some work for a group that has a very old version of SSRS, VS.NET, and SQL Server deployed, and for reasons that are beyond my ability to influence, upgrading to later version(s) of the tools simply is not an option. I wish it were.In this environment, I have prepared a report in the designer for VS.NET 2003. This report renders perfectly in the "Preview" tab in the IDE; yet, when I attempt to view this report via the browser in HTML, the rendering is entirely corrupt and unusable. I added that version's "Report Viewer" control (which was then deployed only as an project within the sample projects), to a sample page and viewed the report through that control, but the rendering is no different; it's still unusable.My question is this: Since the report displays properly in the "Preview" page within the IDE, can that functionality be integrated into a conventional browser page? The preview does me no good if I can't deliver a live page with the same rendering. Believe me, I would love/prefer/desire to upgrade to the latest version of everything, but I simply have zero influence over that element of this project. I have to use what they provide: Sql Server 2000, VS.NET 2003, and SSRS for SQL Server 2000. Yup, there are cobwebs everywhere
I realise this is a fairly common question, but I have read this forum, and many other sources - and simply cannot resolve this.I have a website - www.domain.com, hosted by ASPHostCentral. Reporting Services is on my account.service web service URLThe report manager URL is http://ssrs.domain.com/reportsmanager My reports and connection live in a folder called "Matthew McNally".ASPHostCentral setup a user and password, and I can visit both of those sites, enter the username and password, and view the sites. I can upload a test report, and view it in both sites.I cannot get a web page with a reportviewer control on it to display the report - due to the 401 error message. Imports Microsoft.VisualBasic Imports Microsoft.Reporting.WebForms Imports System.Security.Principal Public Class ReportsServerCredentials Public NotInheritable Class ReportServerCredentials Implements IReportServerCredentials [code]...
i create a dataset on the form load which contain the reportviewer, i'm doing like this but it did not work : ....
I have a ReportViewer on page linked to Report1.rdlc. I want on buttonclick it link to Report2.rdlc and display new result accordingly. I tried below it refreshes but it does not change into Report2. Just stay as it was with Report1.rdlc. Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) ReportViewer1.LocalReport.ReportPath = "Report2.rdlc" ReportViewer1.DataBind() End Sub
i have an aspx page with a reportviewer control in it, in Page_Load event I get a string value using a query, and I want to assign this value to a textbox on the actual report, but no idea how.
I have a ReportViewer with a long report and so there are scroll bars on right hand side. Usually we just can use the scroll wheel on mouse to drag downwards to reveal lower part of the page but I found this wheel is not working when the mouse pointer is over the report.
assist me rectifying the error in following sql stored procedure? Sql Query:- [Code].... I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.
i'm going to create a reports for the database..i dont want to link the database dynamically instead i want to write the program for that..
I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code; Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Web.UI [code]....
I'm sort of new to ASP.NET. What i've done here is create a list of Newsletters seperated by University newsletters, and Alpha Newsletters. What I have now been asked to do is make these 2 lists into 1 list. I can't figure a Way to do it without designing the database? Does anyone have any ideas? Take these 2 lists and make 1? Using odsNewsletterAlpha and odsNewsletterUni to create 1 list? <h2>University Newsletters</h2> <asp:ListView class="lvUniversity" EnableViewState="true" ItemPlaceholderID="plcItem" DataSourceID="odsNewsletterUni"[code]...
Got an application that listens to (a number of) UDP multicast data streams. Application works correct on XP and Vista. On Windows 7 the application also works correct if the PC is directly connected to our (private multicast) network, only not if a VPN connection is used to the network. Th VPN connection itself works fine (i can ping the host machine) but no multicast is received. Used Microsoft Network Monitor to trace the mulicast messages. If the PC is connected directly to the network, IGMP Report messages are send if the appliaction is started. If the VPN connection is used, no IGMP Reports are send. IGMP queries are received from the router but the PC doesn't response with IGMP reports. Disabled the firewall but this didn't solve the problem. Any suggestions?
Hello,I have a Data Report that has a Data Enviroment as its Data Source.I am useing SQL text as the source of data for the command under the data environments connection.The SQL text I have entered directly into the DE is..SELECT * FROM TablesI would like to be able to change the SQL query from within the code prior to the report being shown. so I have been playing with the following...Dim MySQL As StringMySQL = "SELECT Title from Titles Where Title = '101 Database Exercises'"DataEnvironment1.Commands("Command1").CommandText = MySQLDataReport1.ShowWhen the report is shown it is useing the SQL query that is Typed in the Date Environment and not the one that is in the code. I have tried to leave the SQL Text empty in the DE, but then the report craps out all together.Am I going about this the right way?BTW in case you need to know, I am useing an ACCESS 2000 DB and VB 6 (SP 5)Thanks,Daniel
I'm using datareport to show and print reports. The report is created at runtime in which I link to the datareport object. The problem is the creation time takes too long, it spends almost 5 minutes just to fill up the table. can anyone shed light to my problem?
Guys,I am trying to build a report programatically in Access 97 and have succeded in doing so. However, when compiling the database and creating an MDE file, Access does not allow the program to create the report, since reports cannot be edited in an MDE file.I have proceeded to try and reference an external MDB and creating the report in that database, but Access informed me that an MDE file cannot reference an MDB file.Would anyone be able to assist me in creating this report? It has to be made from scratch as it is generic.ThanksAdi
You've helped greatly in the past, how about again?Here's the table structure:tblStudentsstudent_idstudent_nametblEventsevent_idevent_dateevent_minutestblHistoryref_numstudent_idevent_idminutes_missed1. tblStudents holds student names.2. tblEvents holds info about events (date and length in minutes)3. tblHistory records what student attended what event and how much they missed.Result set needed is:event_date, student_name, minutes_missed, SUM(minutes_missed) Note: SUM[minutes_missed) would be up to & including that event_dateWhat I have so far:SELECT fname as Student, event_date, minutes_missedFROM tblhistory, tblstudents, tbleventsWHERE tblhistory.student_id = tblstudents.student_id and tblhistory.event_id=tblevents.event_id;Any assistance would be greatly appreciated.--Gary
hi i was wondering if you can reopen an report from access if you close it by hitting the command button. This is what i have to open the filePrivate Sub cmdclientlcontact_Click()mAcc.DoCmd.OpenQuery "contacts", acViewNormalmAcc.Visible = TrueEnd Sub
i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?
Hi can you help me with the code that will generate current records from the form to the report i.e say am in record no 22 on my form and if i click a command button it shows the report with the same record number details on the report
Hi can you help me with the code that will generate current records from the form to the report i.e say am in record no 22 on my form and if i click a command button it shows the report with the same record number details on the reportthanks
I wanted to import data from text files (2 fields) with space delimiters to an SQL 7.0 table. I am using VB as front end, how will I write code for this ?
I wanted to import data from text files (2 fields) with space delimiters to an SQL 7.0 table. I am using VB as front end, how will I write code for this ?
I have a MySQL database with a table called "Locations" which looks a bit like this id | name | other parameters 1 | shop1 | blah 2 | shop2 | blah [Code].... This works, but it is inefficient calling the database through the loop, how do I avoid this?
I am a beginner when it comes to VB express. I went to the FAQ and found what looked like the answer to my question in "Database - How can I put the value of a variable/control into my SQL statement?" which said I should use thecode ...... where Field = ' " & variablename & " ' at the end of the SQL statement I am using a field defined as a nchar with 10 charecters and my variable is defined as a string. my field has been given the value "abcdefghij" so it is full to avoid confusion with spaces and even though the variable is identical and I have used the len command to check there are no hidden spaces etc. When I run the query I get no records selected. What am I doing wrong?. If I use Where Field = 'abcdefghij', ie specify the value in the SQL I get the correct records selected but this does not give me the flexibility I need
I've used checkboxlist to insert data into the sql database... example... checkboxlist have values 1,2,3,4,5... If is select 1,3 and 5 the values stored in databse will be 1,3,5. Now i want to retrieve those values into similar checkboxlist(1,2,3,4,5), but only 1,3 and 5 saved in db should be selected, 2 and 4 unselected....
i have to choose the most popular venueselect max(count(Destination))as popular_venu from bookingthis shows me error.how do i solve this?nothr queriesselect max(count(Departure_time)from bookingwhere Departure_time>12:00:00i got error for both.please help me to sovle
Similar region in C#, is there stuff available for MS SQL?
I have a SQLDataSource control that is calling a database stored procedure, and passing quite a large number of paramaters, and the stored proc returns records that populates a gridview control. When I walk through the code behind to determine the values being passed, is there any way that I can see exactly how the parameters are being formated and passed to the stored proc?
I've added a database to one of my projects and I'm wondering how I can get intellisense for them. Basically I have no how I can query the database that I've added to the project. I know SQL fairly well, but I don't know how I can write queries within vb.net and have them display. I can get, so intellisense will probably be invaluable.
I've created a database and I would like to write a query that uses variables from my application and perform calculations on the resulting data. I'm able to display the results of a simple query within a single table in a listbox, but I'm having trouble figuring out how to attach a sql command to a button press that queries multiple tables. Once I've been pointed in the right direction for how I can do this, I should be able to figure the sql bit out myself.
the string format for update or insert commands.. cmd.CommandText = "UPDATE ATTDTABLE SET @subject=" + DropDownList1.SelectedValue + ",@faculty= " + DropDownList2.SelectedValue + ",@timing= " + DropDownList3.SelectedValue + ",@attd=++attd "; is the above way of writing the rite way?
I use a variable "lbl" (lbl.Text)
How would you pull only the current month data from SQL?
I have a datalist that is populated by a users friends ordered by the date they last logged in. Here is my statement..SELECT TOP 30 ContactID, Contact_User_Name, ISNULL(LastAction,0) AS LastActive FROM COMPANY_CONTACT WHERE ContactID IN (SELECT DISTINCT ContactID FROM CONTACT_GROUPS INNER JOIN GROUPS ON CONTACT_GROUPS.GroupID=GROUPS.GroupID WHERE GROUPS.SuperID IN (SELECT SuperID FROM GROUPS INNER JOIN CONTACT_GROUPS ON GROUPS.GroupID=CONTACT_GROUPS.GroupID WHERE CONTACT_GROUPS.ContactID=@ContactID)) ORDER BY LastActive DESC Like i say it works fine in managment studio but from time to time in my live site it times out with this error System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient. I am thinking it might be something to do with the 'LastAction' column which can sometimes be null.
I created web pages that used an SQL database on my home computer. That DB allowed me to use data types such as 'date' and 'time'. But when I transferred my website to a host server, I discovered that its DB does not accept these types. They only use 'datetime' and 'timestamp'. I changed the tables in the DB on my computer to conform to the same format as on the host computer. I also changed the properties to the new data types with the O/R Developer and re-published the website files to the host server. But I keep getting the same error message that states the server does not support 'date' data types whenever I execute a web page that uses that table column. The C# code states "officetable.StartDate = DateTime.Today;"
I want to be able to make a query from three dropdownlists but not all three have to be selected to create results. This is what I have so far : sub getdata (src as object, e as eventargs) dim strsql as string dim myconnection as oledbconnection dim mycommand as oledbcommand myconnection = new oledbconnection(ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_csrdb")) strsql ="SELECT tbl_case.Case_id, tbl_case.Title, tbl_case.Description, Tbl_Country.Country_Name, tbl_principle.Principle_Name," _ & "tbl_keyword.Keyword FROM tbl_keyword INNER JOIN ((tbl_principle INNER JOIN (Tbl_Country INNER JOIN tbl_case ON Tbl_Country.Country_Id tbl_case.country) ON tbl_principle.Principle_ID = tbl_case.Principle) INNER JOIN tbl_Usedkeywords ON tbl_case.Case_id = tbl_Usedkeywords.case) ON tbl_keyword.Keyword_id = tbl_Usedkeywords.keyword " _ & "WHERE " if DLPrinciple.selectedindex=0 then strsql = strsql & "((tbl_principle.Principle_Name) like '%')" else if DLCountry.Selectedindex=0 then strsql = strsql & "((tbl_country.country_Name) like '%')" else if DLKeyword.selectedindex=0 then strsql = strsql & "((tbl_keyword.Keyword) like '%')" else strsql = strsql & "((tbl_principle.principle_Name) = '" & session("infoprinciple") & "')" + "((tbl_country.country_Name) = '" & session("infoland") & "')" + "((tbl_keyword.keyword) = '" & session("infokeyword") & "')" end if end if end if This is working perfectly with only one dropdownlist but I can not figure out how to make it work with several.
I am using VS2008 with C# to create a web application. I am using output cache to improve performance. There are No of places where I had written a function to fetch the some records from the database. Now the return of such functions will chage only if some record is added in the sql table or some record is updated. So how we can apply cache in that so that it can detect that a new record is added and check if that record ios in the cache or not if not then it will refresh the cache.
I am have created SQL database by using Visual Studio 2010. I created a table for users. My question is: How can I create an ID that increases automatically? For example, ID starts by 1 and increases 2 - 3 - 4 .......
I tried to install Amplifeeder today with the Web Platform Installer. When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password. Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI and SQL Express 2008 ? Basically I had this error while trying to install in the logs: DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
I am using Visual Web Developer 2010 Express on a web server. On the same network I have SQL Server 2008 Express installed on an SQL server. I have created a login for my web server in SQL Server like mydomainmywebserver$.In Visual Web Developer when I use Database Explorer to add a connection I am having a problem. I can see my SQLserver in the server name box but I don't any database in the Select a database name box. What is the likely reason for this? Is it an authentication problem in SQLserver?
I have an old mysql database, version - 3.23.38. I'd like to migrate from this database to ms sql express 2005. When reading through about MySQL Migration Toolkit, I found this fact - it is designed to work with MySQL versions 5.0 and higher. So, which toolkit could do for mysql version 3.23.38? Or let me know how to migrate it.
I have the following query: select good.fromwho , good.applesdate, good.starttime , good.hungupfromwho from apples good where ( good.type = 1 and good.result = 2 and good.fromwho not inselect bad.towho from apples bad where bad.type = 2 and bad.result = 1 and bad.applesdate >= good.applesdate and bad.starttime > good.starttime ) What I want to be able to do is add to my top selection statement columns from the "bad" table. If I try, it gives me The multi-part identifier "bad.towho" could not be bound. Is this possible?
I am trying to add a bit field with a default value of false to an existing table using VWD 2010 Express. With the allow nulls checkbox turned off and no data in the table, any value I attempt to enter into the default value box (0,(0), ((0)), False) all produce an error when exiting the field. What's the secret?
if field in a sql data table is encrypted or not ??!! like a function that return true or false>>> IsEncrypted()
I pulled a fast one today. I imported thousands of records and accidentally put the FName in the LName and the LName in the FName. I don't have a clue how to write a SQL or TSQL that will switch them. I do have a parameter for the SQL though. WHERE User - System Import.on ASP.NET because this is my place for help instead of going elsewhere to a more specific type of forum just for SQL. I do only ASP.NET VB/CS development so this is my home to find all my answers. (99% of the time).
to loop through each field in a record to test for a value and then set a flag at the end of each record if an instance of this value occurs in any fields?I have a table where some fields values are have a *c* at the beginning of the text eg "*c* value" . What I would like to do is run a select query off the table and at the end of each record have a field called "Change Flag" and a value of "Changed" or "No Change" depending if a *c* has been encountered. There are a number of tables to run this against all with differening numbers of fields/
I was wandering if I can make this faster. I am taking records out of Oracle and putting them into a SQL Server. btw, I am inserting into the Identity column [Code]....
I tried to develop a dynamic pivot query with following code to avoid hard coding. I can got the 'Q1, Q2, Q3, Q4' dynamically and assigned to @(@quarter. But it cannot be passed to the pivot query. [Code]....
I can do that writing to insert into code. But my manager wants me to use sqldatasource control and it's insert delete update function to work with. My old code was this Code: [code]... after than i pass fieldevent but i don't know how to do it on sqldatasource control.
i have a SP [Code].... as you can see from the SP, i need save in some variable because i have to create a dynamic SQL query who select with an "or" or "AND" from web form parametersthe problem is concatenate the SP parameter to my query actually, this SP returns the string : "select * from...." and not the resultset!
Inside many of my records, I have some HTML - - inside the HTML, I have a particular tag: <code> I'd like to change only that code to: <pre> But I don't want to change any other text inside any records... What sql can I use to do something like this?
Currently, we have our ASP.NET applications running on windows server 2003. All of our data resides on an IBM ISeries / AS400. The 400 people are going to be creating massive new tables with millions of records. Because of this, I've been asked to look into the idea of putting new ASP.NET pages on the IBM ISeries server. This server uses APACHE. I have read that to do this, I will need to use the Mod_Mono Apache module. I would like to come up with a list of benefits and drawbacks to this new idea. Initially, it seems like this is a bad idea for a few reasons: Security: if a users gets unauthorized access to our local server(s), they will only have access to either DB or web server, not both. Maintainability: Microsoft ASP.NET is easier to implement on a Microsoft Windows Server. Problem Solving: I will have to first determine if an issue is due to the ISeries server, or the Apache server, or the ASP.NET application. This could be countered by saying that I would already have to determine if the issue is due to Windows server, or ASP.NET application. However I have better experience with troubleshooting on a windows box that I am familiar with. Problem Creating: I could escentially create a problem that not only takes down the web server, but the database as well, and other RPG programs running on the ISeries. Resources: The database server will not have to server my application, it will only have to retrieve the data for it. Drivers: The windows server already contains many drivers and .DLL's that are used... will these even exist on the ISeries? How easy (if even possible) would it be to get them on the ISeries if they dont exist..? A few positive thoughts: The application will reside on the same server as the data, thus, it may be quicker at retrieving data from these millions of records in a table. This was the main point as to why I should look into this possibility. Single point of failure. We no longer have to worry about two servers going down and causing this application to be unavailable...
I wrote a console application that queries all data from a table in MS Access (I know, but I inherited it) to a SQL table. It runs every morning as a scheduled task. The fields between the two tables are not identical. Currently I select all data from the MS Access table, loop through the dataset and insert each row into the SQL table. I also write a quick log file in the process. It works, but it's not fast. I would appreciate any ideas that you may have to improve the process.
I am creating a report and I have several paragraphs of text making up my document inside those paragraphs I have data from my database so its made up of static and data driven fields. I need to bold and under line some of my fields inside my expression. I tried creating several columns and putting in my fields in other columns and that does work however it doesn't look that great sometimes there are large gaps in my text between the static and the dynamic. here is an example of one of about 14 paragrahs in my report. ="The Borrower hereby notifies MACED that it will use "& FormatCurrency(Fields!TotalAmount.Value) & " to fund the costs reflected in this Requisition No. " & Fields!pk_ReqID.Value & ". The above described loan proceeds will be used for the following purposes and in the following amounts:" As you can see thats one large field I have it works great other than I need to bold and underline my Value and my date can this be done inside my expression in some way like FormatCurrency(Fields!TotalAmount.Value,"BOLD")
I'm using SSRS 2005 and I would like to change the text weight of a textbox (in a table) dynamically based on a condition from normal weight to bold.
when i clink on a column of rldc then i want popup(not jump) a new aspx windows.