|
I think that might have been vague. Here is what I'm doing:
Created a report, put 3 (columns) text objects (ID, Name, Salary), now I want to fill these columns by a select query (not only that). You might say use datasets, but I say not, since I'm using SQLite for the DB, and i'm creating datasets directly from code (no xsd). Plus, i'm not only using the select query, e.g. the Salary field is calculated by a function that takes an ID as a param. I read about binding to xml and such, but I have no need for that.
So, what is the solution ?
Regards
|
|
|
|
|
Actually the answer is a recordset, use the data from your database, cycle through the records to calculate the other fields. Then create a new recordset, recordset.fields.append all the columns you need and recordset.addnew for each row. You'll have to use a field definition file for the report since you won't be connecting it to the database though.
The other option is to calculate the fields and insert them into a temporary table, then select off the table. The issue there is to handle concurrent reports and stale data if the report reruns.
If it's possible, the best solution would be to create stored procedures that produce the calculated values, and put them into the select query for the report. Not knowing how your fields are calculated though, that might be more trouble than it's worth, especially if you'd still have to duplicate the function in code as well.
Ah, just looked up SQLite, haven't used it myself. Doesn't look like a stored procedure is going to happen. Also, from the bit I glanced over, a temporary table might have a bit of a performance hit depending on how big it is.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.
|
|
|
|
|
"You'll have to use a field definition file for the report since you won't be connecting it to the database though."
Could you give me an example or direct me somewhere, since i'm quite new to this reporting stuff
Thanks
|
|
|
|
|
The basics of creating the definition file are here on page 92[^]
This thread[^] should give you an idea how to connect the recordsource. There's a pdf file from business objects somewhere that explains each of the steps in more detail. It's kind of a pain to find though. Pretty much it's just looping through the report object and assigning the record source of each report/subreport to be the recordset you already created for it from whatever source. Don't get too crazy with the sub reports though, Crystal gets flaky when there's more than one subreport to assign a recordset to. We had that problem when trying to deal with application roles on sql2005 (Crystal doesn't support them).
Pretty much the big things to watch are that you match up the field names and the order they're in. I forget if they're case sensitive, but probably best to match it up, just to make sure. The definition file itself is just a text file with a list of field names, so you can edit it in notepad, then verify the database from inside of crystal to match things up. The data types are separated by a single tab and you can put a default value one tab after that. For instance
ID Number 99999999
Name String XXXXXXXXXXXXXXXX
Position String XXXXXXXXXXXXX
etc, etc..
Hope this helps.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.
|
|
|
|
|
hi,
i am developed a small win apps by c# and my apps first put some value in windows registry. so i just create a setup and install on Vista OS. when i run my apps then a error occur for registry accessing. if the log on user is admin on vista OS then it is OK but if the user is normal user on Vista then getting error for programmatically accessing vista OS registry. i search Google and found article and they said to add manifest to Exe file to gain admin privilege on vista but still i am getting error. so please some one tell me how could i access registry on Vista OS as normal log on user. please tell me all the steps in detail.
Thanks
tbhattacharjee
|
|
|
|
|
Hi,
registry access rights depend on the hive; e.g. CURRENT_USER should work for everyone, LOCAL_MACHINE needs admin rights.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hi,
I am creating an AVI file in a from the images I am recieving from a web cam. The AVI file also contains a text stream which containing the time each image was recieved. I would also like to add a custom script command to the AVI file when certain events happen. I can then respond to these commands during playback (through a Media Player control)
I have search the web an found a lot of posting which say this is possible, and even some applications which allow you to add custom scripts to existing files, but cannot find any reference about how to do this programmaitcally.
Does anyone know of how to add custom script commands whilst creating an AVI file, or of a good tutorial.
Thanks.
Richard
|
|
|
|
|
I want to display a check mark next to the text of a ToolStripMenuItem, when the user clicked on it.
in the form editor I set the ImageAlign property to MiddleLeft, that should display the image on the right side of the text or?
But how do I achieve that the image gets displayed only whe the user clicks on the menu item?
And whe he does, the image that was displayed for another menu option should be erased (so that the user see which of the options is selected and can see which one he selected)?
I tried the Image and ImageList properties, but I got an error:
Invalid parameter
Thanks.
|
|
|
|
|
Well, I don't have my VS in front of me, so I'll do it out of my head.
There are several possibility's. I think you should do something like this:
In your code, make a function like this:
String[] imagePaths = {"mypic1.jpg", "mypic2.jpg", "mypic3.jpg"};
public void clearMenuItemImages()
{
mi1.Image = null;
mi2.Image = null;
mi3.Image = null;
}
public void onMenuItem1Clicked(object sender, EventArgs e)
{
clearMenuItemImages();
((ToolStripMenuItem)sender).Image = imagePath[0];
}
You can make this faster and better, but this is a start.
|
|
|
|
|
Images ??? Alignment ??? What ???
ToolStripMenuItems have a Checked Property. Set it to true to display a check mark next to the text, set it to false to make the check mark go away.
|
|
|
|
|
Thanks, that did the trick.
|
|
|
|
|
Hi all,
I am developing an windows application(C#) in VS2005 and in that it must have a video player with all aspects like play, Pause, Stop, Rewind, Slow rewind, Forward, Slow forward . I have tried with media player and i am able to bring only Play, Pause, Stop and i was not able to bring other functionality so please help me as soon as possible. It's very urgent.
Regards
Mohan
|
|
|
|
|
Hi,
I need to install and uninstall device drivers programatically.
I could register the .inf available. This helped in installing the drivers without the prompt for installation disc.
However, I'm not able to find as to how these drivers can be uninstalled. I could remove the inf & pnf files created but the entry in the Device manager continues to be there which suggests that drivers are unregistered but not uninstalled.
Can somebody please help me completely remove the drivers ?
Regards,
queries365
|
|
|
|
|
Hi,
I am using rich test box data comes from database,
but i want to start text of required to word i means to say from middle of the data selected word comes first in rich text.
Tel me what should i do?
Please do replay i am also searching on net.
Thanx
|
|
|
|
|
|
Sajjad Leo wrote: Tel me what should i do?
Explain your question better
|
|
|
|
|
Yaar usne thoda sa clear nahi likha hain tum log use paresan kar rahen ho
|
|
|
|
|
WTF, FTW? 
|
|
|
|
|
Use English.
Let me translate this for others:
"Guys, he has just not framed his question clearly. You are troubling/teasing (something like that. English is not my first language.) him."
No one comes here to harass/tease/trouble anyone. OP has not framed his question clearly. If you feel sorry for him rephrase that for others so that one can reply.
जय हिंद
modified on Friday, March 27, 2009 8:41 AM
|
|
|
|
|
yara this is not good i am trying to make it clear but what they are replaying very sad for those who replay me in such a way.........
|
|
|
|
|
I am seriously sorry to say this....
I have no clue of what are you trying to say....
Could you make it more meaningful....
Have a Happy Coding.....
|
|
|
|
|
Do you mean this?
You get a string from database. You want to select a substring from that, starting with a specific word, and display in textbox. For Eg:
From Database: "This string came from database."
Specific word: "from"
So, the textbox should have: "from database".
जय हिंद
|
|
|
|
|
Thanx yes you are right i am looking for this code.
What should i do for this problem??
|
|
|
|
|
Sajjad Leo wrote: i am looking for this code
No one does spoon feeding here. What have you tried?
If you have the string, check out the methods in String class. I am sure they are sufficient to sail you through.
I, infact everyone here, understand English is not our first language. Still try posting your question clearly. Read at least once before posting anything.
जय हिंद
|
|
|
|
|
Dear i know no one have extra time for spoon feeding, well thank you very much i am trying to complete it.
Thanx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)