Search results for query: *

Oops! Sorry missed that crucial part... I am working in ReportStudio 1.1. BR Dudden

Hi there! I have an issue regarding a selection of data that I want to look at. The thing is like this: I would like to group data by counting how many contracts a customer have and show only these customers that has between 0 and 10 contracts. I started out like this: total(count([Contracts] )...

Hi everyone! I have a question regarding filters. When I create a tabular filter like CustomerContract.Contract.Current = 1 and then I have a dataitem in the report called "No of unique customers with a contract" where I filter like this: if ([CustomerContract].[Customer].[Finished] = 'N'...

Thanks for your time and knowledge. When just using char it works just fine! Thanks again! BR Dudden

Thanks for the advice and your really quick answer! I tried cast_char([CampaignNo]) and putted this into a report and it works fine but I only get the first number in CampaignNo for example 3456 = 3, 4567=4... how to fix this? BR Dudden

Hi there, I tried to do this but then I get the error message that I can´t do this request and the information about the problem is pretty long, but here it is: QE-DEF-0177 An error occurred when the action 'sqlPrepareWithOptions' status='-9' was done. UDA-SQL-0107 A custom exception occurred...

Hi everyone, I am having trouble with concatenating Campaign and CampaignNo into 1 and then make a prompt where the users can select wich Campaign they want to look at and in the prompt be able to see both the Campaign name and the CampaignNo. I created a databaseobject in my query like this...

Thank you for your help, it is working just fine after the query filters. Thanks again. BR Dudden

I am facing a problem with cascading prompts here comes the problem/what I want: 1. Prompt for a Date interval 2. Prompt for Area (multiple choice) this one should not be connected to the prompt Date, so these two are on the same page 3. New page: Prompt for Central or Local (multiple choice)...