Recent content by millerk

I've got a stored procedure that runs a number of different queries. Most of these involve doing joins, updates, and inserts with tables on two different servers. There are about 8 different queries that get run in this stored procedure. If I run them individually, there is one that takes 17...

Yesterday, I made some changes to a web app, then copied only the dll to the server. I didn't change any other files on the site. When I first tested it, it worked fine. But a little bit later, I got reports it wasn't working. I'm assuming it has something to do with the fact that I only...

The free code I was referring to doesn't include a ufl and font. It's just C# code to generate a bitmap from a string. So if I used the free code, I'd need to generate the bitmap outside of crystal, then insert the image somehow. Unless there is a way to add code to the report itself that can...

Anyone?

I need to be able to print DataMatrix 2D barcodes on a crystal report. The report will be viewed and printed with a report viewer object in MS Access. I know that there are a bunch of companies that sell components to generate 2D barcodes like this in Crystal. There is also free code available...

Say I have these 2 tables ProductRules: ProductNum, RuleCode this table says that a particular rule applies to a particular product. RuleCountryLink: Rule Code, Country this table says that a particular rule is applicable to a particular country. So right now, I have a query that is something...

This may be obvious to some, but in case anyone else tries this, one thing that threw me off at first is that if you are testing this by navigating directly to the .asmx page (or clicking start in VS), then the Request will be empty. So when I first tried it, I thought it wasn't working. But...

Thanks.

I'm new to web services, but I've got a basic web service with one web method working. With a regular aspx page, you have access to the Request object and can read whatever you need from it. Is there an equivalent to this for web services? I'd like to be able to access the soap request from...

Unless I'm missing something, I don't think that will work. Each time I do an insert into this table, I need the set of records that's being inserted to have record numbers that start with 1 and go up to whatever number. The record number basically identifies a sequence of records for that...

I have some sql that selects from multiple tables and does an insert into a single "report" table that I use for generating a crystal report and an electronic file for a client. So it's something like: INSERT INTO ReportTable(fields....) SELECT fields.... FROM Table1 join Table2... etc. WHERE...

I have a string variable that will usually be several hundred characters long. It is basically a paragraph that will be displayed on a report and included in an electronic file. The electronic file requires that it be split into multiple lines, each of which are no longer than 80 characters...

I'm generating PDF reports with Crystal for VS.Net. I've got a vertical line drawn from the report header through the page header, details, report footer, and page footer. The line shows up fine for all the sections except the page header. Is there any way to make this line visible in the page...

I have a db search page that gives the option of doing a "sounds-like" search. There are 2 types of sounds-like they can pick from, but I also want them to be able to pick neither. So ideally, I'd like 2 checkboxes and I'd like the user to be able to select one or the other or neither. Is this...

Or if I need to use all the separate tables as a data source, can you point me to an example or walk me through doing it that way?