Hello Experts,
I have a report deployed on SQL Reporting Server which uses a date parameter.
The date format on the server is "9/1/2008".
My question is how to change date format to "...
Somebody help! I just purchased a new notebook running Windows Vista Home Premium edition. I've been trying to install MSSQL Server 2005 on my machine, but i get an error message saying "Micro...
Hello all, I've spent hours troubleshooting this and I need some fresh perspective . . .
We have a relatively simple report setup in SSRS, simple matrix with columns across the top and data...
Im having a tough time refreshing the drop down values of my Reporting Services parameter box;
I think the problem is more on the type of join in the sql rather than the reporting services ID...
Hello -
I have a request to modify a table report by using alternate colors similar to Excel - for example blue in one row, light blue in the next, blue, light blue, etc.
Since only one...
I am using SQL Reporting Services in SQL 2005. I have a textbox on an Order Acknowledgement report that is formatted as blue and was static text saying Order Acknowledgement. I have changed ...
Having a problem with SQL reporting services. We have two systems. One of them is Windows 2003 with SQL reporting services 2005. We have another system with Windows 2008 and SQL reporting s...
Is there are way in Reporting Services to setup Parameters that control other parameters? I wish to setup the following:
Parameter1 (Interger) - "Select Report Type"
- <Label> = <Value>
...
I have a very strange report which this report has an extra page showing up with Header and Footer and nothing on the body when I export into PDF.
I give you the background:
1. I am develo...
I am trying to use a multi-valued list of sales reps as a parameter using report designer. If I select the multivalue checkbox it seems as though I can only use the Non-Queried option. If I ...
I have a Reporting Services project with an SSIS data source. When I try to preview, or execute the dataset within BIDS, I receive the message 'The specified data flow component was not found...
I work for a small billing office and have very limited knowledge of sql. We don't have the resources for extensive IT training, Our DB is MS SQL. The problem is that creating pivot table r...
Simple questions here...
I would like to have my document map navigation to default to expanded. I can't seem to figure out where I can set this. See attached screenshot.
I am trying the following SQL Statement:
select LUC_AGENT_STATS.PROJECT_CODE, LUC_AGENT_STATS.ROW_DATETIME, LUC_AGENT_STATS.ACD, LUC_AGENT_STATS.SPLIT, sum(LUC_AGENT_STATS.ACD_CALLS),
Case...
I am using a Reporting Services report but I cannot figure out how to change the date format to print mm/dd/yyyy Right now the date prints as mm/dd/yyyy hh:mm:ss AM
Hi Guys,
I am stuck with a Page break problem in grouping(SSRS 2005). Here is my problem:
Here is the sample data.....I am grouping on location(NJ,NY,TX)....The problem is when I am viewin...
I have a report that contains an image control. If I hard-code the reference to a .jpg file the report previews from my windows application correctly. The image is displayed (so I know it's ...
I have a table on a report in SSRS and I need to format a field in a cell;
I have Eventnames and Rooms;
In my sql query on the back end (ms sql server), I select both fields as such:
ISNU...
Dear experts,
I have been creating reports using reporting services 2005 in vb.net (.rdlc files) and I would like to be able to save these files as PDFs - When I look at the save option in my...
Hi -
I am trying to sort a report by fiscal month desc. Since our fiscal year begins in July and ends in June, the latest month for a year would be June sorted through July:
June
May
A...
Original Thread: http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/3b9b7c8c-b94d-4040-b1df-0325658660b0/
Problem:
Ok, so I added Roles and content manager for my domain accou...
I have a problem with the parameters for my report.
I am using three stored procedures as my datasets in SQL ;
Attached is a screen shot of my parameter screen but, basically it accept a sta...
Hello Experts,
I have a report in SSRS that im trying to setup as a subscription If i put my email address in the TO fields
then at the time of subscription im getting an error like "The ...
While in the formula editor I take my field and write this formula
time / 60
Anynumber greater than 60 gives me the number I want, but not formatted the way I want. anything 60 or less re...
Is there a way to pass a blank value to a datetime parameter?
I know that null value would work just fine for me, but my user does not like the NULL checkbox by the field...
Thanks!
