all groups > sql server reporting services > may 2006 > threads for friday may 5
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
Using query parameters in a Case statement
Posted by Denise at 5/5/2006 5:18:01 PM
Hello
I am using Reporting Services within Visual Studio .Net 2003, connecting to
a SQL Server 2000 database.
I am trying to use a query parameter within a Case statement but am getting
a syntax error. The query is as follows, with the @StartDate parameter in
the second 'Quarter' case sta... more >>
formatting textboxes
Posted by dataGirl at 5/5/2006 2:51:02 PM
I am rendering a report in VS 2003 and I need to know:
1) If it's possible to combine two different text formats in one textbox?
Sample database field = Notes.description
I want to be able to manually add the word "Notes: " (which I want to be
bold) in front of the data that's in the Notes... more >>
VS2005 ReportDesigner consistently crashes
Posted by Elliot Rodriguez at 5/5/2006 2:34:01 PM
For some reason, whenever I include a sub report in a table control, VS2005
*always* crashes.
It crashes when I attempt to preview the report and I am waiting for the
parameter textboxes to show up. They never make it. They simply crash, and
the Preview window reads "an error occurred durin... more >>
WMI Provider Error
Posted by tao_benz NO[at]SPAM hotmail.com at 5/5/2006 2:03:52 PM
I am new to Report Service and got the following errors.
After I unistalled the Report service, the Configure Report Server
still there. When I launched the Configure Report Server it says "An
unknown error has occurred in the WMI Provider. Error Code 80040219" I
reinstall the Report service ... more >>
Licensing issue
Posted by moonsuncool NO[at]SPAM gmail.com at 5/5/2006 12:04:43 PM
We do not want to install IIS on our database server to run Reporting
Services. As I understand that if RS is installed on a seperate
server, an additional SQl Server license is required. This will be
pricey!
Are there any other options available? If we install IIS and RS on the
database se... more >>
Jump to report - ERR - One or more data sources is missing credent
Posted by MSSQLServerDeveloper at 5/5/2006 11:30:02 AM
I have a chart where I want to jump to a report when the user selects a
certain piece of the pie. In development, this works fine. ALSO from the
report viewer the report being JUMPed TO works fine individual, but when I
try to jump to it from the chart, I get the error, "One or more data sou... more >>
Unattended Install
Posted by JoeVB at 5/5/2006 10:07:02 AM
I have been having trouble with the unattended install. I created a INI file
based on the template provided but in the MSI logs I get an error:
Licensing information is not correct. Please pass in a PERPROCESSOR or
PERSEAT.
In My INI file I have:
PERSEAT=50
(along with all the othe... more >>
Opinions on Organizing - Solutions and Projects
Posted by WonderingFool at 5/5/2006 8:38:02 AM
How are you organizing your solutions and projects? Are you creating a new
solution for every 'group' of reports? I am starting to wonder if I am
getting too granular and will have problems later on locating the reports.
All my reports have the same shared data source.
Right now, I am cr... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Fixed Headers in RS 2005
Posted by kelkoenig NO[at]SPAM gmail.com at 5/5/2006 7:58:18 AM
I've been playing around with RS 2005 for a few days trying to validate
the new features/enhancements with it vs. RS 2000. I'm looking at the
Fixed Headers enhancement and wondering if I'm doing something wrong.
I set the table property of 'Header should remain visible while
scrolling' and the ... more >>
errors in rssrvpolicy.config
Posted by taz at 5/5/2006 3:24:01 AM
i was tweaking the <CodeGroup> sections in rssrvpolicy.config
last week and seem to have corrupted something. i get 100
errors as below.
can anyone please help (or send me a default-install version of
the file).
thanks.
t.
---
Could not find schema information for the element... more >>
Installation Of SSRS
Posted by SSRS NEW at 5/5/2006 12:32:01 AM
I have two machines on a network (Machine A and Machine B). Machine A has SQL
Server and IIS installed on it and Machine B is the web server. Machine B
does not have Sql Server.
Is there any way by which I can upload my .rdl files on Machine B ie; create
the virtual folders (Reports and Re... more >>
expression question
Posted by angi at 5/5/2006 12:00:00 AM
Hi
Dose "Expression" can write any syntax such as CASE... WHEN... Structure?
I have a serial code such as B1, B2, B3.
When B1, the "jump to url" to http://b1.aspx. B2 the http://b2.aspx
I wirte this use IIF now but feel this way dosen't make sense.
So is any other way can instead of IIF?
Tha... more >>
how can i Assign 2 data sets for a single table in RDL file
Posted by mur via SQLMonster.com at 5/5/2006 12:00:00 AM
hai,
my requirement is :
in tabular reports , i need to Assign data fields from dataset 1 to Table
Header row
and ,for details row i need to Assign data fields from dataset 2
is there any way to assign multiple datasets to Single Table? . if yes could
you please tell me how to assign ... more >>
SQL Server 2005 Reporting Services to ORACLE OLAP databases ?
Posted by Ernestas Sysojevas at 5/5/2006 12:00:00 AM
Hello,
Do anyone know or maybe have experience there IS or NOT possible to connect
with SQL Server 2005 Reporting Services to ORACLE OLAP databases ("Oracle
Express" or "ORACLE OLAP") and make reports from Oracle OLAP cubes?
Ernestas Sysojevas
... more >>
layout problem
Posted by angi at 5/5/2006 12:00:00 AM
Hi,
I have 4 subreports in a report and adjust thier position well on layout
tag.
Preview on the report designer everything is fine.
But deploy to report server and browse on IE the subreports all on the wrong
position!
How can I resolve this problem?
Thanks for help!
Angi
... more >>
|