![]() |
|
#1
|
|||
|
|||
Reporting Services - please help!Hi,
I'm working with Visual Studio 2003 and Reporting Services 2000. I'm having a problem with some "missing fields" in the chart I have created. To be specific, my Y-axis is a time span of several weeks, and sometimes random weeks go missing. I have several parameters as well, and I suspect that the problem is that the data is being filtered before the data field can be COUNTed. The result: where the COUNT is zero for some certain week, that week will disappear, leaving a gap in my span of time on the Y-axis. I have two possible solutions, but I do not know how to go about them: 1) I need to be able to manually change the "And/Or" column in the filters tab of my Grouping and Sorting Properties. 2) I need a way to set the values seen on the graph. For example, in my data fields, I have the expression: COUNT(Fields!status.Value). Is there any way so that I can specify that I only want to see the data when status is 10 (e.g. COUNT(Fields!status.Value=10), but I don't know the correct syntax)? Does anyone know how to do either of these, or perhaps suggest another solution? In any case, I need to know how to do #2 anyway, for another problem I have. Any help would be greatly appreciated! Thanks! |
Recent GIDBlog
First week of IA training by crystalattice
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Offshore Software Product Development & Testing Services | ampsoft | Member Announcements, Advertisements & Offers | 0 | 22-Dec-2005 00:15 |
| MFC reporting source | bryan523 | MS Visual C++ / MFC Forum | 1 | 24-Oct-2005 17:00 |
| MFC reporting tools? | bryan523 | MS Visual C++ / MFC Forum | 1 | 30-Sep-2005 11:07 |
| DiscountASP.NET Launches SQL Reporting Services | dasp | Web Hosting Advertisements & Offers | 0 | 19-Oct-2004 17:32 |
Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The