Search results for query: *

RS 2008 Data SQL 2005 Before I spend a couple of hours figuring out which is best I thought I would ask... I have a report where I am going to display an amount based on a parameter entered at run time. I have four different amounts but only one will be displayed at a time and I can think of...

SSRS 2008 SQL 2005 I do most of my filtering on the SQL side but I need to add a filter on the report side for this one field and cannot figure out the syntax needed. I have tried variations of the following but the report always retuns no rows when using the parameter default. Can you help me...

SQL 2008 RB using models SQL 2005 DB no direct db access I have a report that has 2 datasets. Dataset2 populates a parameter list with a extra value (Select Null, ALL) and the ALL is the default. Dataset 1 is the main data and this is where i have the problem. I am trying to set the filter for...

CR 10 SQL 2000 I am having difficulty getting the total from my sub-report to interact with the totals on my main report. I have done the following: Added to sub-Report: whileprintingrecords; shared currencyvar TotalResidual; shared currencyvar TotalResidual := Sum...

CR 10 CE 10 SQL 2000 I am grouping by a client name (group#1) and then by a date (group#2) of the four dates for a particular client 3/9/2008, 3/15/2008, 3/23/2008 and 4/6/2008. I only get three groupings 3/9, 3/23, and 4/6. The 3/15 record is included in the 3/9 grouping. Any ideas why this...

CE 10 I have a server running out of disk space and am in the process of transferring to a new server. I used the import utility to move all the objects but it does not look like any of my scheduling came over. Is there another way to do this or is there something more I need to do? Thanks BB

SQL 2005 RS BIDS 2005 I have created several report models and we have added columns to the underlying schema and I want to make those available. How can I do this without recreating the model? Thanks BB

CE10 SQL2000 I am running into an issue where reports are not being generated through scheduling and I was thinking of adding another CMS to help with any failures. Can more than one be run on the same machine or does it require an additional machine? I have looked for information and all I can...

SQL 2005 I have built a drill down report and want to add an bottom border for the lowest level being displayed. Is there a way to build an expression into the grouping to do this? I want this to be dynamic so that it would change as the user drills down. Thanks BB

CR 10 SQL 2000 I am trying to get the number of days between two dates that exist in the same column but different rows. I tried: if {table.Action} = "Checked" then datediff ("d", {@Received}, {table.DateCreated}) The formula reads: if {table.Action} = "Received" then {table.DateCreated} I...

There is a rule in the model generation rules that madates a filter if the records are over 5000. That is way too low for our data. Does someone know how to modify that rule? Thanks BB

Hi all, I am using CR 10 CE 10 on SQL 2000 I need to evaluate records in the table Attachments that contains a column called category. This table relates to a table called customers. There is a one to many relationship with the many in the attachments table. I need to find clients If Every...

CE 10 Is there a default set limiting the number of folders that can be placed in the ePortfolio directory structure? I am getting an error of "Not a valid query" when i attempt to save into any newly created folder system created or not. Thanks BB

CE 10 I am having an issue saving a report in a subfolder I created in ePortfolio. When I try to select the subfolder I get an error "Not a Valid Query". Has anyone seen this before? It just started happening with new accounts that are opened. Thanks BB

Hi all, CR 10 CE 10 SQL 2000 I am creating a formula to set the date range of a report that is to be run on the 25th of the month. What I want it to do is include data from the 25th - end of the previous month as well. Here is what I have created to find the end of the previous month and then...

CE 10 CR 10 SQL 2000 I am wondering if it is possible to group the main report on a value passed from the subreport. In my subreport I have this: @Advocate shared stringvar Advocate; shared stringvar Advocate:= {Client.Name}; shared stringvar Advocate; In my main report I have this: @Advo...

CR 10 CE 10 SQL 2000 Hi all, I am accessing an XML file with multiple nodes but only the first node shows in CR. Is there something I need to do to get all nodes to show? Thanks BB

CE 10 Can someone tell me what the default directory that the report templates are stored in? Thanks BB

CR 9 SQL 2000 Hi all, I am trying to get my report to supress a full page of detail based on the Balance Due coming from a subreport. I have my shared var like this in the subreport based on a running total: whileprintingrecords; shared currencyvar BalanceDue; BalanceDue:={#BalanceDue}; In...

CE10.0 SQL 2000 I am trying to get the balance of a field prior to the LastFullMonth. I have built the following into a subreport because my main report returns the LastFullMonth. Is there a way incorporate AllDatesToToday as this does not seems to be working. Here is what I am using in my...