all groups > sql server reporting services > july 2006 > threads for monday july 17
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
grouping problems
Posted by newbie00100 at 7/17/2006 10:34:01 PM
how to i make a report like this?
group 1 start
group 2 start
group 2 end
group 3 start
group 3 end
group 1 end
i keep trying, but can only make a report like this:
group 1 start
group 2 start
group 3 start
group 3 end
group 2 end
group 1 end
i am using sql server 2000 reporting ... more >>
Truncating Spaces
Posted by vinodsh_82 NO[at]SPAM hotmail.com at 7/17/2006 9:13:26 PM
Hi
i had written custom code to separate date and time parts with 5
spaces. But when i preview the report, it is truncating the spaces that
are more than one. It is allowing only one space between date and time
(4/19/06 12:05 PM).
When we export the report as pdf, it is showing correctly (4... more >>
show 0 for blank data
Posted by bevarg at 7/17/2006 3:13:32 PM
Hi,
I've created a report that contains all fields from table1, table2, and
table 3 in a table format.
what's happening with my report is:
when a customer has info about him/her in table1 but not in table 2 or
table 3
the report won't the customer record at all.
but when a customer has ... more >>
Problem " IN(@Parameter) "
Posted by Steve Dearman at 7/17/2006 2:30:42 PM
Hi
I have a query and am filtering one of the fields.
This fields is a uniqueIdentifier which i am casting to a nVarChar(36)
the filter of this field is then IN(@Parameter)
this parameter then has this as the default value
="N'058D0A1B-7DB2-DA11-84EC-00065B3B13A4',N'222B3BE4-7CB2-DA11-84EC-000... more >>
problem opening data connection
Posted by Dan D. at 7/17/2006 12:36:02 PM
Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
someone else created. I'm not very familiar with either RS or VS. When I go
into VS and load the solution (someone told me how to find the correct one)
and then in the solution explorer, I double click on the report ... more >>
SQL 2005 with Windopws XP
Posted by Feches at 7/17/2006 10:42:01 AM
Hi,
I have a company with 3 computers and the 3 computers have Windows XP and
I can’t buy a new computer.
Can I install SQL 2005 with Analysis Services and Reporting Services? I
want to create cubes and reports to analyze the transactional information.
Does it works?
THX.
... more >>
How do I reference a field within a subreport
Posted by shane.eckel NO[at]SPAM seattlesoftware.com at 7/17/2006 8:49:56 AM
Does anyone know how to reference a subreport to find out if a field
within it has data, such as a ParentID field?
Thanks!
Shane
... more >>
Get rid of the weekends
Posted by Benw at 7/17/2006 8:33:02 AM
SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_ID,
MSP_TASKS.TASK_NAME, MSP_TASKS.TASK_FINISH_DATE,
MSP_TASKS.TASK_START_DATE
FROM MSP_PROJECTS LEFT OUTER JOIN
MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Unable to Start Report Server Windows Service
Posted by Amedeo Feroce at 7/17/2006 8:07:43 AM
For some reason I am unable to start RS Windows service. Here are the
details of Exception that I get -
****************************
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceControoler.WaitForStatus... more >>
Security & Enabling My Reports that support user-owned folders
Posted by clutch at 7/17/2006 6:40:02 AM
Hi,
We are looking to enable the My Reports that support user-owned folders
functionality but we don't want everyone in the company to have this
functionality. For example, we would want management and above to have this
functionality but no one below. Is this possible?
Thanks a bunch!... more >>
Failture to start Report Builder from Report manager
Posted by Marc at 7/17/2006 5:56:02 AM
Dear all
I want to start report builder from report manager. I configured IIS with
integrated security. Everything seems well configured - users with access
rights can access Reporing Services, users without accessrights cannot.
But with reportbuilder I have a Authentication problem. A us... more >>
How to add Combo box or dropdown List for picking month,Day and Year,Seperately as a Report Parameter in SSRS2000?
Posted by ajmera.puneet NO[at]SPAM gmail.com at 7/17/2006 4:47:45 AM
If Anyone konws that :
How to add Combo box or dorpdown list for date picking option as three
different boxes are to be used for Month, Day & Year OR Any other
way of picking date in Sql Server 2000 Reporting Services as a Report
Parameter?
... more >>
|