Crystal Report Viewer TollBar click - ASP.NET Discussion Boards

You haven't explained how you are requesting your reports. However SSRS exposes a number of web services that allow you to make requests to a report server programmatically. The ReportExecutionService class exposes a Render[^] method can be used to process a report and render it in a specified format.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Well I'm using The ReportViewer object, and it's a local report if this what you meant on how i am requesting my reports.

I will look into the Render method. Thank-You for your reply. And if someone knows a good site that would explain this render method that would be convenient.

I'm not aware of any other articles on the SSRS web services. However the MSDN documentation (see my previous link) tells you everything you need to know, including sample code. Set up a web reference to the web service and you're good to go.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Hi guys,

i made an asp.net application report, and it works wel but it can
not export to excel. It does export to pdf. there is an unhandled
exeption that says some font is missing, but i dont think so because
before that, we had the same problem with pdf and finaly we found out that the application didnt have sufficient right to the font folder, and when we gave it that it worked.

So this is becoming more stranger that it has only problem
with excel. the point is that on the development server all works perfectly and this problem we have only on test server. i searched a lot
and googled a lot, there are very few sources about this probem and if there is one, it is the problem with both excel and pdf, can anybody help?
is there any known issue about this?

any idea is welcome...

thanks very much
ceti

Why doesn't it export? Does it produce an error?

You need to provide more information if you want someone to help you.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Thanks Paul for your reply, the thing is that yesterday i was at home
and i couldnt send any error description, and surprisingly today without
me doing any thing the report works completely and no error to send to you.

but just for your information i will tell you a little bit more. I had 4
reports (one of which with graphic) and until yesterday morning (on test)
i couldnt export to neither pdf nor excel and also the graphic didnt work at all,...(we got the font missing error) anyway going to server guys we found out that application didnt have any right to read from the folder font of windows,...we gave the rights to it and all reports worked
plus all export to pdf, but no export to excel, for excel i got almost
the same error (font (?) missing) and it was very strange for me then because i had solved that very problem...(by now it was noon)
but until the end of day the export to excel just didnt work, and then
i posted this thread,...but this morning when i came at work export to excel worked to,....again thanks for your reply

ceti

I'm trying to update details view using dataset in C# codebehind. When i try to access OldValues and NewValues in ItemUpdating event, i get 0 count for both and also for keys.

How can i correctly get these values?

Hello Every Body,

I have a button on my page, when i click btnShowReports then it shows my desire reports without asking login information (on page load event i put the report viewer login information)

But problem is, when i click the CrystalReportViewer toolbar (Export, Print) then nothing come also it invisible my CrystalReportViewer.

If I do it on Page_Load event then CrystalReportViewer toolbar work nicely

My Code is Below:

ASPX CODE

<br />
<tr><br />
                <td colspan="3" style="font-size: x-large; color: #000066"><br />
                    <asp:Button ID="btnShowReports" runat="server" Text="Show Reports" Visible="False" /></td><br />
            </tr><br />
            <tr><br />
                <td colspan="3" style="font-size: x-large; color: #000066"><br />
                </td><br />
            </tr><br />
            <tr><br />
                <td colspan="3" style="vertical-align: top; text-align: center"><br />
                    <CR:CrystalReportViewer ID="crViewer" runat="server" AutoDataBind="true" ShowAllPageIds="True" BorderColor="#E0E0E0" BorderStyle="Solid" Height="50px" /><br />
                    &nbsp;<br />
                </td><br />
            </tr><br />

ASPX.VB CODE btn click event

<br />
Dim _Connection As SqlConnection = New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("TCCLMS").ConnectionString)<br />
        Dim _QueryString As String = "SELECT MEMBERID, BOOKID, DATETAKEN, DUEDATE, SUBMITDATE FROM BORROWERS"<br />
        Dim _DataAdapter As SqlDataAdapter = New SqlDataAdapter(_QueryString, _Connection)<br />
        Dim _dtBorrowersDataTable As dsReportViewer.dtBorrowersDataTable = New dsReportViewer.dtBorrowersDataTable()<br />
        Dim _ReportBorrowers As ReportDocument = New ReportDocument()<br />
        Try<br />
            _Connection.Open()<br />
            _DataAdapter.Fill(_dtBorrowersDataTable)<br />
            _ReportBorrowers.Load(Server.MapPath("crBorrowers.rpt"))<br />
            _ReportBorrowers.SetDataSource(CType(_dtBorrowersDataTable, DataTable))<br />
            Me.crViewer.ReportSource = _ReportBorrowers<br />
            Me.crViewer.DataBind()<br />
