Search results for query: *

Hi, I have some custom reports that run off the Filtered views in the CRM database. These reports are SSRS reports that are deployed in Report Manager and accessed outside of CRM. The users that are setup in CRM are able to view the report data fine. The users not setup in CRM cannot view...

Hi, I have a case summary report. Each line is one case and has the case number displayed. On the case number field, I have setup a hyperlink to the case details report, which is another report in the same VS project. So, I run the summary report- I click on one of the case numbers- the...

Hi, I have a dataset that has multiple lines per invoice. I need to get invoice total - place negative amounts in one column and positive in another. The data is then grouped at three more levels above invoice number. I am having trouble getting group totals of the +ve and negative columns...

Thanks for your response. In this case, the report had been developed by a client. When they faced this issue, they were reaching out for some help. Thanks.

Hi, There could be a simpler answer but a solution that strikes me right away is to use two sub-reports, place them next to each other. One subreport would display the colurs and the other type. The sub-reports would link to the main report on type - so for each grouping of type, the...

Hi, Crystal 10. When I try to open a report thats reportedly been working before, I get the message : The docfile has been corrupted. To me that says that the report file is corrupted. Is there any way of getting around this? Fixing? Anything that I can do other that chuck the file into the...

Hi, I need to have a report legend displayed below the report name and above the data table only on the first page of the report. I placed it in text boxes to look like a tabular format. This previews as expected in the VS2005 preview screen. However the text boxes are all over the screen...

Yeah, real SQL stored procedure. Report's data set just has EXEC [db_name].[dbo].[proc_name] <dateparam1>,<dateparam2> Stored procedure is rather long and calls other procedures there and therefore, the code cannot be placed directly in the report's data set.

Hi :) I was wondering if you could use a formula field in the cell that converts the number and percentage into character (fixed width for uniform look) with spaces in between so that it actually looks like two fields placed side by side. If you were not using a matrix, you can select a column...

I am having trouble getting the SQL proc accept the mv param....it accepts and works when there is only one object. Gives that error: "Must declare scalar variable @rptMVparam" when I click on two values. Thanks.

Hi jymm, Thanks for your response. I am trying to do it one of two ways: 1) filter in SQL : for this I need to pass the multivalue parameter to SQL. This is not happening as when I click two value in the drop down and try to run the report, I get a "Must declare scalar variable @rptMVparam"...

Hi, I need some help getting multi-value parameters to work in SQL Reporting Services. Using VS 2005 to develop the report, backend is SQL 2005. I have been reading around and I "think" I understand the concept of Split, Join, that the multivalue param is an array, cannot be used as such...

Hi Not sure about doing this in Crystal, but you could effect this by using a stored procedure as the basis for this report. Thanks.

Hi, Could you try using shared variables in formulae and increment (count) the value of the variable everytime the supress condition is met? Something like: //variable initialization. Place formula where the variable // can be initialized/reset. shared NumberVar x; x:= 0; //group header 3...

Hi dawnyanne, The sub-report is like a report by itself. You should be able to go to the section expert of the sub-report and supress as many sections in the sub-report as you want. Sections in the sub-report are quite independent of those in the main report. Hope this helps.

Perhaps you can summarize the fields in a stored proc and include that in the report. You can display the summary fields in the group header and the detail level fields in the detail section.

Never mind!! I added a SET NOCOUNT ON to the start of the proc and all is well! Thanks.

Hi, I expect you can total the fields in the detail section to the group level. Crystal automatically places these summary fields in the group footer. Then drag it up to the group header section. If this works, then you should not need the sub-report. Thanks.

Hi, I am trying to create a Crystal 8.5 report off a SQL 2000 stored procedure. When I try to make the procedure the basis of my report, it gives the error: 'No rowset was returned for this query, table or procedure.' I have faced this before. I comment everything out and place 'SELECT 'A'...

Hi, I don't know how to do this through Crystal. Here are two SQL options though: You could write or request for a new stored procedure that calls the original stored procedure passing it start and end date parameters based on the system date. I am not very sure, but I think you can set...