Data Fields outside of report section
I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields [...]

Answer Question   |  March 31, 2012  4:45 PM
Crystal 8.5, Crystal Reports 8.5, SQL, SQL Reports

SQL Report Help
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]

Answer Question   |  June 1, 2011  11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS

SQL reporting
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]

Answer Question   |  February 22, 2011  8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005

sql Reporting services – report name
I have a report that runs nightly for daily invoices. It runs everyday using a subscription and places the report in a shared folder. It’s called “Daily Invoice Report”. How do I get the the Report Name “Daily Invoice Report” to also include the date that the report is for. This date is a parameter [...]

Answer Question   |  October 8, 2010  2:10 PM
SQL 2005 Database design, SQL 2005 Reporting Services, SQL Reports

controlling page breaks in a spooled SQL report
I have written a SQL report that validates many of our tables.  Only when there is an error on a table will a report of that table print.  The script contains 32 different select statements each one associated with a different table.  I need to have a page break between the reports because the tables [...]

Answer Question   |  February 1, 2010  8:50 PM
Microsoft SQL Reporting Services, SQL Reports