Search results for query: *

Thanks, that's what I figured, but was worth a shot Thanks

My Version is Crystal 9.2 The PDF is in a folder on the webserver where the applicaton that uses the crystal reports is located. The application knows the PDF exists by a bit field in the database. The PDF is named to relate to the record it belongs to. I currently use a process to create the...

I have a report that shows SQL data as a report. We have PDFs that are associated with each record. Is there a way to bring the PDF into the report as an additional page to the report? I am very limited in crystal reports so any solution would need to be explained well. Thanks in advance.

No doubt. I see that now. I was having a really bad day yesterday. Sorry about that!!

I am using an SQL database to track parking. I am trying to write a query to get data. Should be simple, but of course it's not. The problem is: There are 3 ways to refer to a parking stall. StallNumber, PermitNumber, and CardNumber. Problem is, not all records have all three fields. Record 1...

--This works SET ANSI_NULLS ON SET ANSI_WARNINGS OFF go CREATE PROCEDURE [dbo].[sp_GetQueryResults] @ReportNumber int as DECLARE @String varchar(8000) SET @string = (SELECT QueryString FROM ReportQuerys where reportid = @ReportNumber) exec (@string) GO

I am not sure how to set it up to do it. How do I run a QueryString that is stored as a record?

I store a query String..ie(Select * From Project, etc) in a database as a record. I want to call that query string and run it. I will send it the Record number and need to get back the results of the querystring that is in the database. I could just do one call to get the string and then use...

Sorry, thats way above my knowledge level.I am just throwing the Table tags in to a DB and calling it on the next page. Thanks Much though

When I used your code : s="%3Ctable%3E%3Ctr%3E%3Ctd%3EProjectName" t=unescape(s) wscript.echo s & vbcrlf & t I got an error abour the wscript I used just the: t=unescape(s) and it stripped oout my tags

Thanks for all the help everyone. I tried using the unescape, but it stripped out my <> tags leaving only table and tr showing. I may just save it to a SQL table and call it on the next page. How would you guys do it? This is bascially a report generator. The user selects fields from the...

PHV, thanks you so much. I actually used MyString = Request.Cookies("objTable") ReplacedText=Replace(MyString,"%3E",">") REReplacedText=Replace(ReplacedText,"%3C","<") REREReplacedText=Replace(REReplacedText,"%2","") For some reason the %2 showed up and I had to get rid of it too. Thanks...

I have an application that builds a Query string on the fly. I send this string to a function that builds a table on the fly from the data the Query returns. The Table string, ie..(table><tr><td>Stuff</td></tr></table>) is way too long to send in a querystring. So I have sent it to a cookie that...

I used this and it worked like a dream. Thanks so much! UPDATE dbo.tbl_AnnualInventoryCounts SET dbo.tbl_AnnualInventoryCounts.WareHouseId = '99' WHERE dbo.tbl_AnnualInventoryCounts.WareHouseId = '32';

I could use some help and I am completely clueless on this. I am hoping someone can(will)help. I have a table with 9 fields: UserID Year CountNo ItemID WarehouseID ProgramID Quantity ModifiedDate Location The Field WarehouseID has a value of 32. I need to change ALL of the records from 32 to...

Thanks very much. I searched forever trying to find that. It works like a charm. Ray

I am using the following code to delete a row in a datagrid. Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand Dim Index As Integer Index = e.Item.ItemIndex...

Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand Dim index As Integer index = e.Item.ItemIndex YourDataSet.YourDatabase.Rows(index).Delete()...

Thanks ,but another priority came up, this problem will have to wait. My new problem is trying to print labels. I want to be able to print a variable number of labels depending on the number of items in the inventory. ie.. if I have 5 computers I need 5 labels for them. If I have 2 monitors I...

That seems to be working, but not in the manner I had hoped. It works if the Invoice goes on to more than one page ie.. if the one invoice takes two pages, but if I print two copies of the same invoice, It puts the same image on the first page of both copies of the invoice. That is where I am...