Search results for query: *

I have a simple login screen that now has to receive its parameters from another web site. I am not sure what we have to do. The other web site, will get the user id and password. the person there is asking me, does he just redirect user to...

HI I created a database a while back but don't recall much about how i did this. It is a small database holding the users names and reports they can get. Now I have a program that is trying to read this database and get the reports to present in a combo box. But it's not displaying the data. I...

asp:HyperLink ID="HyperLink2" runat="server" ForeColor="Blue" style="text-decoration: underline" NavigateUrl="SpendAnalyzer/Default.aspx">CARETRAK</asp:HyperLink> The following code displays a tab for the user to click on, and then runs their app. The way it is coded, the three tabs have...

I have been charged with changing an existing dashboard report i did in SSRS to using Silverlight, and 'flashing' it up. Silverlight cannot do direct queries on sql server. it cannot connect directly to the sql server like in asp.net for instance. A web service needs to have a database...

I have the following SQL as a Stored procedure that returns the sales per category group by date selected. I would like to be able to add the budget data to this and create a result that would indicated how much over or under budget the item is for a certain month, by amount and if possible by...

I have a problem that I had written several SSRS reports using the trial edition of Visual Studio, the Professional ed. Now we purchased the Standard edition. What is happening is when I try to call up the reports, there is an error message that I cannot use .RPTPROJ objects with the VS I have...

I have some reports that show Census, Billing, PPD and Quotes. But for one customer they have only unposted invoices. I am using tables SOP10100, SOP10200. SOP30200. SOP30300. I can't figure out where to get this data.

HI This may be the wrong forum but is related to my SSRS. I had the trial edition of VS 2008 professional and wrote many SSRS reports using this. THen we bought the Standard edition which I installed. When I try to open the SSRS reports, there is a message that .RPTPROJ type is not supported...

HI I have some reports that we want to use with someone else's database, a marketing company. They have set up a view and connection for me. BUt where do I specifiy this? I have been given a user name and password and their iP address. I am not sure where to specify this info. In the Source...

HI I have a report that contains several rdl's. one of which I have put a heading text to explain a bit what is being shown, call this rdl section3a. It is contained in Report1. Section3a is the subreport. When I run section3 by itself, this text box displays. However, when the entire solution...

HI I have written a Report in SSRS 2008, and have deployed using Reportviewer and ASP.net. When you run the report in the ASP.net, one little problem is that, the data is a grouping of product types, and you can click on the + sign, and then it provides details of what makes up the summary data...

HI I have to take 2 Expression fields I made and combine them into one. It is simply 2 dates that are column headings, from and to dates. The from date is this: =DateAdd("m",-4,DateAdd("d",1,Parameters!ENDDATE.Value)) and then the "to" date is this...

I have written some Reports in SSRS and want to make the site accessable on the internet. There is a interface that does a User id check as well as displays parameters. Now the issue is, what do I need to do to take it from local. I was a given a link by the network consultant to use but this...

I am looking at an Excel spreadsheet that I have to web enable - but I don't see any source or codes. How does this spreadsheet get the data etc. Where do I find this out?

I have a chart that shows the budget and expense amounts. I have the color yellow for budget and red or green for expense, depending on if it is over the budget amount or not, (green is good,etc). Is there a way to have the color softer and more gradient from green to yellow to red as the...

I am using the pie chart in Reporting services. It gives a prefixed legend that is hard to read. They are to the right of the pie. The user would like to see this legend more underneath the pie as a table. Any ideas on how to do this without custom coding?

HI I have a login page, and was thinking to keep a log of visitors, or the time they came in. Should this be done here in this code? I would need a table as well. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="RReports.Login" %> <!DOCTYPE html PUBLIC...

HI I have this SQL statement as a stored procedure, that is used in a SSRS report to show which items have gone over budget (the top 5) for a customer. I need now to add a variance column, to show the difference between the amount over budget and the budget amount. USE [SUDatabase] GO /******...

I have to modify this SQL. I need it to total for an entire year the BudgetAmount. Currently it is only totaling for June. I also need the entire expenses for the year. @CUSTNMBR VARCHAR(50), @CURRDATE DATETIME AS CREATE TABLE #TEMP (CUSTNMBR VARCHAR(50), BUDGET_MONTH INT, BUDGET_YEAR INT...

I have this chart, the data is fine but I was told by the user that it is not 'neat'. This is due to a lot of data on the Axis. I take the Budgeted amount and compare with the expenses. But there figures are very close together and some of them are quite small. I am not sure how to improve this.