| Author |
Topic |
|
Vithi
Starting Member
19 Posts |
 Posted - 2008-12-19 : 09:33:13
|
| I have to create .dll in order for the sql code to be generated in a crystal report. If you guys have any good websites or any idea how i can, i will very much appreciate it. Thank you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 09:39:34
|
| Unfortunately, Yes. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 09:58:25
|
Why do you think you need a DLL?Have you read the blog post?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:00:38
|
| Alright. That is a website everyone should read every morning. Thank you for that and i'm not being sarcastic. My question is,I need to create a Crystal Report. I created 3 subreports in it and it won't execute horizontall at the same time. This is how it comes up to be:Docket Latest x Date Latest y Date Latest m Date12345 2008/01/09 2008/01/25 2008/02/0223456and so on....I tried to do in the same subreport and it doesn't work. same issue. i did it in 3 diff subreports and it doesn't seem to work either. same issue.That's why i've decided that sql might be a good idea. But then, it would still have to be created in crystal report. so i've created 3 Views that would get the latest date for x, y and m. Once that is completed, i inputted into Crystal Report. That does not run either. Now, a suggested idea of creating .dlls for each latest date and inputting it into crystal report seems to be a good idea. But, i don't know how to create .dlls. I googled it and they have of creating it in differnet platforms. I am not sure whether it is a good idea to go this way. Let me know.Thank you |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:02:50
|
Crystal Reports can use the resultset from a stored procedure as source for report data.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:03:45
|
And we don't know what the three subreports are for and what the are used for and what kind of information they display.We can't see them...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:07:26
|
| Yes. That is my plan. Let the sql code generate the data and then generate the code from crystal. Views can be defined as a stored procedure. But it does not seem to work. Is it possible to create something so that it brings all the generated data into crystal; not one by one? Hopefully, i am making sense. |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:08:01
|
| Each subreport were created to bring the latest date for x, y, and m |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:09:28
|
| the code in each subreport is basically, get the maximum date when value = m in 1 sub report.the other is get the max date when value = y and so on.It does get the latest value, but not generating horizontally. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:13:10
|
That is because you have three subreports...Why!? It's beyond my comprehension.You only need a crosstab/pivot report for doing this, without subreports...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:35:35
|
| This article is being helpful.http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspxI did not know that you can create more than 1 data in a crosstab/pivot in crystal report. I am researching and reading now that i know it is capable.Thank you for that. I will try it out and see how things are working. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:38:21
|
You DON'T need a dynamic crosstab/pivot query if you only want the last dates for x, y, and m types.Then you have a fixed number of columns.All this is explained here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=116518
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Vithi
Starting Member
19 Posts |
Posted - 2008-12-19 : 10:46:00
|
| okay. |
|
|
|
|
how to create .dll