The url enters the address:
"https://IQuoteSummary.asp?vid=1,521.00&lid=12.00"
It works when I run the report in crystal but after publishing it on
the crystal publishing wizard thing, I get those weird numbers.
I need these numbers as ints and without a comma. I tried changing the
formatting on the database fields on the report but that doesn't work.
Any idea how to get the url to print like this:
"https://IQuoteSummary.asp?vid=1521&lid=12"
I know this question has been asked here before, but it was ridiculously answered : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=98764&SiteID=1
I have a text object on my crystal report, to which I programmatically want to assign text in CS. It all works fine, except that if I have html tags in there, the text doesn't get formatted, it just displays the html tags as text as well.
Now in thread linked above, the answer was: right click the text object, and format the text object, hit paragraph text and select text interpretation to HTML. The only problem is, that for a text object, it doesn't have the text interpretation option. It's only an option for a formula field. It says so in the tech support link posted inside the post itself!!!
So if you have any idea how I can do this, please someone help me out. I am new to crystal, and there's not much helpful info on it online. I've searched for this for hours, and no solution.
I have another question about my Access/SqL Database. one of my tables is going to have 2 or 3 hyperlinks and I was wondering can that be done through sql or would I be better off doing it through access?? (the database consist of sQL tables but the gui for the users is access)
Hi everyone I have 3 tables (SQL table) one is the employees table and the other two are link tables for documents the tables have a one to many relationship. everything is running smoothly accept in my in my access form (which is the gui for my users) I can get the field names to look like a hyperlink but I cant insert the address. Since they are sql server tables thats not an option. Can someone help me out pls. I attached a pic of the drop down box to give you a visual of what I'm talking about is there a TRIGGER OR STORED PROCEDURE I could create for this maybe?? Do know VB so wsa wondering if there is a way I could bo it by using sql instead??
Hi everyone, I am trying to hyperlink a file to the report. We are running visual and in one of the fields, we have a pdf file linked to it. When I tried making a report that pulls that information so we can click on it and be linked directly to the file, but all it gives me is the path to the file. Is it possible to link it that way??? I notice under properties, there are option for linking but its just for a report, bookmark, and URL. but none for direct files. Please help.
I have created an SRS Report, that contains a list of Account Names.
On my reports, I need to create hyperlinks for the Account Names field. So I tried the following;
- In Layout mode, selected appropriate field (AccountidName) - Right mouse clicked and selected Properties - Selected Jump to URL - From field list, selected AccountId - Clicked OK
I'm trying to find a way to put in a hyperlink to a url so the url linked to comes up in a new popup window and leaves the original report visible. Any help greatly appreciated.
I would like to ask a question here about the hyperlink in reporting service.
I have programmed a report and it runs perfectly in my PC. Unfortunately when I deployed it to a server, the hyperlinks in that report can not be clicked. Is it because of the version at the server which is 9.00.2047.00? My development version is 9.00.3042.00.
Hi I have developed a report using microsoft reporting services with certain fields In my report the user enters name (which is a parameter) and the report is displayed
Inside my report. I have a field studentID which should be a link which when clicked should take me to a new report which is a report in extranet. Currently I dont have access to that rdl and for certain reasons, I am asked to link to that report by coding a hyperlink in development
I know that in the text box under action properties I need to give the url , but its not working Should i specify the student id anywhere . What and where should I code??
I was wondering if it would be possible to put report data in a hyperlink. For instance I have a report that pulls up a UPS tracking number and I want to be able to put it in the hyperlink to check the status from the UPS website.
I.E. http://www.upstracking.com/myhsk?<sql-data>jkhaskd
Hi, I want to store an image hyperlink in a sql database but don't seem to be able to do it..is this do-able? I can store a hyperlink in text format, no problem, but how do I do the same with an image? I want to use images in my images folder. I can create an image field and set the required options to display images all that is pretty straight forward but trying to display the image as a hyperlink ( actually it's a mailto: link I want to use) seems not to be an option. The purpose of this is to allow users to upload an image together with their email address and when other users click on the image it fires up their email app. I do not want to have to use a text link. Thanks
I have a web control which produces a drop down list of items that are stored in my database. The problem is that my SQL call is not properly displaying the hyperlink in .aspx please see my screen shot and code below. I also have ensured the link table in access is set to hyperlink. Any thoughts would be helpful as this is driving me nuts. Thanks in advance.
I want to store a hyperlnk in the MS-SQL table as in MS Access.I could not find any datatype for storing the hyperlink in MS-Sql. So Kindly please help me to store hyperlink in the MS-SQL Table.
Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727
Installed it came with SQL Server 2005, and for awhile now I have been trying to create a hyperling to a folder with our scanned files on it. I go to the Jump URL and then I put in a link address like
I've got a situation where a report I'm developing needs to have hyperlinks to another report. Easy enough. However, the hyperlink needs to land on Page 2 of the other report, instead of the default page 1. Any ideas??
Hi, I am a having a simple table where i am having 4 columns. First column is displaying employees name: There is a drill down report when i click on each employee which inturn displays his details. My requirement is :How can i create hyperlink for the employee values(At start,blue color for employee name with underline and after coming back from drill down red in color for the employeename with underline). Is it possible to use Javascript to do the follwoing implementation or it is possible in SSRS itself. Requirement is very crucial and urgent..
I have areport with a text box. The text box is hyperlinked to another report url. The report opens in a new page when previewed with RS 2005 but when deployed the report opens in teh same page from where it is referenced.
How can I set a property with the texbox to always open in a new page the hyperlinked report.
I have a report that uses Jump to Report and passes Reportname with parameter. Is there a way to suppress the parameter value in the URL so the user is unable to manipulate the parameter and execute the changed URL?
I have a popup window that opens a server report in PDF format using URL access and within this report there are hyperlinks to webpages.On clicking the hyperlinks from within the report we get the following error :
"Internet explorer cannot download.Unspecified error".
we have used javascript in the jump to URL expression:
I have some hyperlinks on different rows of a table in the report. Currently when I click on these, they open the links on the same page. I want the link to open in a new instance of IE.
I tried using "javascript:void(window.open('http://www.google.com','_blank'))" as the URL, but this will virtually do nothing.
Hi Folks, Is it possible to add <a href=""http://www.yahoo.com"">xxxxxx</a> tag in varchar column as a text and display it as html hyperlink xxxxx (hyperlink). Thanks in advance Regards
I would like to change the output of a column into a hyperlink however I am not sure that is possible without some further post-processing. I am aware I would have to do:
Code: select '<a href="' + URL + '" target="_blank" nav="web">' + tbl_ID.ID + '</a>' from tbl_ID however this obviously just exports the text <a href="[URL]" target="_blank" nav="web">[ID]</a>
This would work fine if I was exporting it into some sort of HTML table however this doesn't work with excel for example. Is there a way to make this possible or would I have to create a macro in excel to add the url with the ID separately?
Using the Report Builder, the users need to generate a report in which one of the columns should have a hyperlink that navigates to a particular aspx page.
Now, I am able to provide for a hyperlink enabled column from the static reports designed using the Report Server Project. I have used the Navigation --> Jump To URL property of TextBox for this.
But the users dont want to depend on static reports and need this to be available via Report Builder.
I tried to provide for the <a href="somepage.aspx">xxx</a> from the named query in the datasource view, but when I run the report, the Reporting Service HTMLEncodes the tags and displays everything as text.
Is there a way to generate a hyperlink using Report Builder.
I need to be able to to extract the data that is returned by clicking a hyperlink. I click the link and it displays the data.
I know that SSIS has a web services task, and that appears to be a neat feature, but the link I am connecting to does not have a WSDL file or anything like that. So I think I cannot use this task.
Does anyone have a suggestion about how I might do this?
I have two reports. I need to provide a service that when the user click one hyperlink (or button), then the program can export these two reports to two files as PDF and let the user save it one by one. Is it possible?
I have a report which has 2 tables. The first table shows the current summary data as below.
ServerName Date ProjectStatus
Srv1 01/10 Green Srv2 01/10 Red Srv 3 01/10 Green
and the second shows the detailed history per server,
eg for Srv1
Table 2 ServerName Date ProjectStatus
Srv1 01/10 Green Srv1 01/09 Green Srv1 01/08 Red Srv1 01/07 Red Srv1 01/16 Red
I have a link on Srv1 column, on click of which i want to filter and show the data only for Srv1. If user clicks Srv2 data in table 2 should be refreshed with values only for Srv2.
How to do this ?
Note: I have done this using subreports but I dont want to use sub reports for when it comes to using them in web aspx page it has its own issues.
I want a single report to have this functionality.
I am not able to set the Report Parameter on click of link.
