Search results for query: *

thread631-1618242 I'm helping a company that tried to implement Sage X3 and would like to compare notes with anyone in the US or North America who is using it. I have lots of ERP system experience but only a month on Sage X3. So far I feel like I have very few resources but am still in the...

Hi Everyone, I hope I can get some input on an issue I'm facing. I recently retired due to health issues and have limited finances. I was given an iPad (the latest and greatest) but I'm beginning to think it's just a marketing device to get money out of my pocket. At this point my impression is...

I have a spreadsheet with connections to four SQL Server stored procedures. Each one returns data for a graph. The graphs are all on one page, making a kind of ersatz dashboard. When I click the refresh button, the screen jumps four times, once for each SP. Is there a way to smooth that out...

I posted this question on the MSDN forum earlier today and haven't received a reply on it yet. As I'm under the gun to get a complex report finished, I'm apologetically posting it here as well: I'm relatively new to SSRS 2005, have used Crystal and Access for many years. In developing with...

I'm transitioning to SSRS 2005 from Crystal. I (think)proved to myself that in development, SSRS doesn't create a copy of the subreport like Crystal does. It seems to grab the separate report I wrote every time I run the container report, and brings in any changes I made to the subreport without...

When I'm testing a query in the data tab, how do I pass through a multi value parameter when the parms pop up? I have month numbers (1,2,3, etc.) but can't get the thing to take more than one at a time. Thanks!

Now I'm having fun... I have a report with two tables. They both use the same data source, a stored procedure. They test fine. I added a chart below the tables. It uses the same data source. The chart looked fine, but the data from my tables disappeared. The cells and formatting were still...

What am I doing wrong? Thanks! Difference between sort results from query in data tab… ORDER BY InvoiceOrderNumber,InvoiceOrderLine, InvoiceOrderLineRelease RESULTS: The report sorts this way until I re-sort it using the interactive sort feature on another field. Order Line Release...

Just FYI - After much trying and searching of MSDN and forums, I finally found what I was doing wrong. I was trying to make something work that isn't supported. (Interactive sorting groups on a calculated field in the group footer.)...

Is there a way to export the report definition similar to what you can do with Crystal Reports? I need to extract metadata for each report to our metadata database. This is a new data warehouse project not gone live yet and we're on a learning curve. TIA!

I'm new to SSRS and trying to cope with the infamous divide by zero problem. By Googling, I see references to placing a function in the code section to do this, but haven't been able to see an example of the actual function. Does anyone know of a function to do this posted on the net, or can...

I have a line graph in SSRS 2005. My data looks like this: Month Sales 1 40,643.00 2 34,524.00 3 68,465.00 4 24,323.00 5 60,752.00 6 25,013.00 7 51,784.00 8 9 10 11 12 Because we're part way through the year, some months have no values in them yet. The line graph makes it look...

We tried a number of things Friday in a class and nothing seemed to work. Surely it can be done?

Hi all, I am new to SSRS. Please help me get past the "why doesn't this work like Crystal?" stage... I have groups in my report, and calculated values in the group footer. (I have named all my groups and text boxes so I can refer to them.) Each group footer calculates the % of each Customer to...

We're just embarking on a Data Warehouse project and must learn quickly about the capabilities/shortcomings of Reporting Services. Although there are a few mentions of SSRS scattered throughout Tek-Tips, I don't see a forum devoted to the topic. Thus my two questions: 1. Anyone know of a SSRS...

(T-SQL 2000) I'm trying to find duplicate customer records that have been set up in our db. If I concatenate Address+City+State+Zip, Is there a way to count the number of occurrances of that string? The customer numbers will be different if there are multiple identical records. Thanks for any...

I know I had a link to a complete list of Crystal constants, and I can't find it. I'm specifically looking for a constant to set the font size depending on the value in a field, but would love to have the whole list. They don't seem to be accumulated in one place in online help, and a search of...