Dynamicaly Repeating Report-content
Hi, I'm having a problem here, I'll try to explain it as clear as possible. I'm writing a report which have to show the recepie of a menu in all the available languages. So I'm passing a parameter recepieId. Now I'd like to see the report-content 3 times as English, French and Dutch are available as language. Should I work with subreports, but then how can I pass 1 value to one report, and the other ones to the next ones (as the number of languages may increase) Or Is there a way to put all this inside a table and repeat it like that? The query's for for the details of the recepies deliver the recepieId, languagueId and the description. So I can filter those on the languageId Thanks already!
October 7th, 2010 11:14am

Hello, You can group on LanguageID and for the group set Page break at the end. By this you can see the different language recepie in different pages. Hope its clear & helpful....Pavan Kokkula Infosys Technologies Limited.
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 12:01pm

Hi, If I want to apply this, all the information I want to display has to be in 1 dataset right? Because now I have different datasets for the description, the ingredients, the recepie itself...
October 7th, 2010 12:06pm

Yes, it should be in one dataset. Provide sample output from each dataset and the th otput you want in the report....Pavan Kokkula Infosys Technologies Limited.
Free Windows Admin Tool Kit Click here and download it now
October 8th, 2010 5:51am

Hi, Here is the information you requeste, I really hope you can help me out here. DS_Recepten (used to fill parameters) RecId Naam 3 gegratineerde... 4 kalfstong met ... 4 Langue de veau... DS_ReceptInfo @receptid (Gets the general info of the recept with a given id in all available languages, got id 4) RecId NrPers Description 4 4 kalfstong met... 4 4 langue de veau... DS_ReceptIngredients @receptid (Gets the ingredients of a recept with the given id in all available languages, got id 4) RecID LangID IngredList 4 1 1 kalfstong, ... 4 2 1 langue de veau, ... DS_ReceptPrep @receptid (Gets the preparation steps of a recept with the given id in all available languages,got id 4) RecID Step LangID Description 4 1 1 Kook tong... 4 2 1 Maak een ... 4 3 1 Plaats... 4 1 2 Cuire... 4 2 2 Prepar... 4 3 2 Mettez... DS_RecptExtra @receptid (Gets the extra info of a recept with the given id in all available languages, got id 4) LangId Extr 1 Serveer met... DS_Languages LangID Languagd 0 All 1 Nederlands 2 Francais 3 Nederlangs/Frans ------------------------------------------- RESULT Parameter recpetid = 4 1: Kalfstong met ... 4 Personen Ingredienten : Dutch ingredients... Bereiding : Dutch preparation steps Extra : Dutch extra 2: Langue de veau... 4 Personnes Ingredients : French ingredients Preparation : French preparation Extra : French extra (here there will be no extra, but this I can hide by myself) ------------------------------------------- But the problem is I don't now at the beginning how much languages there will be. They may add an English or a German one next week, no one knows. Thanx in andvance!
October 8th, 2010 9:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics