|
Greetings
I'm using Crystal Reports basic that comes with VS 2008.
I have put 3 (text objects) columns (e.g. ID Name Address), what I want is to add rows, variable numbers of rows of course.
Is there a way to do that by creating parameters ? if not, what other ways are there ?
Regards
|
|
|
|
|
You have to give it a record set. I haven't played with the crystal version that comes with 2008 so I can't give you step by step, however it also depends on where your rows of data are coming from. Is it a database or just data you have in some structure in your program? One way or another the data needs to end up in a record set of a type that Crystal can read. Then you just assign the recordset object or pass in an sql so Crystal can go to work on it.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.
|
|
|
|
|
I have no problem in using a dataset in this case, but the problem is that I can't figure out how to do it programmatically (I don't need the wizard)
Am I missing something obvious ?
Regards
|
|
|
|
|
You mean like this Here[^]
|
|
|
|
|
No. This depends on an already created parameter (using the Field Explorer) at build time.
What I want is to *create* this parameter at runtime.
|
|
|
|
|
Ah, now I understand. I don't think there is a way to create a parameter at run time like that. They're defined in the report file. You can create a few dummy parameters that only get used if they're populated though. Usually for something like that we'd put the parameters on the where clause in the sql, rather than having Crystal do it for us. The SQL server is almost always faster than Crystal will be for parsing of any kind.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.
|
|
|
|
|
Then how about producing several rows ?
Could that be done using 3 parameters (for the 3 columns) ?
Or is there another way(s) ?
Thanks
|
|
|
|
|
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? 
|
|
|
|
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)