Search results for query: *

I have a template from someone else, an RDL that is loosly modeled on one of my reports. This is called Report1.RDL There is an error when I double click on Report1.RDL "One or more errors encountered while loading the designer. Data at the root level is invalid. Line 1 position 1." this is...

I want to make sure that I have the Reporting services environment correctly installed. I have no background in SSRS or SQL Server for that matter. I wrote many Crystal Reports that now have to be converted. It is not too difficult to get an RDL converted file from Crystal but the question is...

I set up parameters for dates on the where SOP10100.DOCDATE >= @Startdate and SOP10100.DOCDATE <= @Enddate but am getting an error message: Must declare the scalar varibale @Startdate

I ran one of my Crystal Reports through a converter that's supposed to convert Crystal to SSRS. Of course, not 100% but I am hoping for an intelligent shell to see how things look on the other side. I got from this converter an XML file, with an extension of RDL. I was sort of expecting a run...

In Crystal Reports, you can specify fields that should be summarized. This creates a new field that holds the summary or also can do max value of all fields and holds that. This summary you would place on the detail line and could surpress the detail so you would only have the summary. I am...

We are in the process of writing or converting some reports for a company that provides services for their clients, and wants to post these reports to a company web site, and have their customers, login and get their reports. This would include a security layer within each company as well. I am...

I would like to know how/where do you enter the fields for the matrix?

HI I want to backup a table with 'some' data, not all the data. The developer wants to see all the fields and everything. I did a CSV file but he says this is not what he means. How does one make such a backup, for SQL Server 2005?

I have to mimic an existing Crystal Report, using SSRS. I have some basic questions, would appreciate any help. The question is how to do the following in SSRS. 1. I have 2 paramters, a start and end date, that are used in Crystal to calculate months periods, going three months back. (these...

I have to see about using Microsoft Services to publish Crystal Reports to the web. Is there any guidance I can check for how to do this? I beleive there are many other methods used to accomplish this. Perhaps that someone here has been using MS RS?

I am looking for any info on using Crystal Reports with MS RS. We have an interface there that will call the CR. Is there anything special I need to do in the existing CR? Parameters or how to get these interface fields?

In a recent Crystal Report I developed we will need to choose the group of customers that we are looking at. For that we need to query the customer type on the customer profile page (I don’t know the name of the field in the table). This will limit which customers appear together with one...

I am not understanding how the charts expert works. It only offer fields that are Groups. I need to show a chart that has the items across, and their monthly totals in a pair, current year month and underneath last year month for 4 months across. The problem is that the total fields are not...

After I entered one month column - 2 columns, one for previous month/yr, I then added 6 more colums for the next 3 months and previous. For some reason, it goes across fine but then it adds a copy of the 8 columns across. It looks ridiculous and you can't delete a section. Why does it do this?

For Crosstabs, you can specify the Summarized columns to be displayed horizontally or vertically. However, the label doesn't come along. WHen I make them Horizontal, the labels are one under the other rather than across over the colums. Is there any way around this?

HI I have to write a Report that will show groups such as Food products sold, e.g. Meat, Fish, others, etc. comparing this year month with last year/month going back 4 months as well. I was not sure if this is something you group on or how to set up such buckets here. My exisitng SQL is posted...

HI I have to write a Crystal Report that will show groups such as Food products sold, e.g. Meat, Fish, others, etc. comparing this year month with last year/month going back 4 months as well. I was not sure if this is something you group on or how to set up such buckets here. Thank you for any...

I have this column of fields that are inserted to the report as Summary max fields, yet this column needs to be summarized but I am having difficulties to make this summarization. AS one cannot summarize on such a field.

I am not getting the parameter to 'prompt'. The CR just runs with a date that it has rather than prompt for a date. How do you code the parameter to prompt?

HI I have a union SQL that join the History and current tables. This works fine except there is one issue that have to be accounted for. I would like to account for this in the SQL rather than the reporting level. The first issue may be handled by changing the SQL to left joins. 1. Averages are...