I'm using a matrix report that has 3 group colums (category, productgroup, manuf) and 4 group rows (yr, qtr, mo, sales$$). Is there anyway to...
Thank you for your help once again... and reminder to use the "search" feature. Much appreciated. quote:Originally posted by eklpublic What...
What is the best way to load an image (jpg) into the database? Thanks, ekl
The solution... right click in the first field of the detail column 100 times until you get a shortcut menu that shows the Subtotal option. It's...
Hello all, My first SSRS Matrix report and I want to show both row and column $ subtotals. Online I found info that said right click the column...
I didn't find a resolution to the "Reporting Services Login" prompt and google turned up others with the same problem and no resolution. I ended...
Hi all, I have a query that joins data from multiple databases. How do I setup the datasource(s) in BI for this? I setup multiple datasource, one...
Problem solved. I applied SP2 for Reporting Services. No more prompt! Thanks.
SSRS running on XP with SQL 2005. I have been using SQL Report Manager for weeks and now it prompts for my login each time I try to access it. I'm...
Thank you for your suggestions... the problems appears two-fold -- 1) permissions had been changed on the server and 2) the sproc was unable to...
Hi all, I modified and saved a stored procedure via EM. When I execute it from QA, it runs but without the changes, i.e. the old sproc. I...
How does SQL Server 2000 manage a situation where the "Next Run Time" overlaps the currently running job? Does it queue them up? Last night, I...
Hi all, We suspect that our production system may have been updated from outside the application -- ie. by a query. The same permissions applying...
Hi all. Does a trigger rollback if the query that caused it to trigger is cancelled? That may be a little vague so here is some additional detail:...
When I choose the import/export option on a table in Enterprise manager, the DTS Import/Export Wizard automatically fills in the option for Use SQL...
Hi, currently we set the database user permission on the objects in the database by going into Enterprise Manager -> database -> users and then for...
Hi and thanks for your suggestions. The path is in the Job that is a Planned Maintenance job... when you drill down into the step Execute...
<br />Hi, <br /><br />we lost one of our servers and a number of sql jobs include the path to that server \oldserver. Is there a global way to...
A Job step calls a package DTSRUN /~Z0x5D.....(long number) How can I find out the name of the Local package that's being run (i.e. interpret the...
Hi all, I get an error when I try to create a Schedule to Export data to an xls file. The error says ServerProperty is not a registered function...
Separate names with a comma.
