SQL Server - Suppressing

I have a report that has a table with basically one grouping.  I have sever
rows of the same group and another table inside each of the rows.  So
basically I have 25 rows od the same group with a different table inside
eavh row.  So table inside of a table.  My problem is that whenever one of
the group tables has no data, it still shows whitespace and I cant get it to
suppress when its blank.  Any ideas?

  vinuthan replied to Ben Watts

hi,

can you set the width=0 and then set the visible for that row=false.

Regards
VB

Particular query problem SQL Server Hi, I have 2 similar tables, like these: Create Table Report(Month int, Value float) Create Table ReportCorrect(Month int, Value float) with these values: Insert Report values(1, 16), (2, 11), (3, 12), (4, 15), (5, 0), (6, 34), (7, 56 34), (7, 56), (8, 14), (9, 24), (10, 31), (11, 12), (12, 14) In the Report table, for the months 5 (May) and 10 (October), I have Value = 0. Now I third table too. But if I find two months with value = zero in the table Report, I have to sum them with the first month with non zero value. Luigi This Server 2000: SELECT month, SUM(value) AS value FROM ( SELECT R1.Month, C.Value FROM Report AS R JOIN ReportCorrect AS C ON R.Month = C.Month AND R.Value = 0 LEFT JOIN Report AS R1 ON R1.Month > R.Month AND R1.Value <> 0 AND NOT EXISTS(SELECT FROM Report AS R2 WHERE R2.Month < R1.Month AND R2.Value <> 0 AND R2.Month > R.Month) UNION ALL SELECT C.Month, C.Value FROM Report AS R JOIN ReportCorrect AS C ON R.Month = C.Month AND R.Value <> 0

SRS Report Help SQL Server Using SQL 2008 and Visual Studio 2008. Exported a .rdl file report from our Microsoft CRM application, to modify the report using Visual Studio. The intent is to use similar data from the exported report, format it differently and re-import the report back into CRM. I have text boxes that I have added to the report. In my design view of the report these text boxes appear within the top 4-5 inches of the report. Rendering this report in Landscape or normal view should not push these fields to the

Drillthrough report using "Jump to URL" quits working when Parent Report Parameter values are changed SQL Server I have a summary report that lists totals and the report has the ability to drillthrough to another "details" report by clicking the numbers on the summary report. The details report is rendered in a separate window using details report. This has worked fine for some time, but my problem is I need to modify

Slow Performance with Dynamic Grouping and ReportViewer In Local M SQL Server I am having quite a problem with very problem. In order to find the bottle neck I have created two reports with one grouping. One has a normal static grouping expression of Fields!MyFieldName.Value while the other also has a static expression but of the form Fields("MyFieldName").Value. This because I need to use dynamic grouping and will replace "MyFieldName" with Parameters!MyGroupParam.Value when this problem is resolved. I am 200 distinct values in MyFieldName. When I load these reports as rdl files to the report server and either run them from the Report Manager OR use a WebViewer or WinForm Viewer in REMOTE mode there is no problem in about the same time (about 1 to 2 seconds). When I use the same report definitions as rdlc (Local Mode) then the first report still renders fast (about 1 to 3 seconds). HOWEVER the second report requires at least

How to create this grouping in ssrs? SQL Server I have a dataset with the following columns: This is a and so on for half a dozen measure columns I want to create a table report with the "health authority" as the highest grouping and "city" as the second groupng and "hospital" as the lowest grouping. Initially the report shows only the "health authority" data and user can drill down to the next grouping level (or drill up back to the next grouping) and so on drill down to the "hosppital" grouping. I have tried all different grouping combinations to achieve this with no luck. I created