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?
View 3 Replies
Hello,
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.
Thanks
Prasad
I am using a windows xp sp 2. I have visual web developer 2005 express edition. .net Framework 2. but when i downloaded the sql 2005 express edition. when i click on the sqlexpr.exe. I receive a message " sqlexpr.exe is not a valid win32 application".
just to try I downloaded the framework 2. for win32 , when i click on the exe file I receied the same message.
Well someone help me please with the sql server. i have almost given it up and using this tool for my last resort.
Thanks
trying hard
I'm using vs2005. I can't print the reports by clicking the print icon only once, i have to do it twice.
After clicking OK in the print dialog box, I can see a pop up message that says it is printing but actually it is not printing, then if I repeat the process it will print. What could be the problem here? Please help. Thanks in advance. :)
We are using Reporting Services 2000.
The print button that is present in the browser is working just fine for some users.
But some users are complaining that on clicking the print button their system restarts.
Some other users are also getting the error "An error occurred during printing. (0x80004005)"
However on closing the browser and opening the report in it again this issue is resolved.
So, the main concern is "Restart of the machine on click of the PRINT icon in reports viewed in some application browser."
Please help!!
I ask because I was testing a Source Control solution that uses SQL Express for its database component, and when I tested it in March it worked fine, but now I can't get the Source Control software to recognize that the database is there. It creates it just fine, it just can't seem to look inside the database instance.
I've tried manipulating ports, assigning permissions, browser on, browser off, I've been at this for about a week.
The Source Control software provider won't provide any information on configuring SQL Express, so I'm here.
.MW
I have downloaded a database from the Wrox website that for use with one oftheir books.I have saved the mdf and ldf files in the data folder - I take it this isthe correct folder as I can see the other databases their.How do I now use this database in SQL Server 2000. When I go to EnterpriseManager it is not listed as an available database.Thanks
View 1 Replies View RelatedHi,
In my application datas are downloaded from "http://www.amfiindia.com/portal/upload/downloadnav.txt;" this website and written on a text file.
Downloadnav.txt contens looks like this
-------------
Scheme Code;Scheme Name;Net Asset Value;Repurchase Price;Sale Price;Date
Open Ended Schemes ( Income )
ABN AMRO Mutual Fund102652;ABN AMRO Monthly Income Plan-Regular Plan-Growth Option;12.8907;12.8907;12.8907;4-Apr-2007102653;ABN AMRO Monthly Income Plan-Regular Plan-Monthly Dividend Option;10.6359;10.6359;10.6359;4-Apr-2007102654;ABN AMRO Monthly Income Plan-Regular Plan-Quarterly Dividend Option;10.5377;10.5377;10.5377;4-Apr-2007102622;ABN AMRO Flexi Debt Fund-Regular Plan-Daily Dividend Option;10.0000;10.0000;10.0000;4-Apr-2007102619;ABN AMRO Flexi Debt Fund-Regular Plan-Growth Option;11.6182;11.6182;11.6182;4-Apr-2007
Birla Sun Life Mutual Fund101843;Birla Bond Index Fund-Dividend Plan (Plan A);10.1607;10.1353;10.1607;4-Apr-2007101844;Birla Bond Index Fund-Growth Plan (Plan B);11.6557;11.6266;11.6557;4-Apr-2007101315;Birla Bond Plus-Insititutional Dividend;10.4411;10.4150;10.4411;4-Apr-2007
----------------------------------------
I cut .copied datas alone in another text file datafile1.txt which looks like this
------------------------------------------
102652;ABN AMRO Monthly Income Plan-Regular Plan-Growth Option;12.8907;12.8907;12.8907;4-Apr-2007102653;ABN AMRO Monthly Income Plan-Regular Plan-Monthly Dividend Option;10.6359;10.6359;10.6359;4-Apr-2007102654;ABN AMRO Monthly Income Plan-Regular Plan-Quarterly Dividend Option;10.5377;10.5377;10.5377;4-Apr-2007102622;ABN AMRO Flexi Debt Fund-Regular Plan-Daily Dividend Option;10.0000;10.0000;10.0000;4-Apr-2007102619;ABN AMRO Flexi Debt Fund-Regular Plan-Growth Option;11.6182;11.6182;11.6182;4-Apr-2007101843;Birla Bond Index Fund-Dividend Plan (Plan A);10.1607;10.1353;10.1607;4-Apr-2007101844;Birla Bond Index Fund-Growth Plan (Plan B);11.6557;11.6266;11.6557;4-Apr-2007101315;Birla Bond Plus-Insititutional Dividend;10.4411;10.4150;10.4411;4-Apr-2007
I am bulkinserting this datafile1.txt datas in to the Sqlserver table "Indian stocks".Since Downloadnav.txt has extra description,title That file is not able to bulk insert.
Now i have to read/filter downloadnav.txt so that file will look like datafile1.txt.
Bulk insert command which i use :
Bulk insert INDIAN_STOCKS from 'C:Documents and SettingsAmrithaMy DocumentsKarthikaRobertRobertdatafile1.txt' with (FIELDTERMINATOR=';',ROWTERMINATOR='');
Can anyone tell me how to read txt file and filter it out(elimates titles,spaces).I am trying so hard for the past 1 week couldn't do.
Thanks,
Karthika
I wish to know if there is a way to react to when a file is placed in a specific directory, what I have at the moment is a scheduled task which runs every 30 minutes, checks whether a file exists and if it does and isn't empty it imports the XML file, however instead of waiting 30 minutes I wish to rn the import as soon as the user creates the file in a specific location, is this possible, can you monitor the directory constantly and then react once file appears ??
any assistance is greatly appreciated.
Hi
I've just downloaded a SSIS toolkit. I was wondering how you would add these tools to the SSIS development environment.
Thanks
Hi,
First of all, I am very new on SQL server express.
Today I downloaded and installed the SQL server express (from www.microsoft.com/downloads), but what I got is only: Configuration tool, (I can see from: Start -> Programms -> Microsoft SQL server 2005->Configuration tool).
I didn't get SQL Server management Studio express, SAL Server Business Intelligence Development Studio, and Documentation and Tutorials.
I don't know where I did wrong, please help.
Thank you.
James
hey all,
i just downloaded sqlexpress and advanced services but i don't see how to get to management studio?
thanks,
rodchar
Hope I can make this clear...
I have to download a file via FTP from one of our vendors, the filename is MMDDYYYY.zip, this is a weekly file and is posted between Tuesday and Thursday, so basically I never know exactly what the file is going to be called, to fix that, I added a FTP Task that will download a file if the date = today (Today = Thursday, when the job kicks off), if this fails, try a file where the name = today-1 (Wednesday), if this fails, try today-2 (Tuesday), all of that inside of a Sequence Container and with MaximumErrorCount set to 3. This is fine and it works fine, good.
Now my other issue, the .txt file inside the zip file (1080.txt), after being decompressed, needs to be renamed to MMDDYYYY.txt, where MMDDYYY = to the file I downloaded, but I never know what the file is going to named (MMDDYYYY, MMDD-1YYYY, MMDD-2YYYY).
Is it possible to output the filename of the file that I successfully download to a variable, so I can re-use name?
Any other thoughts?
When I click the link to download the report in web page, it can pop up a window so that let me "open" or "save". After I open or save this (.pdf) file, I want to auto redirect to another web page. Can I do that? Here is my code:
Response.AddHeader("Content-Disposition","attachment;filename="" + getExportFilename() + """);
Response.ContentType = "application/octet-stream";
byte[] result = rs.Render(TLOWebRptFunc.GetSaveReportPath(this.Context), TLOWebRptFunc.GetReportType(this.Context), null, "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", wparam, credentials, null, out encoding, out mineType, out wparam, out warnings, out streamIDs);
Response.BinaryWrite(result);
Response.End();
I have sql server 2005 express installed on my Vista machine. (Specifically version 9.00.3042.00 of Management Studio Express). I attempted to install the sql server 2005 express with advanced features, which I downloaded from the page at
http://msdn2.microsoft.com/en-us/express/bb410792.aspx. When I attempt to open the downloaded file, I get the message SQLEXPR_ADV.EXE is not a valid Win32 application. Attempting to extract the files using Winzip, I receive the message 'Cab is corrupt'. I have installed and run the msi.
I have just downloaded the last version of SQL 2005 EXPRESS, and then all my older applications I was using do not work.
The messages I obtain when I try to run some Visual Web Developer Application or Visual Basic 2005 Express that try to use SQL is that now "user instances are disabled. Try with sp_configuration "user instances enabled""
Can somebody explain how I can change the SQL configuration? I review it with the SQL Server Management Studio Express and it really has no users. How can I add an user?
Thanks to everybody.
Hello all,
I am new to SSIS and have a (maybe) simple question:
I use the FTP-Task to download two excel files from a FTP server. The task succeeds but only one file is downloaded instead of
two. I tried both: RemotePathVariable = false with /FTPTest/*.xls as RemotePath and RemotePathVariable = true with a variable
containing the same path. Both bring up the result described above.
Thank you in advance
Sandra
Am running ipwsitch's ws_ftp 2007 pro software on windows 2000 platform on a network. . Trying to download a 17.4mb zipped file via FTP. File comes across to my environment but is corrupt - when attempting to unzip it.
Transfer mode being used is BIN and not TXT.
Any suggestions?
Hi,
View 9 Replies View Related
Hi,
I am facing an issue, while exporting report to excel.
I have a report where some legends are being displayed on coversheet using matrix. The contents are fetched from backend.Some of legends have got too much of text while others don't have much.In matrix properties, I checked can increase/decrease to accommodate changes. When report runs in report viewer it shows correctly i.e. it adjusts its width according to contents but when same report is exported to Excel it doesn't happen so. The size of cell is not increasing dynamically, depending upon the data. User needs to expand the cell in order to view the data.
So, is there any option by which, we can implement data wrap functionality for matrix, when report is downloaded in excel format.
Your suggestion will be of great help.
Thanks & Regards,
Kiran Kirdat
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)
thank you
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??
Dear friends,
How we can insert hyperlink column in a sql table? Is there is any datatype?
graceson
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.
Thanks
abz
In between a sentence can I add hyperlink in reporting services?
Example: Microsoft reporting services is a nice tool but it needs more feature.
How can I add hyperlink to "Reporting Services".
Is it possible to put an Alt attribute on a hyperlink?
View 3 Replies View RelatedHello,
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
How do I get the URL to work?
Any help would be appreciated.
Hi,
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.
Dear all,
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.
Hope can hear from you soon. Thanks in advance.
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??
Thanks
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.
1 <asp:SqlDataSource ID="ctrlIdData" runat="server"
2 ProviderName="System.Data.OleDb"
3 ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:ectserverxxxxxxDataBaseSecurity.mdb"
4
5 SelectCommand="SELECT [TermID], [Term], [Genre], [Description], [Link]
6 FROM [Terms]" >
7 </asp:SqlDataSource>
8
9 <asp:SqlDataSource ID="ctrlDetailData" runat="server"
10 ProviderName="System.Data.OleDb"
11 ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:ectserverxxxxxxDataBaseSecurity.mdb"
12 SelectCommand="SELECT * FROM [Terms] WHERE [TermID]=@TermID" >
13
14 <SelectParameters>
15 <asp:ControlParameter ControlID="ctrlTermID" Name="TermID" />
16 </SelectParameters>
17 </asp:SqlDataSource>