all groups > sql server reporting services > august 2006 > threads for monday august 14
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
Sales Totals for all months
Posted by blabore at 8/14/2006 9:09:01 PM
I have a report that shows a graph of sales counts for each month. My problem
is, occasionally there are months with no sales for some products, so my SQL
query doesn't return a record for that month, and the graph skips a month.
Since my users are confused by this, I'd like to at least show t... more >>
using repeatwith in a list
Posted by Arlyn at 8/14/2006 4:53:47 PM
Hi,
I have 3 layers off lists. The details list with two outer groupings. I
want the texboxes in the two outer lists to repeat on each page. The repeat
with doesnt seem to work. Does anyone have experience with this?
Thanks,
... more >>
How to set connection at runtime
Posted by Richard at 8/14/2006 1:11:02 PM
Hi,
Our application connects to one database in the testing environment and to a
different database in the production environment. Currently, with Crystal
Reports, we maintain a single set of reports, and at runtime, when the
reports are loaded, the application sets the report's connection ... more >>
Foxpro date syntax problem from SSRS 2005 using VFP ODBC driver.
Posted by bmchan at 8/14/2006 11:15:02 AM
Looking for a way to return records within a date range. Having problems with
parameter as a date syntax.
I usually just SSIS batch my FoxPro stuff into a SQL enviroment so I can
take full advantage of SQL Server 2005's familiar, fast and not too fusy
T-SQL syntax.
However I have a requ... more >>
Installing Reporting Services (not DB) on 2003 Web Edition
Posted by AlexD at 8/14/2006 9:18:02 AM
We have a Windows 2003 Web Edition server that I would like to install SQL
2005 Reporting Services (not the Database) on to. This is the report
manager, report builder etc. so that users do not have to connect to the
database server. However the option to install the services is not availabl... more >>
Hidden Property - "Deserialization failed: is not a Valid Value" E
Posted by bsod55 at 8/14/2006 9:13:01 AM
If I add an expression to the visibility property on a text box, table row,
etc.. and then remove that same expression, I get the following error message
in preview:
"deserialization failed: is not a valid value..."
I get an option to edit the XML code. When I look at the code, I find t... more >>
OK button doesn't Work In Report Manager RS2000
Posted by Rgranada at 8/14/2006 8:13:52 AM
Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1
with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.
My problem is that any page of the report manager with a "OK" button,
that button doen't do nothing, it is enabled bu doesn't do any action.
Can't figu... more >>
How Do I Manage a Report Header
Posted by msflinx at 8/14/2006 7:41:01 AM
In a post titled "Report Header Only on First Page", Charles Kangai replied
that:
"It sounds like you have used a page header rather than a report header in
your report. A report header automatically does what you are wanting to do.
To create a report header, just place a textbox above your... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
background color and background image after SP1
Posted by Benno at 8/14/2006 7:06:14 AM
Hi,
after installing sp1 for sql server 2005 the properties "background
color" and "background image" do not show in HTML. They do show in TIF
or PDF export. Also the header and footer are rendered correctly in
HTML. Only the body of the report is always white!
Any suggestions?
Thank you... more >>
Parameter Information cannot be derived from SQL Statements with sub-select queries
Posted by Timothy.Rybak NO[at]SPAM gmail.com at 8/14/2006 7:03:32 AM
I have the following query that finds the most Serial number of the
most current part manufactured at point 105 (near the end of the
process), then uses that serial number to find out when it started
production at point 39 (the front of the process). Then, it gives a
listing, summarized by part... more >>
Opening Reports in continuation in pdf fomat
Posted by Rohit J at 8/14/2006 4:38:01 AM
Hi
Just wanna know how to open two reports in continuation in pdf fomat
I am using Sql server 2000 Reporting Service . The scenario is that I have
two reportsA.rdl and B.rdl . The first report A.rdl is to opened in Acrobet
foramt with dyamic header/footer. Once the report is completely ... more >>
Dynamically create a snapshot
Posted by Mike Stephen at 8/14/2006 1:28:01 AM
We would like to dynamically create a snapshot, based on other events. We
have snapshots based on tables which are created from overnight processes,
but which can sometimes overrun. Snapshots scheduled to run at fixed times
can then fail because the tables don't yet exist.
Any thoughts on ... more >>
|