Search results for query: *

Quick foreword: I inherited a web app that uploads images into SQL database for storage and displays them on a web page, at request. Problem is that when I right-click on loaded image, then "Save As", I have only BMP option and need to have whatever content type is, which is currently...

Hello, I have an events ASP page that displays events from database. To make it database independent, I'm exploring using XML file as storage instead of database. What I'm afraid is that there will be issues when several users perform add/edit/delete operations at the same time, so I'm not...

Hi. I need some advice as I got stuck a little. So, I have a windows form with a DataGridView that gets populated with table data for Add/Edit/Delete operations. Data generally is entered through another interface and checkboxes data on database side(SQL2K) are defined as bit (NOT NULL) type...

Hi All. I'm doing something wrong as I get this error: "A Summary has been specified on a non-recurring field. Details: @A_Count" Formula @A_Count: if {@A_Time} > 0 and {usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}<> Previous({usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}) and...

I didn't find such option. I created reports in ver. XI and open them an app. developed in VS2005 and version in VS2005 is 10.2.36. I'm having issue when Crystal won't display parameters on a report when opened in windows app's crystal viewer. Any ideas? Thanks

Hi All. I have a report developed in Crystal XI. It has stored procedure as data source, which takes two parameters (@StarDate and @EndDate). I use those data parameters in formulas and everything works great, when I run report in Crystal. I added report to VS2005 project and when I try to run...

I've done it in the past, but those were table fields in both report and subreport. That was easy. Now I have stored procedures as data source for both report and subreport. Each stored procedure takes 2 input parameters (StartDate & EndDate). When trying to link, Crystal doesn't show...

Hi All. This thing drives me nuts. Maybe because it's a Monday, or because I work with Crystal about once a year. Here's an issue. I have start/end date fields. Need to get DateDiff for day, hour, munites for further calculations (Count/Sum). Formula I have gives me correct output for some...

Hi All, I created stand alone Crystal report using version XI. It has an input parameter for data source (stored procedure). Parameter shows on report if I run report by itself, but not when I run from application (C# - Windows app, VS2005,.NET 2.0). Report data changes as parameter changes, but...

I need to count distinct date records within a group. Created formula but it doesn't work. All I get is 1 or 0. Can anyone advise? Thanks in advance. numberVar Count3AM := 0 ; stringVar CurrDate := ''; stringVar PrevDate := ''; WhilePrintingRecords; // extract dates without time part so we...

I'm having hard time figuring out this cross-tab query. And it's Monday too. [smile] If anyone can point me in the right direction, I'd greatly appreciate it. Data in a table is like this: DEF_SEG_ID DEF_SEG_NM ENTRY_DTTTM ---------- ---------- ----------- 60 Segment 1...

Hi. I have an editable datagridview on windows form. I'd like to add ability to paste data from clipboard into datagridview. Example: I highlight two cells in a Excel spreadsheet, copy, highlight two cells on a datagridview row and paste. General idea on how to approach this, or link to a...

Hope this is a right board to post. :) Just curious what others think. I'm a developer and for me an ideal environment would be a medium-sized company with about 10 people in IT dept.; supportive manager with possible tech background; and opportunity to learn new things (technology plus...

Hi I have a DataGridView thas being populated from a single table. cmdSelectMrkrData = new SqlCommand("SELECT * FROM mrkr"); dtMrkrFilteredData = new DataTable(); cmdSelectMrkrData.Connection = this.GetConnection("HTCIS"); adpMrkrRecords = new SqlDataAdapter(cmdSelectMrkrData)...

Hi All, Maybe I don't see something obvious here but I'm getting constraint error and don't see other way to solve it as to just drop constraints and then create them back later. So, I have these tables, Highway,Route, Hwy_Rte junction table for many to many : Hwy ------------ Hwy_ID (PK) More...

Hi All, I'm strugling to develop an error handling solution and need some advice. VB6 app I've been asked to enhance have a module that basically gets a recordset from DB, loops and adds data to a treeview nodes. Backend data is not very clean as it comes from differents sources (import, 3rd...

Hello experts. I have a generic question about designing banner ad system on my website and plan to use AdRotator. I plan to store ads as text in a database, generate banner images and AdRotator XML file when user starts session. If I'll be having many ads (100+), which I anticipate, some of...

Hi experts. Here's situation I'm in. In an ASP page on IIS server I need to retrieve user domain name and user machine name and put into a database. Request.ServerVariables gives me only username and IP address of user's machine. Based on those two pieces of info (LOGON_USER & REMOTE_HOST)...

I have a VB 6 DLL that does bunch of things. Now I need to add functionality to execute a batch file on a server. VB 6 cannot execute command/batch files if they're not on the same machine. This feature is important, so I was thinking to try and rewrite component in .Net as I know a little bit...

I have a VB 6 DLL that does bunch of things. Now I need to add functionality to execute a batch file on a server. VB 6 cannot execute command/batch files if they're not on the same machine. This feature is important, so I was thinking to try and rewrite component in C# as I know a little bit...