Date Driven Orientation Problem
Feb 11, 2008
Hello,
I have a table with data laid out as follows:
Acct JanRev FebRev MarRev AprRev
BR549 150 125 175 180
I need to express the (x)Rev columns in a single Revenue column. Nornally, I would do this with CASE, but the column has to follow the current month of the year minus one month DATEADD(MONTH,-1,GETDATE())) and be cumulative.
For example, if the current month is March then:
Acct Revenue
BR549 150
BR549 125
If the current month is April then:
Acct Revenue
BR549 150
BR549 125
BR594 175
Any ideas on this?
Thank you for your help!
cdun2
View 3 Replies
ADVERTISEMENT
May 2, 2008
Hello to a new forum. I am very impressed with the level of ability I have been seeing on this forum and all the helpful posts that are going on.
I am hoping someone can help me solve my problem. I know enough SQL to be very dangerous how to create, delete, insert, update etc... and how to build queries. Here is my dilemma I need to have a piece of scheduling software send out reminder emails based on a DATETIME field. I am running SQL Server 2005, and the database mail is already configured and can successfully send out email from the management studio interface.
Does anyone know of a tutorial or can point me in the right direction to accomplish this task. I am well versed in PHP, and am hoping I might be able to get the server to trigger a PHP script or something to this extent.
View 1 Replies
View Related
May 22, 2008
Hi All,
I'm new to SQL Reporting service. some how i tryed to manage and create reports. I have a small question. when i start creating report i wanted to change the orientation of report from Potrait to Landscape so i can get a bit more space. i can see report getting expanded as we keep working. but when i tryed to export to Acrobat PDF, the content getting into next page insteed in same page. to over come this issue i wanted to generate report with landscape orientation, i have seen this kind of option in Crystal report, but i dont know how to make the same in this report.
View 1 Replies
View Related
Jun 1, 2007
Design a report by setting the layout with:
width = 8.5 in
height = 3 in
By default, the page orientation will set to "landscape"
Is there anyway to code it and make the page orientation to "potrait"?
thanks for the reply.
View 1 Replies
View Related
May 29, 2006
Hi,
I want to setup my report in landscape format.
How do I do it?
I have altered the report margin in report properties.
However if we export the report to PDF €“ still goes to portrait format.
Even though in pdf itself I have changed the print setup to landscape, but it doesn€™t change anything.
Can anyone give suggestion?
Thanks,
Susan
View 6 Replies
View Related
Feb 5, 2008
Hello,
I have a need to present a different orientation of data, and I would normally do this with CASE. I've tried to go that route in this instance, but it hasn't worked.
The following query expresses the data as it currently is:
SELECT TOP 10
Prod,
Acct,
TC,
SubmitRep1,
SubmitRep2,
SubmitRep3,
Percent1,
Percent2,
Percent3
FROM
dbo.tbl_CYProcessedSales
WHERE
Proj IN (100,200)
AND Percent1 < 80
AND NOT SubmitRep3 = ''
AND Prod = 'RETA'
The result looks like this:
Prod Acct TC SubmitRep1 SubmitRep2 SubmitRep3 Percent1 Percent2 Percent3
RETA PA0065 T2 OJOYNER CAPARRSH SBEVERLY 34 33 33
I need for the result to come out like this:
Prod Acct TC Rep Percentage
RETA PA0065 T2 OJOYNER 34
RETA PA0065 T2 CAPARRSH 33
RETA PA0065 T2 SBERVERLY 33
Do I want to use CASE here, or a cross join?
Thank you for your help!
cdun2
View 7 Replies
View Related
Jan 28, 2007
How can I set the page orientation to landscape? I tried to set "printDocument.DefaultPageSettings.Landscape = true;" but it didn't work. I have spent hours fixing the problem but I couldn't get it work. Below is the code:
private void printDocument_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
e.HasMorePages = false;
printDocument.DefaultPageSettings.Landscape = true;
System.Drawing.Font printFont = new System.Drawing.Font("Arial",
12, System.Drawing.FontStyle.Regular);
e.Graphics.DrawString("Set the page orientation to landscape!", printFont,
System.Drawing.Brushes.Black, 30, 30, new StringFormat());
}
Could someone please tell me what is wrong with it, or what I should do to get it work? Your help is very much appreciated.
Thannks.
View 6 Replies
View Related
Jul 9, 2007
Tweaking a report that was imported from Crystal Reports. Report has three pages, the first two are landscape, the last page is portrait.
Can this be done in RS or will I have to split up the report to render the 1st two pages separately from the last page (in two reports)?
Thanks in advance.
My two cents worth: It would really really be nice if RS had 1.) a rich text box and 2.) the ability to rotate labels and text boxes.
View 3 Replies
View Related
Aug 16, 2007
Hello.
I have a report but by default it prints Portrait and 1.0inch Margin. I would like to programmatically set the values of my report to 0.2 inch margin and Landscape. I am using RDLC (Local Report).
Does anyone has an idea how to achieve this?
Jose
View 4 Replies
View Related
Apr 11, 2007
How to execute a sp with respect to time ( For ex, sp should be executed at 12 AM everyday irrespective of system shut downs and log offs)
View 11 Replies
View Related
Sep 22, 2000
Hi,
Can anybody help me with this? I have tried this and got confused big time.
Can you point me in the right direction please?
TIA.
Barath
View 2 Replies
View Related
Apr 19, 2000
Hello;
I need to create a data driven query task where the destination is a view. The option to select a view is only available for the source.
I have created a view because the first attempts to create a data driven query againt the required table (db is over 4000 tables, 4 GB of data)resulted in workstation lockups.
Thank you.
Barb
View 1 Replies
View Related
Jan 19, 2007
I have a question has anyone seen a Webbased Database made with Frontpage 2003 before???
View 2 Replies
View Related
Mar 1, 2004
Has anyone explored a process whereby the Transaction Log would be backup up based upon a defined threshold, ie. 75% full? All the research against news group posts and SQL2000 literature seems to point to scheduling a log backup job on a periodic basis. My workflow isn't 24 hour consistant and even adjusting the interval during the day isn't a good answer when the multiple databases on a server fill their logs at different rates.
View 8 Replies
View Related
Jun 13, 2007
I have vb code that I am triggering a Data Driven Subscription.
The problem I am having is that I need to wait for the Subscription to finish before I go on to the next line of Code.
I am Currently using SQL to query the Subscriptions table in the ReportServer Database. I am Checking the LastStatus field to see if the Subscription is done. But I've noticed that it doesn't always update the field when the Subscription is finished.
for example some times that field will stay "Pending". Is there another way that i trap for the subscription being complete?
View 1 Replies
View Related
Sep 23, 2007
Hello there,
How/Where can i check the error i get when i send report by email.
cheers
zolf
View 4 Replies
View Related
Mar 28, 2008
Hi all,
I've a query which i need to run as Parameter Driven, where SQL asks me for an input let's say for a Date in a query. is this possible in SQL SERVER like in Oracle, if so can anybody suggest me where do i look at.
here's my quer.
SELECT * FROM TABLE
WHERE DATE > '1/01/2008'
instead of 1/01/2008 Sql Prompts me to enter my own Date and display the result.
pls.help..me and thanks in advance.
View 2 Replies
View Related
Jul 20, 2005
Has anyone explored a process whereby the Transaction Log would bebackup up based upon a defined threshold, ie. 75% full? All theresearch against news group posts and SQL2000 literature seems topoint to scheduling a log backup job on a periodic basis. My workflowisn't 24 hour consistant and even adjusting the interval during theday isn't a good answer when the multiple databases on a server filltheir logs at different rates.
View 1 Replies
View Related
Dec 21, 2006
I have create a data driven subscription that should email to to different people. It is sent to one but not the other. if I set up a normal subscription to the email it works. I can not see anywhere in the log the problem. Any Ideas on how to find out what is causing it.
View 8 Replies
View Related
Dec 29, 2006
I am using vb .net 2003 with msde.
I have downloaded microsoft`s vbsdk setup and have it working pretty well until I get to the login page and the provided credentials will not work.
The sample tells me to set permissions in the dacl editor.
1:What is the dacl editor and how do I use it?
2:What do I set permissions to?
I have been through the code provided over and over and can`t seem to find anything wrong,So I figure maybe this is the problem.
Any help will be appreciated.
Davco
View 1 Replies
View Related
Jan 8, 2007
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
View 12 Replies
View Related
Feb 22, 2007
Is it possible to copy an existing Data Driven Subscriptions and make some minor changes?
Elias
View 1 Replies
View Related
Jan 8, 2007
I am using Reporting Services 2005 locally for testing purposes and also on a production server. Locally, I can create data-driven subscriptions, but not on the server. The only difference I can think of between my local test environment and the production server is the versions of SQL server database. Locally, I am using SQL server 2005 but on the server I am using SQL server 2000 (but with Reporting Services 2005). Can the version difference be the reason for not being able to use data-driven subscriptions?
Note: I have followed various guidelines and walkthroughs that describe how a data-driven subscription is created, i.e. stored credentials on the report server and such should not be the problem.
Operating systems: locally; Windows XP. Server; Windows Server 2003.
Thanks!
/Stefan
View 8 Replies
View Related
May 15, 2008
Hi
I created a new data-driven subscription which successfully created a guid job on the server under jobs. So, I run the job and I get no report emailed to me. On the report manager all it says is I have 1 error. I cant figure out what the error is and where do I go to see what the error is? I know it is in some log file under MSSQL, but I dont know which log file and what I should be looking for in that log file. Any help is appreciated.
I guess, in summary, how do I debug a data-driven subscription?
View 1 Replies
View Related
Jun 13, 2007
I'm very new at this and found this video very helpful. I downloaded Visual Web Developer 2005 Express Edition and following the direction except for changing a few column names. When I get to the point of viewing in browser I get the drop down box but nothing in it and the table doesn't show up either. I copied all the data to my website and tried to view it there but got some error that I don't understand. Can someone please help. The website I uploaded the files to is ocbeachrentals.net/default.aspx. Thanks.
View 1 Replies
View Related
Dec 19, 2003
I was wondering what everyones preferred way to install a database in an automated fashion is.. IE:
You have a webapp. It sdriven by SQL Server. You need to prompt the user for a server, username, password, and database. Once you have those, you execute thge scripts against the DB.
I've been using osql.exe. but heres the situation. The installer may be run from a system, which does not have the sql server client tools installed. Which will be a problem.
So, given the situation that the machine the application is being installed on, does not have the client tools installed. How would YOU execute the provided SQL script against a remote server.
View 4 Replies
View Related
Aug 3, 2000
I'm trying to perform a simple DTS tassk and am having no luck. All I'm trying to do is to run a task that will delete rows from an Access table. I presume I have to create a Data Driven Query in order to do this, but I can't seem to get the formula just right.
Can someone shed some light on the subject, please? BOL says little to nothing about how to set up a simple task. Microsoft.com is also pretty lsackluster with regards on what to do.
Again, thanks for any help.
Anthony Robinson
View 4 Replies
View Related
Jul 1, 1999
I would like to use a Data Driven Query Task to conditionally update/insert some data from a source table into a dest. table, but I can't find any decent doc or examples on this. Is there any place that explains in gory detail how to use these DTS tasks?
Thanks,
Patrick
View 1 Replies
View Related
Apr 23, 2008
I'm trying to create a simple attendance website where a user logs in and a time and user name (with unique ID) is stored into a table, and then the user is able to click "Check Attendance" and the site will display only the times they logged in (which wasn't too bad). I want a button we can click to "clean up the database" and delete duplicate dates.
If I have a user sign in 10 times in one day - I don't need all 10 times logged into the database, only one. So how do I create a query (needs to be a query so I can tack it onto a button in PHP) that will delete 'where date = the same as a previous date'?
I appreciate the help - and I'm sure I will use this forum for help in the future as it seems very robust with information.
View 5 Replies
View Related
Mar 27, 2004
I use a data driven query task to perform row updates along with appending row data to a text file. In the source I use 'select top 1000 field1, ..., fieldn from table'. The package hangs when executing the data driven task. If I reduce the return count to 'select top 100...' the package execute with no problems. I can do that 10 times, with no problems. But anything more then 100 will hang the package at that task. Please help!
Thanks,
Monique
View 1 Replies
View Related
Jul 23, 2005
I'm working with a DB design that seems to me to be rather complex.This is a very slimmed down version of what I'm doing, but I believe itis enough to get my question resolved.Here is my layout.These 4 tables are used to generate a questionaire.Survey OrderID========= ==========SurveyID OrderIDOrderID QuestionGrpIDQGrp Questions============= =============QuestionGrpID QuestionIDQuestionID QuestionTextThe following two tables are used to calculate a report that is sent tothe customer.RawData=========================OrderIDQuestionIDValue is string but is Cast as decimal for numeric formulasMetrics==============================================QuestionGroupID | ReportText | Formula | MetID==============================================2 | % Support Staff of Total | OP21/(OP21+OP22+OP23) | 1The OP references are questionIDsNow to calculate the result for the report we programatically parse theformula creating a temp table (table name = Temp & orderID & _ &QuestionID) with OrderID and OPxx as the field names. We create onetable for each question.We then use dynamic SQL again to calculate the result using the aboveformulaSELECT OP21/(OP21+OP22+OP23) FROM Temp5_21, Temp5_22, Temp5_23 WHERETemp5_21.OrderID = Temp5_22.orderID AND Temp5_22.OrderID =Temp5_23.OrderIDThis select is used to create a single table of calculated values.This table is in turn used to tell the customer how they compare toother customers. Percentile, Mean, Median, Std Dev, and a few others. Idon't claim this part of the project, but I'm not sure how I might havedone it, had it been assigned to me.MY PROBLEM!!!Sometimes a 0 is valid data and is the denominator of a devisioncalculation. Since this is so dynamic and it might be difficult todetermine when division is used. I need a way to default divide by 0execptions to NULL. This DB is on a hosted server.Thanks for bearing with me,Greg Kelley
View 2 Replies
View Related
Jun 21, 2006
Hi,
We have 8 SSIS jobs which need to be made dependent on the arrival of a single file.
All the flows need to be triggered based on the presence of a file
Whats the way to do this
Thanks
Manish
View 1 Replies
View Related
May 30, 2007
I created a data-driven subscription for my report with "Null Delivery Provider" set in report manager. I set the processing to "On a schedule created for this subscription" and scheduled the report to "run once" in the next 1 minute so I could test it. The subscription added successfully, but I don't see the "last run information" even after 5 minutes. Am I missing something?
Thanks in advance!!!
View 1 Replies
View Related