<br />
        Catch ex As Exception<br />
<br />
        End Try<br />

any instruction will be really helpful

thanks in advance

Sarfarj Ahmed

Hi Everyone,

Is it possible to schedule a task daily using asp.net and vb without using windows scheduled task and services. I tried using threads, it is consuming more memory and system gets hanged.

Can any one help me in this regard.

Regards,
Manowj

You could use a SQL job if this is an option. What is wrong with a service (it's what they're designed for)?

What you could do is to check the local server time when the web page is called, and if it is within a certain range then run a special routine / function call to do the task. You could then set a flag in your application so that if another user calls the page within that time range, the task doesn't execute again.

As long as you are certain that you will have at least 1 visitor between those hours this would work.

Pete Soheil
DigiOz Multimedia
http://www.digioz.com

Hi,

Requirement: In application start,the schedule is triggered and it should generate report by fetching data from database(DB2) and export into word or excel and send a mail daily. This scheduler should work as background process, should not depend on the browser. Windows services or windows scheduler should not be used as per requirement

Please help me in this regard.

Regards,
Manowj

manowj wrote:
Requirement: In application start,the schedule is triggered and it should generate report by fetching data from database(DB2) and export into word or excel and send a mail daily. This scheduler should work as background process, should not depend on the browser. Windows services or windows scheduler should not be used as per requirement

The only other thing that I can think of that could do this would be for you to create a DTS Package and schedule it to run at specific pre-set times.

Pete Soheil
DigiOz Multimedia
http://www.digioz.com

I built a online photo album in vb 2005 express site #13
I built a Wrox chat site Site#14
How can I join them together?

I am not sure I am understanding your goal here. So are you trying to allow users to insert pictures from the photo album in the chat box? Or are you trying to create a seperate chat box for each gallery so that the users can talk about the pictures? Or something else?

Pete Soheil
DigiOz Multimedia
http://www.digioz.com

Don't quite follow you. What are you trying to do?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

can any one has done the code for getting FLV file play time length , just like youtube shows for all of its video

modified on Tuesday, December 18, 2007 11:35:00 AM

Please desist posting the same query multiple times in discussion forums as it would only irritate the users. You already posted it here:

http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2361078[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Show your talent don't give unnecessary commments,forum is for helping others not tried to hitler as u r not the owner of this site. if u know u r welcome , if u didn't don't waste ur time in giving lectures to other.

Good luck getting help from anyone now. You didn't play by the rules, someone called you on it and you insult him?

Current Rant: "I want my news in ENGLISH."
http://craptasticnation.blogspot.com/[^]

leckey wrote:
Good luck getting help from anyone now.

I ditto that.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Judging by your recent posts, you appear to be both ignorant, rude and stupid. That's quite an accomplishment.

I suggest you pay close attention to the forum guidelines and return again when you have mastered the art of forum etiquette.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

pmarfleet wrote:
Judging by your recent posts, you appear to be both ignorant, rude and stupid.

That is why I've stopped replying to the person or just give real half-assed replies Roll eyes | :rolleyes:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

The web application has a link button which when clicked uses the ID in session and opens ID.doc in another machine.

Here is how I access
http://TestApp/MainPage.aspx, I get the link button and click it and ID.doc opens.

Also, am able to open http://TestApp/Docs/ID.doc [this is the virtual directory path where all the ID.docs reside]

The user should not access http://TestApp/Docs/ID.doc [^]
Do you have suggestions on how to do this?

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

What you can do is to place the file outside of the wwwroot directory, and then stream it to the user when needed. That way the user won't be able to access it directly through a URL.

Pete Soheil
DigiOz Multimedia
http://www.digioz.com