Converting any digital media/file is not easily be possible but there is no such thing "illegal" if, “Tool used for creating media does no more support features as described by vendor or Created Media/File no more advantageous for your business or Tool used in crating media/file does not perform...more >>

i think i have d same issue. I have my own view (say rpt_FilteredContact). and i need to add the "CRMAF_" prefix to that, in order to make it context sensitive (i.e. pre-filterable). Is there any other way to achecive this ?? Thanks. From http://www.developmentnow.com/g/115_2006_6_0_0_776107/this...more >>

I'm trying to return the parameters used in a report in the report footer. Where it is no problem getting back the values I would also like to display the actual parameter name. However I haven't found a way to do that yet. My hunch is this needs to be done with embedded code. If anyone has got ...more >>

Can anyone help to use "Underlay following Sections" of Crystal reports in SQL Server Reporting Services. From http://www.developmentnow.com/g/115_2006_1_0_0_684029/underlay-watermark.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I have problem in Reporting Services 2005 with width of report - max. limit is probably 406,34921 cm. Is it possible to increase this limit to for exapmle 450 cm ? From http://www.developmentnow.com/g/115_2004_11_0_0_453315/ErrorThe-type-initializer-for-Microsoft-ReportDesigner-Drawing-Language-t...more >>

It doesn't help. Do you have any idea. thanks. From http://www.developmentnow.com/g/115_2005_6_0_0_551901/DateFormat.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Has anyone found anything other than deleting the rdl.data? I copied a report.rdl and pulled it into the same solution so I could try working some objects slightly differently. But now when I try to run the modified report I am getting this message. It seems to be related to the document map and b...more >>

Instant solution, great thanks a lot Robert :) From http://www.developmentnow.com/g/115_2005_7_0_0_569127/How-to-remove-Document-Map-Labels.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hi I'm also getting a very similar error. Any solutions for the same? Any help would be appreciated. From http://www.developmentnow.com/g/115_2004_7_0_0_448611/Error-StringStartsWith-cant-accept-null-parameters.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Which version of SQL Server 2005 do you have? I had the same issue and found out that this bug doesn't occur on the RTM version Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86). However it does occur on the SP2 version. There is a SP2 cumulative update that is supposed to fix this issue, but it...more >>

hi all, iam working in sql reporting services having 1 stored proc.I hav 3 different tables and in the 4th table ,i want to add sum of two tables and subtract the value of 3 from sum of 2. i treid in this way... """"first(fields!Previous_Commitment.Value, "table1")+ " " + first (fields!Commitment....more >>

I have encountered a diffrent problem. If my data source returns 45 rows or less, the table fits on one page and the header is locked for scrolling, If the data source returns 46 rows or more, it ignores the "header should remain visible while scrolling" and "fit table on one page if possible" opti...more >>

Can anyone tell me how I can do this when I am AVG a column. I have the following code =FORMATPERCENT(avg(iif(Fields!hrs_cum.Value = 0, 0, Fields!hrs_cum.Value / iif(Fields!hrs_curterm.Value = 0, 1, Fields!hrs_curterm.Value)))) Now once it finds a zero it outputs a #error. Hoe can I make it han...more >>

type initialization exception:The type initializer for microsoft.reportingservices.diagnostics.globals threw an exception This is the exception i am getting while running a report in SSRS.Can anyone plz help me out with this From http://www.developmentnow.com/g/115_2005_4_0_28_0/sql-server-repor...more >>

I gotta be missing something - I need to display a label and two numbers separated by a vertical bar: "My Label: AAAA | BBBB" on one line, concatenated together with minimal white in between. And this lines up with othe label and value above and below. Values maybe be from 1 to 6 characters lo...more >>

Hi!. i faced the same problem posted by you and I was able to find a solution also. When I got the error log message below after configuring reporting server E mail settings WARN: The extension Report Server Email does not have a LocalizedNameAttribute. WARN: The extension Report Server Fil...more >>

Hi all, Im having problem with navigation URL. I want to pass in a value as a querrysting from a field. Example: http://localhost/myWorld.aspx?planet=Field!Planet.Value. But when i click the url, it gives me http://localhost/myWorld.aspx?planet=Field!Planet.Value. and not http://localhost/myW...more >>

Use "value:isnull=true" From http://www.developmentnow.com/g/115_2004_10_0_0_451623/NULL-DateTime-parameters-via-URL.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Can you give more of an example of how to do this these is not quite enough information here. From http://www.developmentnow.com/g/115_2005_5_0_0_516312/Displaying-2-records-per-row.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

When I export a report designed in RS 2005 that has 5 nested drill down (visibility hidden until expanded) groupings to an Excel Spreadsheet, the Subtotal function in Excel only show 2 levels of subtotaling. The 1st level and the last level. No matter how many groups the report has in it, ...more >>

unable to add a field in report viewer which is not selected in dataset From http://www.developmentnow.com/g/115_2005_9_0_0_598578/report-item-not-linked-to-a-dataset.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

unable to add a field in report viewer which is not selected in dataset From http://www.developmentnow.com/g/115_2005_9_0_0_598578/report-item-not-linked-to-a-dataset.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I got the exact same issue and it turned out to be an issue with the default values in a Report Parameter. Modified the default values and the error went away. From http://www.developmentnow.com/g/115_2004_12_0_0_453709/AW-exception.htm Posted via DevelopmentNow.com Groups http://www.developmentn...more >>

hi, you can write your own class which convert a string 2 an image, rotate the image , send it back to the report. use an image control to view your textimage From http://www.developmentnow.com/g/115_2004_12_0_0_454324/rotate-text-to-be-up-and-down--.htm Posted via DevelopmentNow.com Groups http:/...more >>

HI, I have a report that I am rendering into HTML using SOAP by programmatically creating a subscription. For some reason, the page breaks I have in the report aren't effectively posted into HTML, so I get up to 3 pages (which should be separate pages, as they are on the screen and in PDF, for exam...more >>

I am also getting this error intermittenly on some reports. It is text query not a stored procedure and sometimes it works for the same user. The database and table being queried have high activity. Could this be a colision or exclusive lock? Since it's intermittent it is hard to troubleshoot. F...more >>

This fixed My Problem Solution The problem is occurring due to missing permissions on the SQL server. This can occur because the database was restored or moved as the permissions are applied during installation by default. The following query can be run to apply the correct permissions. This ...more >>

Also, check the credentials on the datasource : if these are using integrated windows security, I have found that the new subscription and new data driven subscription options are greyed out. Using stored credentials works fine. From http://www.developmentnow.com/g/115_2007_6_0_0_986199/Unable-to-c...more >>

Thank you for this information, helped me get the Report Manager up and running on my XP box. From http://www.developmentnow.com/g/115_2006_7_0_0_784539/Report-Manager-Virtual-Directory-disabled.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

BUMP Has anybody actually gotten this to work? I agree that using sub reports is NOT a valid solution as it does not scale. I have a similar issue with a report that has 3 sub reports. This report can return up to 400 records, no add the additional 1200 database calls for the sub reports and I...more >>