all groups > sql server reporting services > august 2005 > threads for wednesday august 31
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
problems with updating datasets in visual studio .net
Posted by Limor Bellison at 8/31/2005 11:23:03 PM
Hi,
I have a strange problem since yesterday.
I'm trying to change datasets in my project and I save changes. when I close
the Report and open it again I see that the changes where not saved. Also
the visual studio keeps getting stuck and I have to close it and open it
again.
I have notice... more >>
Combined line and column graph?
Posted by Cindy Lee at 8/31/2005 5:11:23 PM
I have a great column graph, but I was wondering if there were any options
on the graph so I add a trend line?
Or maybe there's an option I'm missing on the line graph.
... more >>
First, Last, Middle ???
Posted by PeteMitchell at 8/31/2005 1:33:08 PM
I have a Matrix that always displays two rows of data.
One row show values from Jan 1 of the current year.
The second row shows values for today.
In the foot I show the % the values have changed so YTD with the following
formula:
=(Last(Fields!Core.Value) - First(Fields!Core.Value)) /
Fi... more >>
RS2005 and SQL Server 2000
Posted by Scott Duckworth at 8/31/2005 1:29:38 PM
Can RS2005 run on/with SQL Server 2000?
... more >>
Export Just Data to Excel
Posted by Alec Hardy at 8/31/2005 1:28:02 PM
We would like to have a way to export just the data displayed in a report to
Excel. We have looked at CSV export, but find it doesn't export well.
We would like to remove the headers from the report when it exports. The
only way we have found to do this is to create a separate report withou... more >>
Vs Report Viewe r2005
Posted by Fritz at 8/31/2005 12:36:01 PM
I am using the report viewer that came with visual studio beta 2. With this
report viewer there seems to be no way to send paramters to the viewer or
specify a render format automatically. Is there anyway to send parameters to
the vs 2005 report viewer ?... more >>
One Date field with different dates
Posted by Shan at 8/31/2005 11:50:36 AM
I want to search on a date field with user input. How can I make it to where
it will give user a startdate and an enddate box? Remember I have only one
date field.
SELECT COURSE_NBR, ATTEND, COMPL_DATE
FROM EH_MEMINFO_1
WHERE (COURSE_NBR LIKE @COURSE_NBR) or
... more >>
Passing parameters to a dataset
Posted by John Smith at 8/31/2005 11:16:53 AM
I am a newb in Reporting services and need to create a parameterized report.
I have already created a report parameter and now I need to apply it in the
report output. I assume that I have to somehow pass this parameter to the
dataset that is used to display the data. I am putting =
'Parame... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
RS Web parts: Change web part title?
Posted by Kaisa M. Lindahl at 8/31/2005 10:42:14 AM
Maybe I should have asked in one of the SharePoint groups, but maybe someone
in this group knows what's wrong. Anyway, in a SharePoint Portal server 2003
portal, I've created a page with the Reporting services web parts. As the
company in question is Norwegian, I want to change the title of th... more >>
How to MOD and TRUNCATE in vb .net
Posted by MJ Taft at 8/31/2005 10:03:06 AM
we have the following formula in a business objects report that we to convert
to use in reporting services - I have no clue how to perform the MOD or
TRUNCATE in vb .net
=If(<Agent_Calls>=0) Then "00:00:00" Else
FormatNumber(Truncate((<TOTALTALKTIME>/<Agent_Calls>/3600) ,0) ,"00") & ":" &... more >>
Using parameters
Posted by Shan at 8/31/2005 9:17:04 AM
I have a scenario where I want user to input data for search. Statement
looks like
Select course_nbr, attend
From table_1
Where (course_nbr = @course_nbr)
This only allows user to input exact course number and then the query will
return a result.
I want to be able for user to input ... more >>
Report parameter - date format
Posted by Franklin at 8/31/2005 5:57:01 AM
I have developed few reports using reporting services (service pack 2), but
still facing some problem in the date parameter and would look for help /
share here. Thanks advance!
1) How RS treat the date format?
YYYY-MM-DD (the data is correct when i use this format)
DD/MM/YYYY... more >>
|