|
Fortunately, one can use pictures when submitting an article
I are troll
|
|
|
|
|
I am writing a windows service in c# and am loading a crystal report. I need to export this report as a jpg file to disk or to take some kind of image stream which I can load into a bitmap or image object. I can export to a PDF but this is no use to me.
Any ideas?
|
|
|
|
|
Have never had the need to use Crystal Reports myself but this link[^] looks like it might have the answer.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Hi thanks for the reply. but.. the link takes me to a page describing how to "export crystal as image" perhaps you gave me wrong link? or else my english writing is a total failure. i need help on how to list parameter values dynamically created by the report.
Br
Tomas
If it' stuck, DO NOT pull harder!
|
|
|
|
|
c0ax_lx wrote: help on how to list parameter values dynamically
That's not the question you asked!:
c0ax_lx wrote: I need to export this report as a jpg file to disk or to take some kind of image stream which I can load into a bitmap or image object.
I'd start a new thread seeing as it's a totally new question.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
D'uh! i'm really sorry! this wasnt even my post! not used to see crystal report questions here *sigh*. well. You are totally correct, your post is the answer to the question.
so i'll just shut up now and try to find my own post.
hmm. i feel stupid.
Rgds
Tomas
If it' stuck, DO NOT pull harder!
|
|
|
|
|
LOL, no worries - I didn't check the user name(s).
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Your post here[^]
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
How can I play flash on C# form? Can you help me about that please?
Thanks in advance.
|
|
|
|
|
Link 1[^]
Link 2[^]
Both do exactly what you should have done before posting and you might have been finished this project (or the part that you asked about) by now instead of waiting for another to do a simple search you could have done yourself.
|
|
|
|
|
The problem is that you answered in just about 12 minutes. You're never going to teach him by giving him such good service.
Scott
|
|
|
|
|
Maybe he will say thats 12 minutes I could have saved by typing in googles URL
|
|
|
|
|
Maybe...but don't hold your breath.
|
|
|
|
|
|
|
What I want to do is something like this, which fails because NumericID is an int type.
ds_Search.SelectParameters.Add("NumericID", "%");
The only relevant hit I was able to find was from the dubious quality website expert exchange (first result, very bottom of the page)[^]which said I either needed to change the DB to have a string field (not possible) or write seperate queries for the wildcards (impractical because there're dozens that would need duplicated).
Are those really my only options?
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
A numeric is not a string, but you can convert the NumericId to a string in a query. Only then can it be compared with a string.
Jean-Christophe Grégoire
|
|
|
|
|
Do you mean a query that would take a string parameter and convert it into a number before looking at the table? If so, could you give an example?
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
What records are you selecting with that? Every record that has an int-value of "%"?
I don't understand what you are trying to do here. What is the SQL-variant of the query you wanna run?
I are troll
|
|
|
|
|
Hopefully this'll still make sense after being (heavily) cut down and generalized, the real query has more stuff in all 3 sections of sql statement.
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (table2.table4ID = ?)
table2.table4ID is selected from a listbox that contains all the values in table4 (each giving a table4ID value) or "all" in which case I want to pass a wildcard in.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
dan neely wrote: or "all" in which case I want to pass a wildcard in.
How about removing the
WHERE (table2.table4ID = ?)
If you omit the WHERE-clause altogether, wouldn't that effectively give you all the records that a wildcard would select?
I are troll
|
|
|
|
|
See my original post. Sometimes I need a wildcard, sometimes I have a specific value. I'd prefer not having to duplicate a dozenish queries if I don't have to in order to implement the wildcard because of the increased maintainability difficulty.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
As far as I know, ANSI-SQL supports wildcards only for filtering on text-based columns, through the LIKE-operator. This option gives you two separate queries;
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (table2.table4ID = 10) (10 being an example of a specific value)
SELECT table1.table1ID AS ID, table2.OrgTypeID
FROM (table1 INNER JOIN table2 ON table1.table2ID = table2.table2ID)
WHERE (CAST(table2.table4ID AS NVARCHAR) LIKE ('%'))
The second version will convert all values in the table4ID-column to the NVARCHAR datatype.
I are troll
|
|
|
|
|
An engineer was trying to set this up to access the Usage string array in struct from main.cs class. see code snippets below. The problem is that the object variable uArray can't see the Usage array from the struct. Can anyone help me to get the string array of Usage in main.cs?
<Code snippet>
// InfoTable.cs
using System;
using System.Collections.Generic;
using System.Text;
namespace infoTable
{
public class InfoTable
{
private struct InfoStruct
{
public string[] Usage;
public string[,] Line;
}
int DLLVer = 1000;
ACMEStruct ACME = new ACMEStruct();
public ACME_Info()
{
ACME.UsageCodes = new string[255];
ACME.UsageCodes[0] = "lab 0";
ACME.UsageCodes[4] = "lab 4";
ACME.UsageCodes[5] = "lab 5";
}
public object GetACMEValues()
{
return ACME;
}
}
}
// main.cs
private void readUsageArray()
{
InfoTable iTable = new InfoTable();
object uArray = iTable.GetACMEValues();
}
|
|
|
|
|
I take it that you are converting the returned object to the correct type (ACMEStruct , I believe); like this:
ACMEStruct acme = (ACMEStruct)uArray;
If not, then you need to do this in order to access the ACMEStruct members of the Object by unboxing it into the appropriate type. If you are already doing this please include the relevant portions of the ACMEStruct definition.
Keep It Simple Stupid! (KISS)
|
|
|
|