I have a stored procedure returning the image field from the table. How do I get the result from the stored procedure to a byte so I can convert it and display on my form?
Thanks, I knew it was there just wasn't clicking for me.
I know it's in the books, but I could remember the Identity part of it so trying to find it was driving me insane.
Thanks again
I know this is probably out there already, but the search feature is down. Anyway
How do you create an autoincrementing field in a table. I know the answer is in front of my face, but it hasn't slapped me yet.
I feel realy stupid right now but here it goes.
How can I check if a dataset's table current row is the last row? I'm trying to create a application that will allow the user to navigate a datagrid but only allow edits in text boxes. Right now, when the user clicks on the last row in the...
Does anyone know how to open a crystal report that is not part of the "project/solution" in the CrystalViewer?
I've tried mulitple things and I can't find a method to call to allow me to do it.
Thanks in advance.
Thanks for all your help everyone. I ended up using Crystal for this piece, but I think I'll try adjusting the image quality for some of the more intensive reports.
Is there a way to print a form in VB.Net without converting it to a bitmap? The code that prints as a bitmap, works, but the printed document is blurry and not very professional looking. I need to be able to print a form that will be handed in to the human resources department.
Any help would...
Thanks this subtracted the date/times and gave me back the number of minutes from midnight.
IE( "07/14/2004 12:15:00 PM" to "07/14/2004 12:30:00 PM" this gave me and answer of 07/14/2004 12:15:00 AM)
Do you have any idea how to get to a decimal format. I tried using...
This is probably something very simple, but its just not clicking with me.
I'm trying to subtract 2 dates/times from each hoping to result in the "system" tranlsation of the dates/times.
IE("07/14/2004 08:00 AM" - "07/14/2004 00:00 AM" = 0.33333)
Does anyone know of away to do this? When I...
Currently, we have a third party vendor that uses Crystal Reports 8.5 to deliver its reports. We are currentlt working on a VB6 application that uses version 9. Does any one know a way to install crystal 9's components without effecting 8.5's?
Unfortunately, we don't have the option of using...
This is the exact error message I get. This is coming up when VB6 gets to Report.Export False line.
Run-time error '-2147190548 (800478ec)':
Error in File ?? :
Missing or out-of-date export DLL.
When I tried using that, it gave me an error. It said that the Dll was missing or out-of-date. What does that mean? I just installed Crystal 9 not even 2 weeks ago.
I need to be able to export a reports contents into an CSV file at the time of running the report. Does anyone know how I can do this without the built in crystal prompts coming up?
Thanks,
Randy Christian
Thanks everyone for you help, I finally got the view created. It appears that on the 2nd WHEN, I forgot the closing parenthesee.
I also ad to change the double quotes back to single quotes.
Thanks again
Here is what I have in the Query Analyzer:
SELECT PEOPLESOFT_ID, Department, [Date], TotalRawScore, TotalRawGoal, ProductID,
DEPARTMENTEx = CASE WHEN (ProductID = "1" AND DEPARTMENT = "LOST STOLEN") THEN "LOST STOLEN"
WHEN (ProductID = "2" AND...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.