I need to create an invoice report, each page represents a single invoice. like a form report.
Which control is good, i am new to reports. i have used table control for few of our reports still learning.
Thank you very much for your help.
What are the options to create a table of contents based on the report items in a List Control? Document Mapping works for online viewing. A table of content would make the report easier to read when it's printed.
Any help is much appreciated. Thanks.
Hi, can anyone teach me how to automatic create a invoice number and insert or update it to a column?
View 2 Replies View RelatedCan anyone advise if it's viable to send order invoice reports to customers with SQL Reports.
I have a well formatted report that accepts an order number and generates an email to the customers address but i'm struggling on how to batch send this. Each order record has the email address to send to.
In our orders table I have a 'sent' flag so can easily write a query to bring back all orders that need sending. I just can't work out how to automate running the report for each order. Then after the report has been run for that order it needs to update the 'sent' flag.
Possibly this can work with a SSIS package that does the initial selection and updating of the flag but i can see how to run a report server report from an SSIS package.
Any ideas appreciated.
I have a db to manage the creation of invoice number designed for a web application.
My problem is how to manage the concurrency when the users need to create an invoice number.
Hi all - struggling a bit with this one... I have made an accounts application and need to make a report called "Aged Debtors". It lists all of the clients with outstanding invoices and breaks them down into periods:
current (this month)
period 1 (last month)
period 2 (2 months ago)
period 4 (invoices raised 3 months ago or more)
My tables are as follows (simplified)
Clients
clientid int
clientname varchar(100)
invoices
invoiceid int
clientid int
invoicedate datetime
cinvoiceamount decimal(19,2)
paid int (1 = paid, 0 = unpaid)
paidamount decimal(19,2) (how much of this invoice has been paid)
I need the following columns in the report
clientname invoiceid current period1 period2 period3+
test client 1 £100 - - -
2 £50 - - -
3 - £100 - -
test client2
I can format all the report using a matrix in SSRS so just need the stored proc to get me going - any help greatly appreciated!
Thanks guys,
Stephen.
Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
With Thanks
M.Mahendra
does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.
View 1 Replies View RelatedWrite a CREATE VIEW statement that defines a view named Invoice Basic that returns three columns: VendorName, InvoiceNumber, and InvoiceTotal. Then, write a SELECT statement that returns all of the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.
This is what I have so far,
CREATE VIEW InvoiceBasic AS
SELECT VendorName, InvoiceNumber, InvoiceTotal
From Vendors JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID
[code]...
Hi,
I want to give filtering criteria in my SSRS report.
I have drop down list control having list of Email's of clients.
So, how can i pass the value of the particular Email id in my SSRS report using Report Viewer control?
How can i pass user input as parameter in my report using visula studio 2005?
Thanx,
Ruja
Do I need the report server running in order view a SSRS report in a report viewer control? I've created my report in .net and it works great when I'm viewing it in visual studio, but can I run it my web app without the report server.
View 1 Replies View RelatedI'm new to sql and have come up with a problem and can't seem to find the answer. Most would probably find it simple but I cant get my head around it! :p
I have the following table structure
User_Table-----------User_ID (Key)FirstNameLastName
Contacts_Table--------------User_ID (F key)Contact_User_ID
User_Table stores all users details and assigns them a User_ID. Users can add other users to their contacts, and this will be stored in Contacts_Table on a one-to-many basis.
*deep breath*... So User_ID in Contacts_Table, will store the User_ID from User_Table, and the Contact_User_ID in Contacts_Table will store the User_ID from User_Table. Does this seem ok? Sorry if I confused everyone!
So my question is, how do I select a user and show all his contacts (names etc)? I thought I could use innerjoin but I dont think it would work here.
Any ideas?
Thanks!
Hi:
AS a newly Master degree graduate student in IT field. My M.S. degree training has been emphasized in database developer, Web developer, Web/database developer, network, and network and computer security.
My personal interesting are database and web. have experienceon java servlet and database(create a web site), try ASP and dataabase now, but I don't have any work experience(come from other country and change major)
hope can get advice from kindness prople what is suitable to learn DBA or oracle ? conside about difficult level, cost, and suite for future job market
Thank you
Hi,
I am trying to dump-load a db from one server to another.I don't have any
problem with the dump and load , the problem is with scheduling the copying of
the dump file fron server1 to server2.
I tried using xp_cmdshell 'copy filename filename ' to schedule it but it
says "access denied" zero files copied...(using sa account and standard
security)
But when I telnet to server1 and issue copy filename filename it works fine.
how can I correct this problem and schedule the dump-copy-load??????
In the near future I need to move a 27GB database from SQL2000 to SQL 2005 that is located in a different data center. I can do a backup, copy the .bak file over the WAN and do a restore, but that will take several hours over the WAN. I think the new server will be standalone, not a cluster. We have not purchased it as yet.
What options do I have to minimize downtime? I don't think I can log ship between SQL versions, but I might be able to run two instances of SQL on the new server (2000 and 2005), although I consider that an iffy proposition as well. The OS would be Win2003 sp2 on the new server. What other options do I have? Would mirroring work between versions? Thanks for any suggestions.
Hi,
I am given with the responsibility to set up database replication in my organisation.
Before starting the replication set up, I would like to know which is the best suited replication for my application.
My application is much process oriented, and the users are working on records parallely(but with different records).
Say for ex:
There is a module for Insurance claim processing, it is handled in the following manner:
There are many employees with CSR roles, and all are working on some set of records to be processed. But No two employees should get the same record for processing. For that, we are doing locking of the cases by having one column called 'LOCKED_STATUS' and setting value as LOCKED. So that other users wont get the same case. Once the case is processed, the record is marked as unlocked.
My analysis for replication is as follows:
1. Snapshot replication: This wont be a suitable type of replication as the updations are to be immediately updated on all the subscribers, because when the user executes select query to get the next unlocked case, No 2 user should be able to get the same case.
I think, the best replication to chose from is, Transactional replication with Immediate Updation/Queued updation. But the problem is, when one of the subscriber goes offline, the updations are queued up. But in my case, say for ex. One case is updated as locked, but the subscriber is offline and the updations are queued up. At the same time, the other subscriber can fire an select query to get the next unlocked case. Since the update is on queue, there are possibilies for this subscriber to get
the same case.
Can anyone let me know, are the select statements also queued up(i.e., along with update and insert statements.)? If not please let me know how to approach for this problem.
Thanks in advance.
Prashant N M
We have developed several reports using VS 2005 and deployed them to our SQL 2005 reporting server. As most of our reports use date parameters we would like to incorporate a calendar control to allow users to select their date range as opposed to typing them in. I have done some reseach online but can only find vague references on how to do this. Has anyone out there been able to successfully deploy a calendar control onto an SQL report? Thanks!
View 2 Replies View RelatedI have a need to create a report that contains a calander, i.e. last month in rows and columns . Any idea on how to accomplish this need?
View 9 Replies View RelatedI have a matrix report NESTED inside a "List" control. I want to put a reference in the text box in the matrix report to a dataset field in the List control. How? Thanks.
View 1 Replies View RelatedHow do I write a query (using a union) suitable for paging
I currently have a query which results from two queries combined by a union. It returns 3000 rows. I want to replace that query with one which returns only 50 rows from the relevant page [using ROW_NUMBER()].
Is there a way to do this with only 1 CTE or will I need to use two consecutive CTEs [the first get a union on the queries and the second to apply ROW_NUMBER()]. I can't see a way of doing it with only 1 CTE table.
Alternatively is there a very efficient way to do it using derived tables?
I have huge table, often I need to query the table on the whole; ie., data may required at any part of the table. So I think of to compress the table with the aim of reducing I/O.
1. is that really suitable for this requirement? If So which compression is good (Row or page )?
2. Or is there any other alternate to reduce the I/O (Except Indexing)?
3. Pros and cons ?
Hi all. Looking for information on whether or not the control/navigation bar that appears at the top of the report view can be changed. I am specifically looking to remove it and assign its controls to other .net or html controls/objects. For example, the control bar has the arrow for viewing the next page. Instead of that, perhaps I might like to have a hyperlink etc somewhere else on the page that performs the same functionality. I have searched and searched for information on this but haven't been having much luck. It's kind of a difficult thing to search for due to ambiguous key words "control bar" "navigation" etc.
Not looking for specific info as to how to go about doing it, more like: what is possible and where can I go to find the specifics.
Thanks so much in advance,
Jeff
I'm working on a project where the client wants us to create custom charts which have features not found in the standard Reporting Services charts. I would like to use flash to build this and have found an existing flash charting package for which I have the code and which I plan to expand.
Here's the problem:
The client wants to include these charts in his Reports. Is there some way to add a flash control to a report so that it will appear on the web page as a fully-functional flash presentation, which can then be included when printing or exporting?
The alternative, would be to figure out some means of generating the chart using flash outside of the report, exporting a bitmap of the chart and then saving the bitmap to a known location on the file system so It can be referenced by a report. This has some serious complications, and may not be feasible.
Any ideas?
Hi,
Is there an ActiveX control for the Report Designer available so I can just drop it into my program so the user can edit or add reports without buying the Business Intelligence Studio or Visual Studio 2005? I understand I'll have to pay royalties on this but depending on the cost I am open to it.
Thanks
I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?
Thanks
Krishna
Hi All,
I have not heard any news on this topic elsewhere so thought I would ask here....
I would like to gain control over parameters in terms of:
1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example.
2. Access to the parameter text via a custom assembly to support multi-langauge reports.
I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now?
Thanks
Hello,
I'm using Report Viewer Control and everything works fine. But my problem is I have the same report shown two ways, handout/grid . Handout has less columns and grid has way more.
Now how can I accomplish this task ? I was thinking maybe have two subreports within the one main and hide/unhide accordingly based on user selection of handout or grid.
The problem is all my attempts are unsuccessful.
I will really appreciate if someone can help me on this.
Thanks a lot.
Harsimrat
Hello everyone,
I have a report that has a "Jump to report:" link in it and in the report it jumps to there is another "Jump to report:" link. When I click on this link I get the following error.
The path of the item '(null)' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
I have tried moving the link from the header to the body of the report with the same results.
This is only happening in the web reportviewer control as our windows app works flawlessly.
We are running SQL SERVER 2005 SP2.
Does anyone have a fix, workaround or idea how to resolve this issue?
Thanks in advance
-JW
Hi,
Im using report viewer control in my VS2005 application.
Im exporting reports using the Export Functionality of report viewer control.
I need to gv specific name to the excel sheet (other then the default name).
Pl. help!!!
Regards,
Divya
I run my reports in local mode and do something like this :
Code Snippet
//Local Processing mode for Reports
reportViewer.ProcessingMode = ProcessingMode.Local;
// Set RDL file based on handout/grid selected
if (gridRadioButton.Checked)
{
reportViewer.LocalReport.ReportPath = "Grid.rdlc";
}
else
{
//Handout
reportViewer.LocalReport.ReportPath = "Handout.rdlc";
}
//Refresh the report in order to show it to the user.
reportViewer.RefreshReport();
The problem is that both handout and grid is diiferent, Say User Selects the grid once it always shows the grid report. Even second time you change to handout still it shows the same Grid format and I debugged it and it picks the new report path but doesn't help? The application needs to be rerun to fix it.
Can anyone explain what is causing this and how to get rid of it.
Thanks,
Harsimrat
Good Day:
I am running an ASP.NET 2.0 Reportviewer Control with VS2005 Created reports and SQL server 2005 on my website. Users are complaining that it takes a long time for the control to load and the reports to show on their browser. I tried it and it takes longer the first time the control loads. If the user keeps generating reports, the speed problem goes away but it comes back it seems after the Cache has expired? Any ideas on what to do so the ReportViewer Control loads faster? Can I pre-load it on users machines?
thanks,
Omar Soto
Hi,
I have asp,net application running on my machine.. it has report viewer control on it... But when i run the report it takes some time to generate. The report i create has around 6 pages and if i move to the next page in the report viewer i can an error that say ASP.net session is expired.. how can i fix it..
any help will be appreciated..
Regards,
Karen
Hi Guys!
I want to buy a laptop, so that I can install and play with the trial SS 2005 Enterprise Edition and hopefully get familiar with SSIS. At work I have only used SS 2000. I want a laptop which will run this with a reasonable speed, but don't want to pay for more juice than is actually required. Does anyone have any advice on what kind of spec would be good enough for SS 2005 Enterprise? If I go for the basics suggested by the system requirements, will it run like a tortoise?
Thanks!!
Clare