Description:
Microsoft SQL Server newsgroup.
|
|
|
Dynamic sql problem with reporting services
|
| |
Hi all, I've got a report linked to a stored procedure which is a dynamic sql union query (apologies if this is the wrong terminology I'm new to this!). The union query joins 3 tables and has selection criteria added depending on the parameters selected by the user. I've simplified the stored procedure to show you how it looks here:... more »
|
|
|
Help requested in formulating Functions and script to create a mat
|
| |
Visual Studio.net 2003, SQL Server Report Designer, SQL Query Analyser. I have a table of milestones with data such as project, miletone name, baseline date, planned date and actual date. My task is to produce a chart that has months in the columns and for each month a set of blocks of data, made by concatenating fileds form the table, for milestones due in that... more »
|
|
|
SSRS - Printing on Fot Matrix, Portrait
|
| |
Hi, We are trying to print an SSRS report in Portrait to a Dot Matrix printer which has American Fan Fold paper, my issue is as follows:- SSRS seems to work out if a report should be printed in portrait or landscape by the page height vs width. e.g If the page width is less than page height, SSRS assumes Portrait.... more »
|
|
|
65000 Row Limitation from Access to Excel
|
| |
This question has been asked a couple times, but the answer seems to be unclear so I will ask again. I have query results in Access that I would like to work with in Excel - I like Excel pivot tables better than Access pivot tables. If I highlight the 287K line Access table, right click on copy, then paste into the 1 million plus row spreadsheet capacity in Excel, it only pastes 65,000 lines. Exports from Access to the million row plus spreadsheet work similarly only exporting 65,000 lines of the much larger table. I can successfully export the data from Access to a text file, then import the text file to Excel and retain all 287K lines, but it would seem the two (Access and Excel) should be able to play together a little more nicely. It is as if Access does not recognize Excels upgraded abilities.... more »
|
|
|
SQL ID last login report
|
| |
Is it possible to run a script in SQL 2000 and 2005 to generate a report with the SQL IDs and the last time they were accessed? We need this information for an audit so we can determine which accounts can be disabled.
|
|
|
Passing parameters to a report URL
|
| |
I'm sending parameters to a report via URL but the report does not accept the parameters and still shows the parameter prompt. I want to bypass the parameter prompt and have the report automated. How do I accomplish this?
|
|
|
Can we use ReportServerCredentials without passing domain name
|
| |
Hi, I am using ReportingService2005 web service through my asp.net application. It is running fine at my machine but when using this web service through remote server it is giving error "An error has occurred during report processing. The data source 'Live_DB_VAR' cannot be found. ". However, I am... more »
|
|
|
error message is sql reporting service 2005
|
| |
I am new to sql reporting service 2005. I am getting an error message saying the 'command text' property is not 'initialized'. Being a .net programmer, I know the comand text is the sql in text format or a stored procedure is not being accessed. This error occurs after I have setup a report manually and I have changed... more »
|
|
|
New to this...
|
| |
Hello all, Well I have a question for you, I am starting with Reporting Services. I have this simple Query : SELECT DISTINCT Name AS Category FROM Production.ProductCategory The result when Preview the report is a ComboBox name Category with 4 different choices (Accessories, Bikes, Clothing and Components) now this is... more »
|
|
|
passing stored procedure parameters to report services parameters
|
| |
I want to be able to pass stored procedure parameters to sql server reporting services 2005 report paramenters. I basically want to be able to pass up to up 10 parameters that I supply from a stored procedure in sql server 2005 to sql server reproting services 2005. Can you tell me how to complete this task and/or give me a reference where I... more »
|
|
|
|
