|
I am currently migrating a VB 6.0 windows application to vb.net.We are using crystal reports 7.0 in VB 6.0 where the rpt files are located in a separate folder and manipulated at runtime with proper inputs.
Now i have to write code that uses .net 2005 crystal engine that manipulates the same rpt files in the same way at runtime.Here is my vb 6.0 crystal reports code.
With CrystalReport4
.Reset()
.WindowShowSearchBtn = True
.Connect = gs_ReportConnectStr
If Trim(s_TableName) = TABLE_5A Then '"5"
CrystalReport4.set_DataFiles(0, "WBXD_TABLE57_TMP3_T")
.ReportFileName = REPORT_PATH & "tab5a7.rpt" 'TABLE7_RPT
ElseIf Trim(s_TableName) = TABLE7 Then '"7"
CrystalReport4.set_DataFiles(0, "WBXD_TABLE7_FINAL_T")
.ReportFileName = REPORT_PATH & "tab5a7.rpt" 'TABLE7_RPT
End If
For i_Index = 0 To .GetNSubreports - 1
.SubreportToChange = .GetNthSubreportName(i_Index)
.Connect = gs_ReportConnectStr
If .GetNthSubreportName(i_Index) <> "Spec.rpt" Then
If Trim(s_TableName) = TABLE_5A Then '"5"
.set_DataFiles(0, "wbxd_table57_tmp3_t")
Else
.set_DataFiles(0, "wbxd_table7_final_t")
End If
Else
.set_Formulas(0, "CountryDesc = " & Chr(34) & s_CountryGroupName & Chr(34))
.set_Formulas(1, "CurrencyDesc = " & Chr(34) & go_RefTables.fn_CurrencyDesc(s_TableCurr.Value) & Chr(34))
End If
Next i_Index
.SubreportToChange = BLANK_STRING
If Trim(s_TableName) = TABLE_5A Then '"5"
.SelectionFormula = CStr("{WBXD_Table57_TMP3_T.T573_job_Id} = " & l_JobId) '& " and {WBXD_Table57_TMP3_T.T573_Desc_Upto_Asof} <> " & Chr$(34) & "999999999999999999999999999999" & Chr(34))
ElseIf Trim(s_TableName) = TABLE7 Then '"5"
.SelectionFormula = CStr("{WBXD_Table7_final_T.T573_job_Id} = " & l_JobId) ' & " and {WBXD_Table7_final_T.T573_Desc_Upto_Asof} <> " & Chr$(34) & "999999999999999999999999999999" & Chr(34))
End If
.Destination = i_Destination
i_result = .PrintReport
End With
Can somebody help me out in writing the .net 2005 equivalent code.
|
|
|
|
|
Its sort of urgent.Any help is kindly appreciated.
Let me make things more clear by pointing out what i need in the code.
1..Connect = gs_ReportConnectStr
gs_ReportConnectStr is a connection string using ODBC DSN.What is the code for connection string using odbc dsn in .net crystal reports 2005.
2.CrystalReport4.set_DataFiles(0, "WBXD_TABLE57_TMP3_T")
How can i set datafiles in .net crystal reports 2005.WBXD_TABLE57_TMP3_T is the name of the SQL table.
3..SubreportToChange = .GetNthSubreportName(i_Index)
.Connect = gs_ReportConnectStr
the qns 1 and 2 also apply for the sub reports.
4..setFormulas(index,formula)
What is its equivalent in .net 2005 for both mainreport and subreports.
5..Destination
i need the report to open out in a separate window.How can i do this in .net 2005.
|
|
|
|
|
Well Rameel this is urgent only to you, these forums are to help others to better their programming skills. Therefore your first post was not going to get a response, we are not interested in writing your code for you.
However your second effort shows you are at least working on it so!
1 Go here for ODBC connections clickety[^]
2 Each report has 1 or more tables which all need to have their credentials applied, use foreach table in report.tables
4 - sorry can't help
5 I used to have a seperate form with a viewer, I would open the RPT, connect the tables in the RPT to the database, pass the RPT to the viewer and then display the form.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks a lot Mycroft.
I did go through the articles regarding crystal reports posted here and i am trying to solve it out.
One more help.The link u gave for ODBC is not opening.Can you recheck and include it once more.
|
|
|
|
|
sorry the link was typed rather than copied try[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello Again!
AS the datacenter costs are astronomics I have more and more the same idea... get rid of most servers...
I think it is possible (partially) by implementing a lot of the background work over WebServices, but for that I need to know if there is some way  to subscribe and consume WebServices Public Events on Windos Forms Applications.
I dream about a WebService to control the Session Status of my Users, by alerting then whem messsages comes, or by kicking then when necessary, etc...
Maybe someone had the same idea and have success on that...
Please, if is there any code (vb.net pleeeese) to implement Public WebServices Events, and Consuming them over an Windows Form Application LET ME KNOW! Because I really want to test this alternative...
Thank You!
|
|
|
|
|
How will this result in less servers?
|
|
|
|
|
By migrating a lot classic (resource consuming) tcp client/server applications that I have to host on separate servers... Politics my friend... just politics... as the clients don't understand that their services are running together whith a lot of other services just on the next door...
But if I offer a WebService intead a classic Client/Server, it will be less complicated... and... I promisse that... I will put everething together on just one server without any problems...
The true isn't what we want to hear every time... sorry... but it is not a techinical justification to migrate those services... as I think you are expecting...
Thanks.
|
|
|
|
|
The easiest way these days is to virtualise. If these "client/server applications" can't exist together on one machine and you want to cut the number of machines then virtualise the existing machines using Virtual Server or VMWare. This way you don't waste time re-writing everything.
Of course, if you need to re-write one of these "client/server applications" for other reasons then it may be an opportunity to upgrade to newer technologies.
By the way, do you know that a web service is just another example of a client/server application?
|
|
|
|
|
Off course... webservice is just another type of the same thing... but has the ability to impersonates the backbone behind the application... and that is just what I want...
And yes... I will be thinking on virtualizing those servers... if possible because I rely on rented servers.
Thank You!
|
|
|
|
|
|
Thanks for your attention!
About the WFC...
Is there any way to implement this on WebServices? Is that hard and time consuming or there are dev tools on the VS2008 to help on that?
About wondering....
What costs me much is the number of servers I have to maintain "isolated" (for the sake of the purity) with few classic (tcp) remoting client/server just to control, response and manage those remote events... Not the server (processing, storage...) resources consuption... For me it is very easy to put everybody (the servers app.) on the same server... but I don't think It will be fair with my clients (unless they know that they will be consuming a WebService intead a classic remote server solution)... and... it is not safe to put different classes of services running on the same server, because I just can't be 100% sure that the server is 100% hacker safe forever...
That's why I dreaming on get rid of all my classic remoting solutions to abrace WebServices... At least I need to experience it...
Thank You!
|
|
|
|
|
|
|
Thank you again!
I Think You Get My Point over my WebServices thing...
But, that's it?! Now I will have acess to [only one!] event called [webmethodwhatever]completed...
Please help comment this....
Is it possible to use this Tip of yours to implement something like this?
1 - Create a WebMethod that opens a kind of session controller for the app clients... and keep this method running until any flag tell it to raise that completed event.. terminating the session for that client...
2 - If it is possible we have half way there... Because I need that while the client still connected to this "webservice_controlled_session_kindof..." he also send his status to the session (active, sleeping, querying... whatever..., and receive session messages, etc... like any other client/server solution of mine...
How do I do that relying only on webservices?
THANK YOU!!!!!!!!!!!!
P.S.
I send a request to join on you [linkedin.com] professional network... hope you don't mind... thanks..
|
|
|
|
|
E.Nando wrote: Create a WebMethod that opens a kind of session controller for the app clients... and keep this method running until any flag tell it to raise that completed event.. terminating the session for that client...
As far as I know there's no good way of doing this with web services. Only thing that comes in mind is a polling system.
E.Nando wrote: I send a request to join on you
I'm trying to keep the number of my connections very low and only people I know in person. This has been a policy for me for years, nothing personal in it.
I'd like to add one thing. The way I see it is that both Dave and Colin have excellent knowledge and they are capable of seeing wide concepts. Personally I like when someone suggests something, even though it may not be exactly the answer I was looking for. This usually helps me to reconsider, what is my target and possibly redefine it, if necessary.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
You've thought of this WAY too late. You haven't heard of blade centers or Virtual Servers, have you??
Besides, you're method of using Web Services will not result in a lower server count, but actually increase it.
|
|
|
|
|
It will depends on the numbers of requests you have... As all solutions that I have the opportunity to develop until now, does not have "that" kind of hits count... they have to be on separate servers because the clients want that way...
But if I stop offering classic tcp client/server solutions and offers the same result over the WebServices solution... this will be "the" solution for "me"! because it will justify different solution from a (application solution provider) domain running together on the same server (at least it appears to be the same server...).
And... about the blade and/or virtual servers.... THEY COST 300 bucks/month!!! Isn't they?
|
|
|
|
|
E.Nando wrote: And... about the blade and/or virtual servers.... THEY COST 300 bucks/month!!! Isn't they?
Where did you get this from? You're talking about reducing the server count in a business that usually has their own servers, not rented. In a few corporate cases around me, there's movement towards building a single large server (multi-proc, 16GB+ RAM, large drive arrays) that's running Virtual Server, on which, there's about 10 to 15 "normal" servers running. Since the bulk of a server's time usually spent idle, you can get away with running multiple virtual servers on a single physical machine.
Blade centers are just a frame to hold, power, and manage, smaller, low cost servers, offering flexible scalability.
And no, this does not cost $300 a month. Maybe in power costs, but not renting costs since you own the hardware.
You're still behind the curve with this idea. Look into "Software as a Service"...
|
|
|
|
|
Oh my...
I have a [small] business that relies on rented servers... yes... and by fact... have no intention on creating a big enterprise... nor to be surrounded with very important staff people...
I just want that "Software as a Service" thing... works for me as well... and by that... I mean that I want to try to put everything I can on WebServices... on a unique central server... just to enjoy my life better...
And thank you for give me nothing... again...
|
|
|
|
|
E.Nando wrote: I mean that I want to try to put everything I can on WebServices...
May I suggest that you put the appropriate stuff on Web Services. Don't make the mistake of pigeon-holing all your applications just to find out that Web Services wasn't the most appropriate way to do something.
E.Nando wrote: And thank you for give me nothing... again...
BTW, you started this thread by saying "datacenters". That's not exactly a "small business" term...
modified on Sunday, November 16, 2008 8:26 PM
|
|
|
|
|
Yes... thanks for your suggestion... and yes I am worryed about centralizing on one "aparently weak" or "new" tech... but I need to try...
And sorry, I really used the wrong term... "datacenter" is not the right term.
Thanks!
|
|
|
|
|
Hello there!
I want to know if there is some way to override the connection class to implement any kind of crypto desired (including custom crypto).
I say... I need a code (vb.net please) to intercept any incomming reads and any outgoing writes to implement crypto methods easily.
The benefits are enormous as we will not have to change the queries.
Thank you!
|
|
|
|
|
If you do that, how will the database be able to tell what queries you are sending? Or how will it be able to send the answers back encrypted in the way you want?
|
|
|
|
|
Thanks for your attention!
Look... The queries will not change...
When I query: "SELECT Name, Address FROM Clients WHERE Name = 'John Doe'" on the code... the server just do the thing... responsing something that is crypted without knowing that... and that IS ok...
What I need is to avoid custom code customization like this:
myQuery = "SELECT Name, Address FROM Clients WHERE Name = '" & Crypt("John Doe") & "'"
I need to develop something smart enough to intercept this message and replace only the crypted fields (I will have to inform what field are customizing the connection-or whatever class, or by informing a pattern like... all text fiels... or all fiels with fieldnames begining with "abc"... whatever) with the right values to be possible the server catch the query...
I don't need to rely on storage procedures or triggers or any database engine... I need code side solution for this... I am a developer... not a DBA... and... I dont need those crypto/decrypto methods on the hands of anybody else... nor saved on the Database trigger code... it will be not safe...
On the end I need something on the DataAdapter, or on the Connection classes to intercept this message and translate it before sending the command for the database engine...
And... on the other hand... the response will be the same....
As the server sends me something like this...
Name | Address
--------------------------------------
~4wi2.s |!´$dn8#$0z0e[´_=2^/\!%
I need those fiels automaticaly re-rendered to something readable whitout having to code, because the class translates it for me...
Name | Address
--------------------------------------
John Doe | 2540 Developers Street
Avoiding the hard code:
For each Record replace Record.value with Decipher(Record.value)... etc...
Ok?
Please... give something to begin...
Thanks...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
