Showing posts with label vbnet. Show all posts
Showing posts with label vbnet. Show all posts

Wednesday, March 28, 2012

how to using crystal report with VB.NET by passing the SQL statement

I wanna know how can i passing the SQL statement from VB.NET to crystal report for making the report ?

where can i find the tutor web site for this thing ?

I'm a newbie about .NET and crystal report.

I can using VB.NET to view the report with crystal report but by wizard.. I wanna do in manually.

Thanks
KeeCR.SQLQuery="YourQuery"
where CR is Crystal Reports object|||Could you give me a full sample ? I'm a newbie for the crystal report. and it has no any manually tutorial site. hasn't it?

Thks
Kee|||If if you find this in FAQ section of www.VBCity.com|||Hi,
why couln't you try for strongly typed datasets as ur report source.

get the tutorial from MSDN 2006
here is the link
ms-help://MS.MSDNQTR.2006JAN.1033/dnmag02/html/Crystal.htmsql

How to use VB.NET to open an SSRS report ?

Hi all,

I was wondering whether I should just use the URL posting in aspx as below :-

Code Snippet

Response.Redirect("http://Reportserver/virtualfolder/Deployedfoldername/Reportname&parametername=parametervalue")


or Should i just put this in the asp page ?

Code Snippet

<asp:HyperLink ID="HL1" runat="server" Target="_blank" NavigateUrl=http://Reportserver/virtualfolder/Deployedfoldername/Reportname&parametername=parametervalue">Click on Report</asp:HyperLink></div>

I can't really test this out at the moment till i get a go ahead from the IT Department that SSRS is up and running and i can deploy the reports.

I was wondering what would the effects be for each code in their respective pages ?
Would the aspx be able to pop up the report page in a new window automatically ? OR the second piece of code is a better way of doing it ?

Sincerely,
Bernard

Hi,

these are two different mehtods, the first one will redirect the page making the window to shop up the report in the same window, the hyperlink option would display the report in a new (_blank) window. this would not happen automatically, the user will have to click on the link where in the first case he will be automatically redirected to the reporting services report.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi Jens,

Thanks for the reply.

Well the first one will be in an event click, so the user would have to click on the link for it to open the report.

I forgot to put the sub around it.

another question relating to this, is the passing of parameters. I am going to be using Session variables in the application, and am beginning to wonder whether

I should use the Sub code. I know that I can do this in ASP (html/javascript) but I feel that it is easier to work with sessions in ASPX.

I found an interesting article which says that I can achieve the opening a new window on a click by doing this in the sub.

Code Snippet

Response.Write("<script>window.open('http://Reportserver/virtualfolder/Deployedfoldername/Reportname&parametername=' & Session("value"),'_blank');</script>")

I am not sure whether this is considered as a pop-upwindow or a new window. Can somebody shed some light on this ? Thanks.

Bernard

|||I would alway try to use pre HTML Code, rendering the information for the link in the first request. This pure client side action will allow you to avoid a second roundtrip. The solution you mentioned with the window.open function in Jscript would probably cause some browsers to block the popup window. So try to render out the a href code, this is (for me) more straight forward.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Jens K. Suessmeyer wrote:

I would alway try to use pre HTML Code, rendering the information for the link in the first request. This pure client side action will allow you to avoid a second roundtrip. The solution you mentioned with the window.open function in Jscript would probably cause some browsers to block the popup window. So try to render out the a href code, this is (for me) more straight forward.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

HI jens,

Thanks for the reply !

That's what i was afraid of, pop up blocking. At least now i know that the window.open won't work correctly. Thanks !

So basically, All i need to do is put a hyperlink tag in the html, and then specified which report is going to show up in the "href" and then "target=_Blank" right ?

And then somehow use or try to use a session variable in the html code ?

Thanks

Bernard

|||Hi,

compose the URL within your code, like HL1.NavigateUrl = "http://someserver/SomeHtml.aspx?SomeVar=" & Session["Something"].ToString();

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

Thanks for the reply!

Yeah should have thought about doing that ! Thanks ! Don't know why i was trying to give my self alot of headache trying to do it in html instead. lol.

Really appreciate this !

Bernard

Wednesday, March 21, 2012

How to use Sql Servers Temp table in vb.net

There r two types of temporary tables in sql servers
1) Local temporary table (#tablename)
2) Global temporary table(##tablename)

but when i m creating any temp table & using it in .NET it doesn't store all the data..
i am storing data one by one but only last inserted row is visible in that table...

any solution on that...

pls help

Thanks in advance...

Mukund TambeMake sure that you use one connection only, and that you do not close the connection between the inserts. Local temporary tables (#) are deleted when the connection through which they were created are closed. Global temporary tables (##) are deleted when the last connection referencing them are closed.|||Make sure that you use one connection only, and that you do not close the connection between the inserts. Local temporary tables (#) are deleted when the connection through which they were created are closed. Global temporary tables (##) are deleted when the last connection referencing them are closed.
let me check..

thanks a lot roac..|||You may also be a victim of "connection pooling" if you are running in an environment like ASP where you can have many threads sharing access to the same database. Each call to the database needs to stand on its own in a connection pooling environment, you can't depend on what may or may not have happened in a previous call to the database when you use connection pooling.

-PatP|||You have to let us know what you're doing...because it sounds dicey to begin with

Can you write a stored procedure?sql