Advertisement

900 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%!

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top SQL Reporting Solutions: 1 - 25 of 127
 
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 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 ...
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 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...
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 setup and installed SSRS 2000 before successfully. This time, I am having nothing but problems. After completing the install I attempt to validate the installation by browsing to the re...
I've analyzed the servers we are using for SSRS 2005 and 2008 and we discovered a small issue, though I can't seem to find what the cause is as it isn't affecting anything that we can find. In...
I am using SQL Server 2005 Reporting Services and need to format dates. I want the dates in short date format (example: 05/31/2008). I can do this by using the format property of a field and u...
I'm trying to format two date fields in Cognos 8.2 Report Studio.  The two date fields are Project Start Date and Project End Date.  The result should display in this format,  mm/yy - mm/yy.  ...
hello, can i please know, how can i export a reporting services report to a pdf file programmatically. I am using reporting services 2005 and doing my coding in C#. any help in this rega...
Hi Experts, I have a report in SSRS (SQL Server 2005) and one of the parameters is a date. My question is a two-parter: 1. Cascading parameters: How do I set the date of the date/calenda...
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!
Hi, I have a table that displays the following data: 1. 100 2. 200 3. 300 3. 0 4. 0 5. 400 How can I make an expression so that if I get a 0, i don't display anything (return a nul...
How do I call a Reporting Services 2008 report from my C# Windows app Visual Studion 2008. Should I use a ReportViewer Control or a url to the reporting services like ReportingServices 2005
How do I embed word/excel/pdf documents inside reporting services reports? (not providing links to the documents, but embed and view)... even if it requires purchasing additional product. U...
Experts, Any idea about the error i am getting after installing SQL reporting services 2005 ? The user that is trying to access the database is machinename\ASPNET. User has dbowner rights o...
When using a grid I can have it highlight every other row. How is this done with Reporting Services using a table and the data comes from a Stored Procedure?
Can some one show me how I can set report credentials programmatically using Visual C#?
How do I Format a Columns DateTime from MM/dd/YYYY HH:mm AM to dd/MM/YYYY HH:mm AM in Reporting Services 2008
I have 2 fields visible in my report. =Fields!Building.Value & =Fields!CardHolderName.Value Is there anyway I can change the color of =Fields!CardHolderName.Value based on a Field valu...
I'm trying to build a report in SSRS that runs against an OLAP cube in an Analysis Services database.  This cube has a 'Time' dimension with a year-quarter-month-day hierarchy.  Using the MDX ...
I have a situation where a user wants to subscribe to a report that takes a date range, with a start and an end date. They want to be able to have the report be able to run against a specific ...
I am trying to format PART of a string on a point label.  I don't know the syntax to bold, underline, etc to use in an expression.  In the attached code I would like to Bold or maybe use a dif...
this is driving me nuts.... I need to populate a parameter with values from a Query.  But I need to dynamically change that query based on the results of another query. As in: Administrat...
Ive attached my stored procedure which is causing this error in my SSRS report: The 'EventID' parameter is missing a value I found this to be a common error and I checked most everything. ...